I have everyday a lot of csv files to upload by jobnumber to an external interface .

What I am looking is to open always a specific excel file on my desktop, in which cell A will have a job number cell B an order number .

The code should be able to copy the cell A in memory, then go to a specific directory on my desktop ,look for that jobnumber in that folder which will be a aaa0111tb001 .csv, then open the external interface shortcut , put the login name and password , go to specific menu, open a submenu insert , paste jobnumber to a specific field and click up load .

Then copy cell b order number in memory ,go to the interface which is already opened , then to specific menu , open and paste that cell B order number , enter , the file will pop up , then select the first record ,go a to a specific click button , a menu will pop up , then click to 2 button retrieve , save until end of record .

Any one can suggest if this can be done with vba or specific software .I was thinking to amacro recorder or jibit macro recorder .

Any ideas welcome