Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro than refers to a cell?
At the moment i have a macro that runs when I click a picture in my worksheet
(worksheet1) this macro opens another workbook called phone book. What I would like is for a cell in worksheet2 to tell the macro which file to open by the file adress it contains. To sum it up if A1 (worksheet2) = C:\Documents and Settings\Keith\Desktop\daily reports\ important files\ phonebook then the macro looks in the stated file and opens the workbook "phonebook" if I change the location of phonebook i want to be able to put it new location in A1 (worksheet2) and the macro then automatically looks there. is this possible? if not how else could it be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro than refers to a cell?
As ALWAYS, post your code for comments.
-- Don Guillett Microsoft MVP Excel SalesAid Software "jackrobyn1" wrote in message ... At the moment i have a macro that runs when I click a picture in my worksheet (worksheet1) this macro opens another workbook called phone book. What I would like is for a cell in worksheet2 to tell the macro which file to open by the file adress it contains. To sum it up if A1 (worksheet2) = C:\Documents and Settings\Keith\Desktop\daily reports\ important files\ phonebook then the macro looks in the stated file and opens the workbook "phonebook" if I change the location of phonebook i want to be able to put it new location in A1 (worksheet2) and the macro then automatically looks there. is this possible? if not how else could it be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check whether another sheet refers to cell in current | Excel Discussion (Misc queries) | |||
Value in cell refers to value in another cell | Excel Worksheet Functions | |||
how do i copy format which refers to every OTHER cell | Excel Worksheet Functions | |||
How do I keep the format of a cell that an if statment refers to? | Excel Discussion (Misc queries) | |||
How can I keep the original value in a cell that refers to anothe. | Excel Worksheet Functions |