joemeshuggah
Board Regular
- Joined
- Jul 18, 2008
- Messages
- 161
i created a macro that includes the current date in a cell in the finished product...just realizing that if someone runs the macro on an archived report, the current date and not the date associated with the report will appear.
is there a formula or some other means to show the workbook title in a specified cell...e.g. if i open report_03-11-09.xls and run the macro, "report_03-11-09" will appear in the desired cell?
is there a formula or some other means to show the workbook title in a specified cell...e.g. if i open report_03-11-09.xls and run the macro, "report_03-11-09" will appear in the desired cell?