| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update filename
Try something like
Dim FName As String FName = "K:\Collections\Client AR\AR" & Format(Now+1, "mmddyy") & ".xls" Workbooks.Open Filename:=FName -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "odonnke " wrote in message ... I want be able to have the code update automatically. below is the code now, I need to manually update the filename every day as a new one is created everyday, how can I put in code that knows that tomorrows file will be AR042904.xls. I also need to look at the previous days file name too. Any ideas Workbooks.Open Filename:="K:\Collections\Client AR\AR042804.xls" --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a filename that will automatically update if changed. | Excel Worksheet Functions | |||
| Prevent Excel putting full filename in external links on update | Excel Discussion (Misc queries) | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| Saving filename same as import filename | Excel Programming | |||
Hybrid Mode
