Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open file from address in a cell
Let's say that the value of cell A1 was "C:\Work Documents\David's
Folder\Schedule.xls" and I wanted to click a button to run a macro that open's the file referenced in A1. Is that possible and if so how can it be done? The value of A1 would change continually so the macro could not always reference "C:\Work Documents\David's Folder\Schedule.xls" for example. Many thanks. -- David P. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open file from address in a cell
Try
Workbooks.Open Filename:=Sheets("Sheet1").Range("A1").Value Mike "David P." wrote: Let's say that the value of cell A1 was "C:\Work Documents\David's Folder\Schedule.xls" and I wanted to click a button to run a macro that open's the file referenced in A1. Is that possible and if so how can it be done? The value of A1 would change continually so the macro could not always reference "C:\Work Documents\David's Folder\Schedule.xls" for example. Many thanks. -- David P. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open file by inputting file name in cell? | Excel Discussion (Misc queries) | |||
when i try to open the file it show too many different cell forma. | Excel Worksheet Functions | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
How can I link a pdf file (address) to an Excel cell | Excel Discussion (Misc queries) | |||
insert file address to open graphic | Excel Discussion (Misc queries) |