+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Did Summer Release Break Excel Macros? in Technical; I've been troubleshooting a problem with reports since the summer release. Any report outputting results to Excel with a macro ...
  1. #1
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,115
    Thank Post
    826
    Thanked 357 Times in 281 Posts
    Blog Entries
    60
    Rep Power
    281

    Did Summer Release Break Excel Macros?

    I've been troubleshooting a problem with reports since the summer release. Any report outputting results to Excel with a macro in it fails and displays Unable to Load ExcelList.xls. Has anyone else had this?

  2. #2

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395
    Oh great, we have hundreds of Excel files laden with macros....

    I'm off work at the moment but I'll have a look tomorrow to see what happens when we do an export.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Working here...

  4. Thanks to matt40k from:

    CAM (28th August 2012)

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I just tested one and it's fine. but i'm on release 2/3. haven't taken that last one yet.

  6. Thanks to vikpaw from:

    CAM (29th August 2012)

  7. #5

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    62
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    17
    SIMS or FMS? FMS has been re-released due to changes made to macros in the first summer release.

  8. Thanks to splattthecat from:

    CAM (29th August 2012)

  9. #6
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,115
    Thank Post
    826
    Thanked 357 Times in 281 Posts
    Blog Entries
    60
    Rep Power
    281
    I don't have access to FMS. Odd, all of ours are broken. Normal lists work but any custom templates where a macro was used to generate PivotTables for example have all broken.

  10. #7
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    281
    Thank Post
    30
    Thanked 66 Times in 39 Posts
    Rep Power
    20
    Quote Originally Posted by CAM View Post
    I don't have access to FMS. Odd, all of ours are broken. Normal lists work but any custom templates where a macro was used to generate PivotTables for example have all broken.
    Stupid question but have you ticked the ‘Trust access to the VBA project object model’ in Excel?

  11. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Actually, you have checked Macros are enabled right? They're not silently blocked as part of the installation or some policy..?

  12. #9

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Haven't tried SIMS reports with macros yet, but all of my automation scripts for Individual Reports were broken, always throwing a random VBA error because of the missing IndRepBaseTemplate.dot. It used to work if you put a copy in the folder with the documents, but since summer release (possibly the release before that), Word just freezes. So, I'm back to manually sorting reports again (that thread is here if anybody has a solution! IndRepBaseTemplate.dot Causing Problems)

  13. #10

    Join Date
    Apr 2011
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Macros Failing since SIMS summer upgrade

    Quote Originally Posted by CAM View Post
    I've been troubleshooting a problem with reports since the summer release. Any report outputting results to Excel with a macro in it fails and displays Unable to Load ExcelList.xls. Has anyone else had this?
    Hi did you find a resolution for this? we are running reports for the first time since the summer upgrade and are having the same issue.

  14. #11

    Join Date
    Apr 2011
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi CAM I am not sure if this is the same issue that we are having here. Word is crashing when enabling macros in reports following the latest SIMS upgrade.

    Did you ever resolve the issue that you were having?

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] 10 Summer released
    By matt40k in forum MIS Systems
    Replies: 43
    Last Post: 7th September 2010, 02:10 PM
  2. [SIMS] 2010 Summer release
    By matt40k in forum MIS Systems
    Replies: 13
    Last Post: 24th July 2010, 12:18 PM
  3. [MS Office - XP] Excel Macro - If Cell Value
    By ahuxham in forum Office Software
    Replies: 0
    Last Post: 18th December 2009, 10:27 AM
  4. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 10:27 AM
  5. Excel Macro - Edexcel GCE Exams
    By steve in forum Educational Software
    Replies: 0
    Last Post: 16th May 2006, 02:49 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
  •