P
Peter
How do I backup Excel macros in Excel 97 and Excel 2003?
A
Andy Wiggins
1) Backup tape
2) CD / DVD
3) To another drive
4) To a workbook with an alternative name
But, I'm guessing there's more to your question than you've told us about
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
2) CD / DVD
3) To another drive
4) To a workbook with an alternative name
But, I'm guessing there's more to your question than you've told us about
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
C
Chip Pearson
Peter,
You can export code modules to text files. In the VBA editor,
select the module you wish to export, then go to the file menu,
choose Export, and enter a file name. But since macros are
always stored in workbooks, the simplest way is to just make a
copy of the workbook to a safe location.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
You can export code modules to text files. In the VBA editor,
select the module you wish to export, then go to the file menu,
choose Export, and enter a file name. But since macros are
always stored in workbooks, the simplest way is to just make a
copy of the workbook to a safe location.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com