+ Reply to Thread
Results 1 to 3 of 3

Timer Macro Auto Closing Files

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Timer Macro Auto Closing Files

    My battle with an auto close timer macro continues. I have 7 files that are the exact same (except minor things are different like drop down lists). But the macros all have a user form that takes the entered data, dumps it into a worksheet table, opens a master file (in the same folder), dumps into a table.

    I added a timer this morning from another page on there. I copied the timer code from someone on this site (thank you). Let's see if I do this right:
    On a worksheet where the data table exists:
    Please Login or Register  to view this content.
    On "This Workbook"
    Please Login or Register  to view this content.
    On a Module:
    Please Login or Register  to view this content.

    I also have test workbook....just like the others where I try things out. Now that I've loaded all the code, something in this keeps trying to open worksheets. My question:
    Does "Public EndTime" have to be "public" and could it be causing the worksheets to try to open? It's so weird....I have nothing that says other worksheet names in the code. It also happens random times which makes me think it has something to do with the last time I opened the file. When the files are closed, I don't want this timer running and doing stuff.

    Suggestions please!
    Last edited by acroley1; 12-02-2014 at 12:08 PM.

  2. #2
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Timer Macro Auto Closing Files

    Here is a sample of one of the files.
    Attached Files Attached Files
    Last edited by acroley1; 12-02-2014 at 12:07 PM.

  3. #3
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Timer Macro Auto Closing Files

    So I have learned I need to stop the timer using:
    Please Login or Register  to view this content.
    But where do I put it???? Thanks
    Last edited by acroley1; 12-02-2014 at 01:27 PM.

+ 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. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  2. Adding macro into auto closing workbook
    By keepermokrad in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-28-2011, 08:25 AM
  3. VBA code auto load and auto closing
    By paraxis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2008, 04:54 PM
  4. Help with auto macro on closing
    By mr_teacher in forum Excel General
    Replies: 3
    Last Post: 05-17-2006, 08:15 AM
  5. [SOLVED] Re: Opening and closing files in a Macro
    By Henry Stock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2005, 03: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