+ Reply to Thread
Results 1 to 2 of 2

Workbook won't display after macro is complete (works just fine in Excel 2010, 2007)

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    California
    MS-Off Ver
    2013
    Posts
    1

    Workbook won't display after macro is complete (works just fine in Excel 2010, 2007)

    Hi all,
    We are transitioning to Office 2013 and in the process I have noticed a macro is not working as expected like it did in Office 2010.

    The Process:
    A user exports an SSRS (SQL Server Reporting Services) report into Excel, then they click a link within the report that opens the macro file with that launches itself via the Auto_Open function. The macro finds the exported SSRS report and begins its work. When complete the user is prompted to close the macro file. Typically the final report is displayed and the user can continue their work. We have been using this method for 2 years now with no issues in Office 2010 or 2007.

    While processing I keep the user informed of the macro progress by posting updates on a specific macro tab.

    The Problem(s) only in Excel 2013:
    1. The updates I am providing the user do not show up. just a blank Excel window.
    2. The final product, the modified SSRS report, is not displayed after the user closes the macro file. I know the completed file exists and I can see it in the Project window if I have the Developer window open.

    I'm sure these two issues are related.

    I always use the Aplication.ScreenUpdating = False at the beginning of my macros, and Application.ScreenUpdating = True at the end to help speed the processing of my macros. I have noticed that if I disable this (remark it out) that the problem still persists, AND the screen will still not update while the macro is processing.

    I have extensive VBA expierence and this issue is quite baffeling. Like I said, this macro works perfectly in Excel 2007 and 2010.

    Any help at all would be greatly appriciated.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Workbook won't display after macro is complete (works just fine in Excel 2010, 2007)

    Excel 2013 is troubling. I have had a plethora of issues with it on simple things were it just wouldnt function properly. I even remember one where I explicitly called out the workbook name, sheet name and made it hidden. One line of code and it would NOT work in 2013 and worked fine in 2010.

    Good luck, I didnt even find a resolution to most of my 2013 issues, except check for udpates to your pc with "Windows Updates"
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Workbook does not work in excel 2007, but is fine in 2010
    By cath1509 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 02:59 PM
  2. [SOLVED] CheckBoxes.Add Works fine in 2010 but not 2007 or 2003
    By Jakeman92 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-18-2013, 05:17 AM
  3. Replies: 0
    Last Post: 09-05-2012, 10:19 AM
  4. code that works fine in excel 2007 ie ver 7 not in excel 2010 ie ver 9
    By ycg0311 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-25-2012, 11:56 AM
  5. Macro works fine in Excel 2003 but not in 2007
    By jackdebnam in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2011, 12:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1