HyperLink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

When a user use my program to write a report, the program saves the excel
sheet (the report) in one location (folder), the name of the excel sheet is
also saved in another workbook called "sumary".

My question is:

Is there a VB code that save the name as an HyperLink

Mike
 
Turn on the macro recorder and do Insert=>Hyperlink.

when you have the hyperlink, turn off the macro recorder, then look at the
recorded code.

This should give you the basic code you need to get started
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sheet event wait for another event? 6
Macro for all Excel Workbooks to print to PDF 2
Hyperlink Base. 1
wrong Hyperlink-Values 1
VBA Configure Proxy Server Settings of IE 0
Help with copying a sheet from One workbook to another workbook 1
need a macro to drop excel sheets that were not populated 3
SaveAs using Hyperlink/Path in a cell 1

Back
Top