Hyperlink to Web Excel File

I created a hyperlink using the concatenate function, depending on the link name determines the time frame for the data I want to open.

Is there a way to program a macro to open a hyperlink that changes. For example one day the hyperlink may be http://data2006.xls and the next time I may want it to be http://data1999.xls

the problem I'm running in to is that when I run a macro it records the specific hyperlink address

Please Login or Register  to view this content.

I need that Workbook.Open Filename to = a cell where I can change the values. For instance you see QQQQ in the above code, I want the path to change if I delete QQQQ from cell A1 and place IBM there instead because right now every time I run the macro it will bring back the same data every time regardless of what the actual hyperlink in the cell is since the link is in the code.

Thanks for the help

Hello ajs349,

Using a hyperlink in this fashion in VBA is a convoluted. Here is a macro that will allow you to construct a web address string and launch the browser automatically to open it.

Please Login or Register  to view this content.

Example
Cell A1 points to the specific file on the web site.
Cell A2 concatenates the web address.

Please Login or Register  to view this content.

To Install the Macro:
1. Copy the Macro code above using CTRL+C
2. Open Excel and Right Click on any Sheet Tab
3. Click on View Code in the pop up menu
4. Use ALT+I to activate the VBE Insert Menu
5. Press the letter m to insert a Standard Module
6. Paste the macro code using CTRL+V
7. Save the macro using CTRL+S
8. Close the VBE and return to excel using ALT+Q

Sincerely,
Leith Ross