| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filename Issue
I am writing a program where I prompt the user to save as: filename. Later on I want to reference that workbook and pull a few cells out o it. If I new the file name I would write: Workbooks("book1.xls).Sheets("Sheet1").Range("A1") .Value but since I don't know the filename I don't know how to reference it. I would think it would be something like: Workbooks(filename).Sheets("Sheet1").Range("A1").V alue or something bu it isn't working for me. While the sheet is open should I do a "find root directory and fil name" routine and some how name that "filename"? Any help would be appreciated. Zeroma -- Zeroma ----------------------------------------------------------------------- Zeroman's Profile: http://www.excelforum.com/member.php...fo&userid=1662 View this thread: http://www.excelforum.com/showthread.php?threadid=31495 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Filename reference in Spreadsheet XML issue | 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 | |||
| Macro link issue when saving as new filename. | Excel Programming | |||
| Saving filename same as import filename | Excel Programming | |||
Threaded Mode
