Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trimming worksheet name from an imported data source
I'm bringing in data from an external source that changes each month, and to
make the macro run correctly it needs to have the same name each month on the tab (I think. I'm still a novice at VBA). It's name is always the same length except for the month's name at the beginning. I'm having a little trouble getting the Trim function to work in VBA though. Can somebody help me with this? I'm sure I'm missing something easy. If it helps here's the name for the July/August worksheet: JA_20082008_CHRYSLER_300_SERIES Next month the JA will be replaced with AS for August/September. I really would appreciate your help. -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trimming Data | Excel Discussion (Misc queries) | |||
Hyperlink imported data into worksheet with dated formate | Excel Worksheet Functions | |||
how to fit imported data into one worksheet | Excel Discussion (Misc queries) | |||
how to save imported data in diffrent worksheet cel before refrehs | Excel Worksheet Functions | |||
Can worksheet data be exported/imported to/from flat file? | Excel Programming |