| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening New Work with Wedpage Content when address is in original workbook
This is simplification I have original worksheet which has cells in it that were created by a macro similar to the following: Range("D2").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ "http://finance.yahoo.com/q/cq?s=msft&d=v2" _ , TextToDisplay:="MicroSoft Stock" What I would like to do is create a macro or a function such that cell E2 will have the text value E2 = http://finance.yahoo.com/q/cq?s=msft&d=v2 TIA R. Mishelof |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening workbook - get error message : unreadable content, lostvbproject | Excel Programming | |||
| how can change the original address to hyperlink in the Excel? | Excel Discussion (Misc queries) | |||
| copying worksheets to a new workbook without formulae referencing original workbook | Excel Programming | |||
| Opening an excel workbook doesnt work | Excel Programming | |||
| Marcro does not work when original workbook is deleted | Excel Programming | |||
Threaded Mode
