LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reading Multiple Files BadBoy Excel Worksheet Functions 5 January 15th 10 06:26 PM
Reading Cell Address in VBA Richard Excel Discussion (Misc queries) 2 April 15th 08 06:33 PM
Reading dbf files Luis Verme Excel Discussion (Misc queries) 6 July 1st 05 01:32 AM
Problems with reading files Philipp Oberleitner[_2_] Excel Programming 0 July 9th 04 05:04 PM
Reading all files in a folder H. Rye Excel Programming 1 January 20th 04 02:15 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"