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.
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.