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

Purnima Sharma wrote:

"Purnima Sharma" wrote:

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


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