General information
Category:
COM/DCOM and OLE Automation
Environment versions
Network:
Windows 2008 Server
If you go in to Excel, turn on macro recording, and manually add a hyperlink, and then turn off macro recording, and go and examine the macro source code it generated with "edit macros" ... what does it show you?
>Hi rick no I'm afraid not.
>
>
>
>>Just a guess. Does using .FormulaR1C1 instead of .Value make a difference?
>>
>>
>>>Hi
>>>I want put some hyperlinks in a spreadsheet but when I add them they appear as text
>>>How can I add a hyperlink and have it appear as such
>>>Thanks
>>>
>>>SET STEP ON
>>>oExcel = CreateObject("Excel.Application")
>>>if vartype(oExcel) != "O"
>>> * could not instantiate Excel object
>>> * show an error message here
>>> return .F.
>>>ENDIF
>>>oWorkbook = oExcel.Application.Workbooks.Add()
>>>
>>>
>>>
>>>oExcel.Range("b2").Value = "http:/bbc.co.uk"
>>>
>>>if val(oExcel.Version) > 11
>>> oWorkbook.SaveAs("C:\temp\foobar.xls", 56) && xlExcel8
>>>else
>>> oWorkbook.SaveAs("C:\temp\foobar.xls")
>>>ENDIF
>>>
>>>oExcel.quit()
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only