coding Excel from Access

J

JT

In my database is a form used to download a txt file using FTP. So far so
good. I then want to open this file in Excel and manipulate it. When I do
this (with screenupdating turned on) it runs ok. If I use the same code and
run it from Excel, it runs much much faster.

I know I should probably build the form in Excel and run everything from
Excel but I was wondering why it runs slower from Access.

Thanks for the help.......
 
Top