Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with VBA that references current file name
I have a file that has code in it that references the file
name. Problem is when an end user gets the file they save it as another name and subsequently get a run-time error. Is there a way to change the VB references in the code to point to the new file name? Muchos Gracis if you can help, heck just thanks for reading! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with VBA that references current file name
You can always refer to the workbook containing the code with ThisWorkbook.
From that, you can get the name of the file, if needed, with ThisWorkbook.Name ' or ThisWorkbook.FullName -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "chilidog1000" wrote in message ... I have a file that has code in it that references the file name. Problem is when an end user gets the file they save it as another name and subsequently get a run-time error. Is there a way to change the VB references in the code to point to the new file name? Muchos Gracis if you can help, heck just thanks for reading! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with VBA that references current file name
If you just want to change the VB reference to the file just open the VB
editor and use the SEARCH and REPLACE feature to locate each instance of the old filename in the code and then replace it with the new file name. Rollin ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Saving only current worksheet into new file | Excel Discussion (Misc queries) | |||
Saving file as current month name automatically | Excel Discussion (Misc queries) | |||
reading from another file and pasting to current file, "combobox" | New Users to Excel | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) |