Hyperlink Subaddress-Excel

n52202

New member
Local time
Today, 08:16
Joined
May 21, 2012
Messages
1
Having issues with a Hyperlink Subaddress on a form. I have an XLSX file with a tab name of 09-footnote that I would like to open from Access and open it to cell A1 on the tab 09-Footnote. I get a Microsoft error of "Reference is not valid."

I have used the following on the Property sheet of the Command Button
Hyperlink Address = C:\Tab.xlsx
Hyperlink Subaddress = '"09-Footnote"'!a1 (That's a single quote, double quote 09-Footnote Double quote,single quote)

I can get it to work properly if I change the tab name to 09Footnote by using :
Hyperlink Address = C:\Tab.xlsx
Hyperlink Subaddress = 09Footnot!a1 (No quotes or double quotes)

Any ideas on how to make this work with a dash in the tab name?

Thanks in advance.
 

Users who are viewing this thread

Back
Top Bottom