Exporting Data from Excel to MFGPRO

I

ianfreeman

New Member
Hi,

I'm in the process of creating an excel macro that exports data from excel to mfgpro.

The purpose of this is to automate some of the repetitive data entry tasks that I carry out.
If I lay the data out vertically in a column in excel, with the requisite blank spaces, it pushes through all the fields and runs a batch of reports with the press of a button.

I can do this part manually, but need it to be contained within the macro, so the data is copied , mfgpro is activated and then the data is pasted.

So far I have got this:

Range("E4:G4").Select
Selection.Copy
AppActivate "MFGPro"

Does anyone know of anyway, once mfgpro is activated, to simulate the paste stroke?
Apologies but I don't know the exact version I'm running, it's the old black screen green text affair.

Any help would be gratefully accepted...

Ian
 
Thanks to all who've viewed - I have solved my problem.

I've managed to create a nice, simple macro to do what I need:

Sub ()

Range("E4:G4").Select
Selection.Copy
AppActivate "MFGPro"
Application.Wait Now + TimeValue("00:00:02")
SendKeys ("^]") 'Paste quick key set in mfgpo

End Sub

There is further code beyond this which reactivates the sheet and pulls in the report I've run in the above code.
 
You must log in or register to reply here.
Back
Top