How do I import data from a closed Excel Spreadsheet?

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

Guest

Hi, how do i import data from a closed Excel spreadsheet into an open Excel
spreadsheet? (wihtout having to open the source file spreadheet)
 
Thanks for the link Gromit but I don't know how to program VBA or Macros and
so this method may be overly ambitious for me, especially as the document
mentions "The macro example assumes that your VBA project has added a
reference to the ADO object library". I don't even know what is an ADO?

Can you think of any simpler method that uses the commands within the Excel
menu like Data "Import External Data" or something similar. That could make
it easier to implement for excel dummies like me.

Many thanks for your time and help. Tom
 

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

Linked Spreadsheets in Excel 2003 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Excel spreadsheets opening at top instead of bottom. 4
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
World Cup spreadsheet for football fans 2
collate data Vlookup? 1
scroll automatically as data is imported into a spreadsheet 1
How do I import multiple spreadsheets into the same spreadsheet? 1

Back
Top