Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting portion of filename
I have a macro that creates a series of workbooks named in the format
"Daily yyyy mm dd" which works fine. My daily worksheets require a column headed by the date and another column headed by the preceding day's date. That column links to the prior day's worksheet to bring forward end of the day values. I'm a newbie (retired CPA) at VBA and would appreciate suggestions about how to extract the right 10 characters of the file name and convert them to a date in cell c1 on sheet 1. Many thanks Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SaveAs Filename:=filename, FileFormat:=xlCSV | Excel Programming | |||
Buttons in lower portion of workbook appear in upper portion | Excel Programming | |||
Extracting A Portion Of A String | Excel Programming | |||
Extracting filename | Excel Programming | |||
extracting a stringvalue from filename | Excel Programming |