excel worksheet from access

  • Thread starter Thread starter ciccio
  • Start date Start date
C

ciccio

hello,I open an excel worksheet from a link in a Form
\\server\data\test.xls#sheet1!$A$1

this link works if the sheet name is a full name without spaces.


\\server\data\test.xls#sheet one!$A$1
\\server\data\test.xls#'sheet one'!$A$1
'\\server\data\test.xls#sheet one!$A$1'
These links open the excel file but open on the last sheet used
(wrong) with an error message (invalid argument)

can you help me
thanks Ciccio
 
hello,I open an excel worksheet from a link in a Form
\\server\data\test.xls#sheet1!$A$1

this link works if the sheet name is a full name without spaces.

\\server\data\test.xls#sheet one!$A$1
\\server\data\test.xls#'sheet one'!$A$1
'\\server\data\test.xls#sheet one!$A$1'
These links open the excel file but open on the last sheet used
(wrong) with an error message (invalid argument)
Click to expand...

solution is \\server\data\test.xls#sheet?one!$A$1
 
Back
Top