Where can i get excel Vb converted to access Vb

A

ANDY CALLAGHAN

When at work I run a macro in access to export 2 data files and save to
network and then launch a 3rd file( all in excel.) I then run a excel macro
to get data files 1&2 and paste into file 3. then with the use of vlooksup ,
calculations and finally emailing out separate tabs dependant on a sheet with
names and emails.

apologises for the waffle. but it hope this in part explains the complex
elements i am looking to have coded,

anyone who can convert said code into one version or the other or
alternatibvely suggest suitable company/contractor, would be greatly
appreciated

thanks Andy
 
P

pietlinden

When at work I run a macro in access to export 2 data files and save to
network and then launch a 3rd file( all in excel.)  I then run a excel macro
to get data files 1&2 and paste into file 3. then with the use of vlooksup,
calculations and finally emailing out separate tabs dependant on a sheet with
names and emails.

apologises for the waffle. but it hope this in part explains the complex
elements i am looking to have coded,

anyone who can convert said code into one version or the other or
alternatibvely suggest suitable company/contractor, would be greatly
appreciated

thanks  Andy

If you have the macro already working in Excel, just call it from
Access.

http://www.mvps.org/access/modules/mdl0007.htm
 

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

Top