Hi,

I'm trying to run some functions in another application on my desktop.
The macro below will open the application in question:

Sub Run_DebitMemo()
Run Shell("C:\ORANT\BIN\R25RUN32.EXE
\\jade\apps\oracle\apsubsystem\debitdetails_covers heet.rep
nassudani/nassudani@apasprod", 1)
End Sub

Here is what I'm attempting to do after that:

Copy data out of an excel sheet into a field called Assign ID
Copy data out of an excel sheet into a filed called Vendor #

Does anyone have any thoughts on how I can do this? I'm having
problems with the recorder and trying to get the data into the
application that the macro above opened. I would be grateful if
someone could put me on the right track.

Thanks

Eddie


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=552929