copying data from an unopened file programmatically

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

Guest

Hi,

I want to copy data from an excel file to another excel file w/o having
to open the source excel file using codings. Is this possible ?


tks & rdgs
 
It might be possible using ADO (DAO??), but it's beyond me.

Why not just open the workbook, extract the data, and close the workbook.

With screenupdating=false, it may not even be noticeable by the user.
 
tks Dave for having shown me how to copy the data as values in my earlier
posting

reason for me trying to copying data and pasting it as values from an
unopened workbook is because there are many files and the users would be
complaining that they have too much to copy. and if i were to use the OS copy
command , each file is quite huge(due to the many formula in it).

anyway, tks for ur advice i'll look into ADO/DAO to see if it can be done

best rdgs,
 
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

using programming to copy worksheets data only 1
cannot open a file 5
cannot open an xl97 file 1
csrss.exe issue 3
Macro-Return Blank Cell 2
Blank cell return after each data entry 1
invoice on sheet 1 & data store on sheet 2 automatically 2
column filter 1

Back
Top