+ Post New Thread
Results 1 to 14 of 14
Office Software Thread, Visual Basic Application SIMS!!! in Technical; Can anyone help, WE have now got office 1010 and everything is running fine. however SIMS is not running reports ...
  1. #1

    Join Date
    Jul 2010
    Posts
    577
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14

    Visual Basic Application SIMS!!!

    Can anyone help,

    WE have now got office 1010 and everything is running fine. however SIMS is not running reports properly. According to SIMS we need to install Excell Visual Basic Application ???

    How do i Do that?

    TIA

  2. #2
    jamesreedersmith's Avatar
    Join Date
    Sep 2009
    Location
    Ruskington
    Posts
    1,167
    Thank Post
    78
    Thanked 258 Times in 230 Posts
    Rep Power
    78
    Via add remove programs, change your office install, custom and select it to install.

  3. #3

    Join Date
    Jul 2010
    Posts
    577
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14
    Hi James,

    sorry for been thick but where abouts is it in there?

  4. #4
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    In the Office 2010 install options>Office Shared Features>Visual Basic for Applications

    Is that what you're looking for?

    When you say SIMS is not running reports properly what do you actually mean? Does it fail to load Word/Excel? Does it load it but nothing is displayed?

  5. #5

    Join Date
    Jul 2010
    Posts
    577
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14
    We click run report excell opens then we get a error saying
    repairs to 'ReportData.xml'

    This workbook has lost its VBA project, ActiveX controls and any other programmability- related reatures

  6. #6

    Join Date
    Jul 2010
    Posts
    577
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14
    In the Office 2010 install options>Office Shared Features>Visual Basic for Applications that says run from my computer

  7. #7

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    831
    Thank Post
    177
    Thanked 105 Times in 73 Posts
    Rep Power
    185
    Just do a complete install. That'll cover it!

  8. #8
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Hmm not sure how to get SIMS reports to produce an xml file as the ReportData, thought it was just a txt file.

    EDIT: Actually it does produce xls files too.. hmm have they updated their templates?
    Last edited by apeo; 14th December 2011 at 01:15 PM.

  9. #9

    Join Date
    Jul 2010
    Posts
    577
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14
    hmm have they updated their templates?

    What you mean?

  10. #10

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,802
    Thank Post
    1,295
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    If you need to enable this on a large scale (as I did when I had exactly the same issue) you can create a .mst with the office customisation toolkit which will just install that component.

  11. #11

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Quote Originally Posted by apeo View Post
    Hmm not sure how to get SIMS reports to produce an xml file as the ReportData, thought it was just a txt file.

    EDIT: Actually it does produce xls files too.. hmm have they updated their templates?
    For as long as I remember, SIMS has always produced it's reports as XML files, it's just that it converts them to whatever format you ask for before you see them usually.

    On topic - SIMS relies on VBA (Visual Basic for Applications) to produce it's reports in Word and Excel; if you don't have VBA installed, SIMS can't produce it's reports. You need to install VBA.

    - In your computer's Control Panel, find "Add/Remove Programs" (or "Programs and Features" in Win7). You'll be presented with a list of installed applications.
    - Locate Microsoft Office 2010 in the list, then look for a button labelled "Change/Remove" (it's position will vary dependant on OS).
    - A windows will pop up with an option to "Add or Remove Features"; select it and click next.
    - You'll then be presented with a list of all the Microsoft Office features available; one of these will be "Visual Basic for Applications". Right click on it and select "Run from my computer".
    - Click next to any further screens and once installation is complete, try SIMS again (you may need to restart your machine first)
    Last edited by LosOjos; 14th December 2011 at 02:53 PM. Reason: Spelling

  12. #12

    Join Date
    Jul 2010
    Posts
    577
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14
    For as long as I rememmber, SIMS has always produced it's reports as XML files, it's just that it converts them to whatever format you ask for before you see them usually.

    On topic - SIMS relies on VBA (Visual Basic for Applications) to produce it's reports in Word and Excel; if you don't have VBA installed, SIMS can't produce it's reports. You need to install VBA.

    - In your computer's Control Panel, find "Add/Remove Programs" (or "Programs and Features" in Win7). You'll be presented with a list of installed applications.
    - Locate Microsoft Office 2010 in the list, then look for a button labelled "Change/Remove" (it's position will vary dependant on OS).
    - A windows will pop up with an option to "Add or Remove Features"; select it and click next.
    - You'll then be presented with a list of all the Microsoft Office features available; one of these will be "Visual Basic for Applications". Right click on it and select "Run from my computer".
    - Click next to any further screens and once installation is complete, try SIMS again (you may need to restart your machine first)

    This is all done and still the same problem??

    Is there anything in the OCT that i could have done to disable it

  13. #13

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    Quote Originally Posted by MattDLEA View Post
    Is there anything in the OCT that i could have done to disable it
    What is the "OCT"?

    It may be worth re-installing SIMS on the machine with the problem; is it localised to one machine?

  14. #14
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Quote Originally Posted by LosOjos View Post
    What is the "OCT"?

    It may be worth re-installing SIMS on the machine with the problem; is it localised to one machine?
    I imagine it means Office Customisation Toolkit, and if you've disabled it in your deployment then you would see that when you check in add/removes which you've already stated is installed.

    Try reinstalling sims apps and office pia.

    @LosOjos: AFAIK on our systems its always produced an xls, txt or doc file as the ReportData (the file used to store data) and then launch office app, using macros to pull the data out. Thats how i thought it worked but I must say I haven't seen ReportData.xml in the tmpSimsRpt folder before. Funny, maybe I missed it.
    Last edited by apeo; 14th December 2011 at 03:40 PM. Reason: Meant to say haven't seen

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 8
    Last Post: 13th June 2011, 06:23 PM
  2. Visual Basic for Applications
    By pyrott in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 5th January 2011, 03:44 PM
  3. visual basic 2005 beta 2 tutorials ?
    By mac_shinobi in forum Coding
    Replies: 4
    Last Post: 14th December 2006, 09:43 PM
  4. LDAP & Visual basic 2005 ??
    By mac_shinobi in forum Coding
    Replies: 9
    Last Post: 10th January 2006, 10:13 PM
  5. Best manuals for Visual Basic .NET?
    By kingswood in forum Coding
    Replies: 6
    Last Post: 3rd October 2005, 10:41 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •