Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
Ive got thousands of hyperlinks to update in several excel datasheets. I was wondering if someone could help me out with some VBA code. We are converting our drawing database into 2 sections, live cad drawings and pdf versions of those drawings. But there are going to be 2 links for all of them.

The pdf colum currently looks something like this

text to display: ..\F--Electrical\300F15.DWG
Address: ..\F--Electrical\300F15.DWG

I need it to look like this

Text to display: pdf
Address: ..\F--Electrical\300F15.pdf

The live cad colum currently looks something like this

text to display: ..\F--Electrical\300F15.DWG
Address: ..\F--Electrical\300F15.DWG

I need it to read like this

Text to display: dwg or pdf. since these extensions are the ones currently at the ends of the link it might be possible to get rid of all but the last 3 letters.

Address: \\192.168.4.35\Server Data\Engineering\WMI Drafting_Design\(Live) Equipment Drawing Files\Dredges-Boosters\300 E.W. Ellefsen\Drawings\F--Electrical\300F15.DWG

If anyone can be of any help I would greatly appreciate it. Doing this the manual way is almost painful.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top