copying problems..........

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

Guest

i want to copy data from different workbooks(s1,s2) to s3
but without opening the worksheets(s1,s2)..
if the sheets r opened ,it works fine..
if not,it says "error"-subscription out of range..

kindly help me
 
To copy from a workbook it must be open. The only way around it is to query
the workbook with an ADO DB recordset which is a whole pile of work and
really only applies to certain circumstances. Why not just open the book and
close it when you are done?
 

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

Back
Top