Where can i get excel Vb converted to access Vb

  • Thread starter Thread starter ANDY CALLAGHAN
  • Start date Start date
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
 
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
Click to expand...

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

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