Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable for workbook name
I'm sure this must be a simple one but I cannot get my stupin brain around
it! the line of code " Openbook =activeWorkbook.name" returns a string with the workbook name including the ".xls". The question is how do I strip out the ".xls" from the string? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pass variable from one workbook to another | Excel Discussion (Misc queries) | |||
Vlookup using a variable for the workbook name | Excel Discussion (Misc queries) | |||
Can not set WorkBook variable | Excel Discussion (Misc queries) | |||
How do I link to a workbook whose name is variable? | Excel Discussion (Misc queries) | |||
workbook as variable | Excel Programming |