Transfer spreadsheet

G

Guest

in transfer spreadsheet where to you name the spreadsheet.


I have 4 active datasheets in 1 excel Document

named: Chart, data 2005, data 2004, customers

I just want to import the 2004 data not every sheet
 
G

Guest

See Help on TransferSpreadsheet in VBA Help.

The last argument of the TransferSpreadsheet method is the range. It can be
a specific cell range A1:G200 or it can be a range name, or the name of the
sheet.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to transfer the data from userform to spreadsheet for specific dates 0
Microsoft Works to Microsoft Office 6
Issue is facing on Word 2016 -{EMBEDED Excel.Sheet.12} 0
How can I transfer data from Excel to Access dBase 1
Excel Excel spreadsheets opening at top instead of bottom. 4
Export Data from an access table to a pre-formatted excel template 1
Importing Specific Tabs using macro 2

Top