Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to call the name of current file
Hi,
I was wondering if anybody knew the VBA code to call the name of th excel file that contained the module a macro was in? My issue is that the name of the file changes every month so using Windows("210 Product Expense Report - August Close.xls").Activate wont work in september. I was just wondering if there was a way to d this without using Inputbox and just entering the correct name eac month. Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to call the name of current file
ThisWorkbook will always return a reference to the workbook
containing the code. Therefore, you can do something like ThisWorkbook.Activate ' or Windows(ThisWorkbook.Name).Activate -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Phatchef24 " wrote in message ... Hi, I was wondering if anybody knew the VBA code to call the name of the excel file that contained the module a macro was in? My issue is that the name of the file changes every month so using Windows("210 Product Expense Report - August Close.xls").Activate wont work in september. I was just wondering if there was a way to do this without using Inputbox and just entering the correct name each month. Thanks! --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to call the name of current file
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Column above current cell dynamically using function call | Excel Worksheet Functions | |||
How do I call current computer time to a cell? | Excel Worksheet Functions | |||
how can i call sub or function in vba code | Excel Discussion (Misc queries) | |||
call a procedure using current inputs | Excel Programming | |||
changing current directory to that of the current open file | Excel Programming |