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
 

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

writing to excel file from outlook 1
Write to excel with odb 4
Checking for open workbooks Repeat/Loop VBA code 1
Create Excel file with VBA in Access 7
Open excel file and reffer to specific worksheet 2
Excel XP & Windows Vista ?!? 6
Extract data from another database 2
Referencing another workbook using a variable for the sheet? 20

Back
Top