+ 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,090
    Thank Post
    821
    Thanked 354 Times in 278 Posts
    Blog Entries
    60
    Rep Power
    280

    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,135
    Thank Post
    1,908
    Thanked 1,343 Times in 742 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,392
    Thank Post
    368
    Thanked 637 Times in 519 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,848
    Thank Post
    671
    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
    61
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    16
    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,090
    Thank Post
    821
    Thanked 354 Times in 278 Posts
    Blog Entries
    60
    Rep Power
    280
    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,848
    Thank Post
    671
    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,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 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
  •