Get External Data Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm inputting data from a number of named sources on an excel spreadsheet.
This means I have to do the 'Get external data' process a number of times.
Can I write a macro that will import the various named ranges from the
spreadsheet (similar to recording a macro in Excel). Or do I have to write a
Module to do this.?

Any help would be much appreciated.

Phil
 
you can do it either way but the simplest way would be to
write an access macro using the transferspreadsheet method.
 
You must log in or register to reply here.

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

Record Macros in Access 2003? 1
Removing Access External Data Queries from Excel 1
Call Access macro using Excel VBA 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Create a Macro to Import External Data 0
Import Excel to Acsess using Macro 3
500 Excel Spreadsheets 6
Macro to copy value in field and insert it into filter 2

Back
Top