pboltonchina
Well-known Member
- Joined
- Apr 24, 2008
- Messages
- 1,104
Hi,
I currently have a macro that searches an excel workbok for part numbers, returns all the results of the sheet names that contain that number to a single page, and then hyperlinks from that single results page to the all the sheets where the number was found. Would it be possible to run another macro that would search an external folder (on the same network drive) for a drawing that matches that part number and insert a hyperlink on the results page, maybe in the same row as the result, to that drawing. Bearing in mind that some drawings contain more than one sheet, i.e. 100100200.1, 100100200.2, in that case I would like to link ALL drawings.
I appreciate it's a tall order, and it's something I would LIKE to be able to do, I don't HAVE to do it, but I would be grateful of any help
Thanks for looking at my post
Kind Regards
Paul
<!-- / message --><!-- edit note -->
I currently have a macro that searches an excel workbok for part numbers, returns all the results of the sheet names that contain that number to a single page, and then hyperlinks from that single results page to the all the sheets where the number was found. Would it be possible to run another macro that would search an external folder (on the same network drive) for a drawing that matches that part number and insert a hyperlink on the results page, maybe in the same row as the result, to that drawing. Bearing in mind that some drawings contain more than one sheet, i.e. 100100200.1, 100100200.2, in that case I would like to link ALL drawings.
I appreciate it's a tall order, and it's something I would LIKE to be able to do, I don't HAVE to do it, but I would be grateful of any help
Thanks for looking at my post
Kind Regards
Paul
<!-- / message --><!-- edit note -->