toys032498
asked on
TIM COTTE-200 More if you can answer this.
This is Anthony, the guy you answered the CreateObject Excel question for. It worked great. Another question though. How do I Add a data to a cell in VB that would make the Text a Hyperlink.
ExcelSheet.Cells(1, 1).Value = "\\MyServer"
If I add this to the cell in Excell 2000 it automatically assumes I want a Hyperlink. If I add it in VB it looks at it as a string.
Thank you again
ExcelSheet.Cells(1, 1).Value = "\\MyServer"
If I add this to the cell in Excell 2000 it automatically assumes I want a Hyperlink. If I add it in VB it looks at it as a string.
Thank you again
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER