Results 1 to 6 of 6

Advanced VBA-Use IDE to insert & run code in a new workbook after ThisWorkbook closed?

Threaded View

mc84excel Advanced VBA-Use IDE to... 05-29-2013, 11:37 PM
Kyle123 Re: Advanced VBA-Use IDE to... 05-30-2013, 03:52 AM
mc84excel Re: Advanced VBA-Use IDE to... 05-30-2013, 08:17 PM
Kyle123 Re: Advanced VBA-Use IDE to... 05-31-2013, 06:57 AM
mc84excel Re: Advanced VBA-Use IDE to... 06-02-2013, 08:44 PM
mc84excel Re: Advanced VBA-Use IDE to... 09-13-2013, 12:03 AM
  1. 05-29-2013, 11:37 PM #1
    mc84excel is offline
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Cool Advanced VBA-Use IDE to insert & run code in a new workbook after ThisWorkbook closed?

    The thread title says it all.

    I want to run code after ThisWorkbook is closed. Can ThisWorkbook use VBA to create a (temporary) new workbook, insert code module into the new WB and then use Application.OnTime to fire this new module code shortly after the ThisWorkbook closed?
    Attached Files Attached Files
    Last edited by mc84excel; 06-02-2013 at 10:40 PM. Reason: correct terminology
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1