Saving a file with VBA that references current file name

  • Thread starter Thread starter chilidog1000
  • Start date Start date
C

chilidog1000

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!
 
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 (e-mail address removed)
 
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
 
Back
Top