Is it possible to read a macro file like reading a text file? FOr example from a macro file in an excel file, i want to read a macro that is included/recorded in another excel file, is that possible?
Printable View
Is it possible to read a macro file like reading a text file? FOr example from a macro file in an excel file, i want to read a macro that is included/recorded in another excel file, is that possible?
Yes, I even have a CodeBank entry for reading/modifying macro module, class, and user form code. Its similar when doing it from within Excel.
http://www.vbforums.com/showthread.php?t=313861