|
|
#6
09-05-2023, 08:23 PM
|
||||
|
||||
There will be a Catch 22 with implementing that idea: Not possible to delete the file while it is open AND the file needs to be open while the macro is running.
The usual method to do this would be to create the macro and store it in a different workbook (or your Personal.xlsb) so the code never resides in the template workbook.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
| Tags |
| delete module, macro help |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 A few macros or functions run in a single macro?
|
pentagram_31 | Word VBA | 15 | 10-29-2018 01:46 PM |
|
Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs
|
Btop | Word VBA | 26 | 03-07-2018 01:45 PM |
| URGENT: Macro to open document and apply other macros successively | Krategy | Word VBA | 1 | 12-02-2016 04:41 PM |
| VBA Powerpoint Macros: Set String in one Macro, use it in another | Martijn6134 | PowerPoint | 0 | 11-09-2016 05:36 AM |
| Macro to find a word in first row of table and then perform two macros | hmsrose | Word VBA | 5 | 01-30-2015 12:17 AM |
Windows 10 
Office 2016
Threaded Mode