Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic filename
mystring = Workbooks("SupportTemplate.xls").Sheets
("WorkOrders").Range("I2").Value In the above code, is there a way to make the filename of the spreadsheet (SupportTemplate.xls) link dynamically to the name of the spreadsheet. Thus, if the spreadsheet name changes, the reference in the code changes as well. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Hyperlinks - Changing Folders and Filename | Excel Worksheet Functions | |||
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 | |||
Dynamic Filename From Macro | Excel Programming |