Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Word VBA string in Excel macro?
I write reports in Word and save them using a Word VBA macro, which pulls
certain bits of info from the doc and puts them together in a string to specify file path and name. Then I need to put a hyperlink to that doc on my worksheet. How easy would it be to use the Word file path/name string as my hyperlink string in Excel? (I'm trying to save having to navigate through folders to the doc each time I use Ctrl+K. Also, the path link is long and always truncated in the dialog box, so I have to manually massage each one. A string in a macro seems easier.) Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Word VBA string in Excel macro?
It’s very easy. From the Main Menu go to Insert--Hyperlink and th
window you need will appear. It should be pretty intuitive from there - Piku -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Word VBA string in Excel macro?
That's basically what I'm doing now - except I use the keyboard shortcut
(Ctrl+K). I am not having problems getting the hyperlink into the spreadsheet, except I have to use the whole document path and name, and it's so long it truncates in the dialog box window, and I have to add in the missing info every time. I have 89 more to do today. Since I create the string I would use for this in Word when I save the doc via Word macro, I'm wondering if there's a way I can get that string to migrate from Word VBA to Excel VBA and use it in an Excel macro to programmatically insert the hyperlink. Ed "pikus " wrote in message ... It's very easy. From the Main Menu go to Insert--Hyperlink and the window you need will appear. It should be pretty intuitive from there. - Pikus --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how we find specific word from string in excel and compaire it. | Excel Worksheet Functions | |||
Converting list of numbers in Excel to a string of text in Word | Excel Discussion (Misc queries) | |||
Frequency of a word string in an excel database | Excel Discussion (Misc queries) | |||
Pull last word from a text string in Excel | Excel Worksheet Functions | |||
How can delete the duplicate word from a string in cell in EXCEL | Excel Discussion (Misc queries) |