automation

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

Guest

I have an Excel file that has ten tabs. Everyday I import data from ten
different queries from Access into these tabs by copy and paste method. Is
there any way of automating the transfer so that I don't have to manually do
it. It will not only save my time but will result in less errors also.
Thanks a lot!

Purnima Sharma
 
Purnima Sharma said:
I have an Excel file that has ten tabs. Everyday I import data from ten
different queries from Access into these tabs by copy and paste method. Is
there any way of automating the transfer so that I don't have to manually do
it. It will not only save my time but will result in less errors also.
Thanks a lot!

Purnima Sharma
Click to expand...


Hi Ken,

Thank you very much. I recently started working with VBA. I don't have much
experience with VBA but I do understand the basics. I will try it on Monday
when I go to work. it is because of people like you that I am doing great in
my projects. I learned a lot from you guys. Thank you very much!

Purnima Sharma
 
hi purnima
this group is very helpful
we can share our problems and also our knowledge here
 
I'll be glad to help if you have any issues.

If you do post, and I don't respond, feel free to ping me through the
contact form on my site. :)

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca
 
Back
Top