Can you put the file name in a certain cell.
For Example:
File Name = C:My DocumentsContents.xls
In the contents.xls file, I would like cell D4 to equal the file name ("contents") without the full path and without the file extension. Same way that it can be display as a header.
lenze:
Your code:
Range("$A$1").Value=ActiveWorkbook.Name works, but Is there a way to remove the file extention (".xls") also?
Thanks for your help.
Chad
This message was edited by eilersca on 2002-05-07 09:01
For Example:
File Name = C:My DocumentsContents.xls
In the contents.xls file, I would like cell D4 to equal the file name ("contents") without the full path and without the file extension. Same way that it can be display as a header.
lenze:
Your code:
Range("$A$1").Value=ActiveWorkbook.Name works, but Is there a way to remove the file extention (".xls") also?
Thanks for your help.
Chad
This message was edited by eilersca on 2002-05-07 09:01