Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading files according to the web address in the datasheet
Hi, I need your help...please!
I am trying to make a very crude macro that opens workbook according t the address at the top of the column. The macro takes the address paste it to the address bar to open that workbook. Then takes a numbe out of that and compares it to original next to the address. BUT, I can't seem to make the hyper link change according to address. It always opens the same workbook that I wrote the macro with. I am no expert in VB, but patient and persistant enought to work it ou with your help!! Is there a better way of doing this? Thanks in advance Nic -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading files according to the web address in the datasheet
Try using the Hyperlink worksheet function.
-- Regards, Tom Ogilvy "nickyboy " wrote in message ... Hi, I need your help...please! I am trying to make a very crude macro that opens workbook according to the address at the top of the column. The macro takes the address, paste it to the address bar to open that workbook. Then takes a number out of that and compares it to original next to the address. BUT, I can't seem to make the hyper link change according to address. It always opens the same workbook that I wrote the macro with. I am no expert in VB, but patient and persistant enought to work it out with your help!! Is there a better way of doing this? Thanks in advance Nick --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading files according to the web address in the datasheet
thanks tom,
i actually found out I was trying to do something really complicate when I didnt need to use hyperlink at all. I was just going it abou it the wrong way! but thanks for the advice all the same nic -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading Multiple Files | Excel Worksheet Functions | |||
Reading Cell Address in VBA | Excel Discussion (Misc queries) | |||
Reading dbf files | Excel Discussion (Misc queries) | |||
Problems with reading files | Excel Programming | |||
Reading all files in a folder | Excel Programming |