Link to home
Start Free TrialLog in
Avatar of toys032498
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
Avatar of toys032498
toys032498

ASKER

Edited text of question.
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks