Import xl syntax

[captnk]

I need help on the correct syntax to import a specific sheet from a multipage XL spreadsheet.
I have no problem where a spreadsheet is a standalone item e.g:
d:\myprog\myxlpage.xls

The problem is to reference a sheet within a multi page spreadheet
e.g
d:\myprog\myxlpage.xls?????????????
Thanx

 

[pdx_man]

Check out the TransferSpreadsheet Method in Access Help. You can name the range on the spreadsheed that you want to import and then reference that name.

 

[captnk]

Syntax

Thanks. Yes Iam using the TransferSpreadsheet method.
It works when I reference a single page spreadsheet,what I need to do is reference a "worksheet" within that spreadsheet.

Tks

 

[pdx_man]

Read the second sentence in my post. If you don't know how to name a range in XL, look up Named Ranges in the Help files in Excel. This is the only way that I know how to reference other worksheets within the workbook.