+ Reply to Thread
Results 1 to 3 of 3

Refresh macro stops working when combined with another macro

  1. #1
    Registered User
    Join Date
    10-26-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Refresh macro stops working when combined with another macro

    I have created a macro to save my excel workbook as a .csv every 5mins, however I would also like to refresh the workbook before each save.

    To do this, I have a 'refresh' macro and a 'repeated saving' macro (Shown below)

    Both Macros work when used separately, however the workbook will not refresh when the macros are combined.

    Any ideas why this is?

    Refresh Macro:

    Please Login or Register  to view this content.
    Repeated saving macro:

    Please Login or Register  to view this content.
    Edit: I've since created a vbscript to do what i wanted instead of using macros, but im still curious as to why this doesnt work.
    Last edited by Spaaacce; 10-26-2015 at 04:06 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Refresh macro stops working when combined with another macro

    Not sure why it doesn't work. What if you just ActiveWorkbook.RefreshAll directly in the RefreshSaveCSV procedure?
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    10-26-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    2
    Quote Originally Posted by AlphaFrog View Post
    Not sure why it doesn't work. What if you just ActiveWorkbook.RefreshAll directly in the RefreshSaveCSV procedure?
    Please Login or Register  to view this content.
    Yeah i tried that and its still doesnt work... Not sure what could be stopping the refresh once its added along with the rest of the code.

+ 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. Macro stops working at 00:03H
    By mjcordeiro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2013, 03:13 PM
  2. Macro stops working just before 12 midnight
    By jjbexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2013, 12:06 PM
  3. [SOLVED] Macro stops working when I go to a different worksheet
    By gandrea in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2012, 01:40 PM
  4. Macro stops working when re-opened
    By BarryDragon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-30-2011, 09:01 AM
  5. Macro suddenly stops working
    By Ahoette01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2010, 05:58 PM
  6. Macro stops working on row
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-23-2010, 04:39 AM
  7. Saving as stops macro working
    By Denzil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-04-2008, 07:21 AM
  8. macro randomly stops working
    By johnlengacher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 02:50 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