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 Purnima,

You'll need VBA to automate this.. do you have any experience there?

I have an article at my site which can get you started if you do:
http://www.excelguru.ca/node/23

If you need help with it, let us know.

Cheers,

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

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

"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

hi purnima
this group is very helpful
we can share our problems and also our knowledge here
--
hemu


"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

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