excel worksheet from access

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

Mail Merge Help 1
Embed the same Excel multiple times 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Referencing another workbook using a variable for the sheet? 20
Merging from an Excel file with graphics 1
Checking for open workbooks Repeat/Loop VBA code 1
Linking an Excel sheet to an object frame in a report 0

Top