| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Insert a link to a pdf file
Want to insert a link to a pdf file on the server.
I have opened workbook and i know how to copy/paste the value of a cell from this workbook into another workbook file, with a macro. But cant get it to copy a link to the pdf-file generated in the opened workbook. Generated value. Would like it to insert a link to a file here. Code:
Worksheets(1).Range("G1") = Format(a) * 100
Code:
wbTarget.Sheets(1).Range(bogstav & DatoID).PasteSpecial |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert a link to a pdf file
kima wrote:
Want to insert a link to a pdf file on the server. I have opened workbook and i know how to copy/paste the value of a cell from this workbook into another workbook file, with a macro. But cant get it to copy a link to the pdf-file generated in the opened workbook. Generated value. Would like it to insert a link to a file here. Code: -------------------- Worksheets(1).Range("G1") = Format(a) * 100 -------------------- Send to the wbTarget file. Code: -------------------- wbTarget.Sheets(1).Range(bogstav & DatoID).PasteSpecial -------------------- Try something like this: wbTarget.Sheets(1).Hyperlinks.Add _ Anchor:=wbTarget.Sheets(1).Range(bogstav & DatoID), _ Address:="//server/path/file.pdf" -- The price tags on the things I need are getting bigger by the day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink Link Field to link to file on website | Excel Programming | |||
| Can I insert a link to picture that refreshes when image file cha | Excel Discussion (Misc queries) | |||
| how do i insert a code bar or link to a adobe designer file | Excel Worksheet Functions | |||
| Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
| How do I insert in a cell a link to display a JPG file in window | Setting up and Configuration of Excel | |||
Linear Mode
