| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable for workbook name
OpenBook = ActiveWorkbook.Name
OpenBook = Left(OpenBook,Len(OpenBook)-4) -- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable for workbook name
"Mervyn Thomas" wrote in message ... 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? Openbook = Left$( Openbook, Len( Openbook) - 4) Iain King |
| Reply |
| 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 | |||
Linear Mode
