Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
Workbook file name. How do I call it up for use in a macro?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
ActiveWorkbook.Name
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
Thanks.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
If you want just the file name with no path information, use ActiveWorkbook.Name ' or ThisWorkbook.Name If you want the full file name including path information, use ActiveWorkbook.FullName ' or ThisWorkbook.FullName ActiveWorkbook refers to the workbook that is active in Excel, regardless of which workbook contains the code. ThisWorkbook always refers to the workbook that contains the code, regardless of what workbook might be active in Excel. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 9 Dec 2008 05:33:13 -0800 (PST), Fan924 wrote: Workbook file name. How do I call it up for use in a macro? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
Nice. Thanks for the details on ActiveWorkbook & ThisWorkbook
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
I hope you don't mind me 'piggy-backing' on your question Fan924, but I'm looking for the file name, but it's nither the ActiveWorkbook nor ThisWorkbook. I'm trying to avoid opening each workbook to get verification inside the file, because the open/close happening across the network takes too long... Can you all expand a little more on this? Thanks! John "Chip Pearson" wrote: If you want just the file name with no path information, use ActiveWorkbook.Name ' or ThisWorkbook.Name If you want the full file name including path information, use ActiveWorkbook.FullName ' or ThisWorkbook.FullName ActiveWorkbook refers to the workbook that is active in Excel, regardless of which workbook contains the code. ThisWorkbook always refers to the workbook that contains the code, regardless of what workbook might be active in Excel. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 9 Dec 2008 05:33:13 -0800 (PST), Fan924 wrote: Workbook file name. How do I call it up for use in a macro? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
Not sure what you are asking.
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook file name
I have a post from this morning that explains it a little better. Haven't
gotten it to work yet... :o( Post: fname = Dir() returns and 'invalid procedure call or argument' 12/10/08 Have a good one... John "Fan924" wrote: Not sure what you are asking. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove file Protection from an Excel workbook file from others | Excel Discussion (Misc queries) | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
having the same workbook in different file | Excel Worksheet Functions | |||
"Workbook" file | Excel Worksheet Functions | |||
Is Workbook read-only because of file permission or because file is already opened? | Excel Programming |