View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chilidog1000 Chilidog1000 is offline
external usenet poster
 
Posts: 2
Default 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!