get the hyperlink of a cell in excel using aotumation

u-sef

New member
Joined
Jul 3, 2009
Messages
3
Programming Experience
Beginner
Hi all

I made a project of autmation of Excel by adding reference type liberary of MS Excel and I cauld read and write to the cells

but

I can't get or set the hyperlink of the cells
How can I access the hyperlinks either to a website or to a file on local machine?

also if possible, can any one get me some materials (books,... etc) about how to automate MS-office. or other types such as PDFs?
the main barrier is that the members and methods in these liberaries have poor intellisence so that there is no explanation how to use this method or even what it is used for?
 
Top Bottom