File ID name in Excel
Hello Tech Support,
I am writing a macro in excel 2003: I want to be able to use a macro command that will identify the file name I am currently working in a given cell. Is there a macro code I can use that will identify the name of the file I am currently working in? Thank you for your help. Rene' |
File ID name in Excel
Hi
Try this: Range("A1") = ActiveWorkbook.Name Regards, Per "Rene''48" skrev i meddelelsen ... Hello Tech Support, I am writing a macro in excel 2003: I want to be able to use a macro command that will identify the file name I am currently working in a given cell. Is there a macro code I can use that will identify the name of the file I am currently working in? Thank you for your help. Rene' |
File ID name in Excel
Hi Rene
Try using ActiveCell.Parent.Parent.Name Hope this helps, -- A. Ch. Eirinberg "Per Jessen" wrote: Hi Try this: Range("A1") = ActiveWorkbook.Name Regards, Per "Rene''48" skrev i meddelelsen ... Hello Tech Support, I am writing a macro in excel 2003: I want to be able to use a macro command that will identify the file name I am currently working in a given cell. Is there a macro code I can use that will identify the name of the file I am currently working in? Thank you for your help. Rene' |
All times are GMT +1. The time now is 06:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com