Is it possible to use a vba macro to delete other macros?

Guessed · #1 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.

BYahr · #2 09-07-2023, 11:19 AM

That takes me back to a problem I have tried to get around before. How to call to the workbook from the personal.xlsb when the workbook's name is different each day.

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