Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User prompted date to open file
Hi, I have code to open yesterday's file from scheduled reports but I need
one where the user can enter the date of the file they require to open. The current code is:- basename = "Report15DetailProbability" yesterday = Format(Date - 1, "yyyymmdd") NewName = basename & yesterday ' ChDir "Z:\" Workbooks.Open Filename:="Z:\" & NewName & ".csv" Would an inputbox do this. Thanks in advance. Davie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User is not prompted to update links when opening spreadsheet | Excel Worksheet Functions | |||
User replaces existing file with blank during file open | Excel Discussion (Misc queries) | |||
User not being prompted to enter Password to modify Excel 2003 | Excel Discussion (Misc queries) | |||
not being prompted that user has file open | Excel Discussion (Misc queries) |