Excel Hyperlink formula formatting issue
After each test run I am saving my results to Excel. I save one set of results in the CurrentInputFile whose value is something like "C:\Test.xls"
Within Test.xls I add a Sheet with MyTimeStamp (variable) as the name.
In the "Master" summary file, I roll up all the totals from each individual CurrentInputFile and would like to add a Hyperlink to the CurrentInputFile, linking directly to the MyTimeStamp sheet.
I was able to add simple Hyperlinks to my file (i.e. web link), but when I try to expand it for my needs, I am getting "Invalid prodedure call or argument"
Any help would be greatly appreciated.
<font class="small">Code:</font><hr /><pre>Set objLink
SummarySheet.Hyperlinks.Add(objRange,CurrentInputF ile & "#'" & MyTimeStamp & "
'!" & "A1", Date) </pre><hr />
Re: Excel Hyperlink formula formatting issue
What do you mean by expanding?