V-Lookup and Macros
Posted by John DerGarabedian on June 06, 2001 10:15 AM
I have an application where I need to retrive a file name from a lookup table of 50 states (plus DC), take this result and open a file from the Internet using this file name.
I have written a macro using the auto-record feature in Excel. The problem I have is whatever state is selected when I write the macro is the state that is ALWAYS opened. In other words, the result from the lookup table is ignored by the macro. The macro simply locks in the file name that is selected when the macro is written. I need this to change as reflected by the lookup table.
Please help. THANK YOU.