To create an invoice in our accounting package (MYOB) we need to transfer information from various fields displayed on an MS Access form into corresponding fields in MYOB. When I have to do many invoices I currently create a csv file from MS Access and import to MYOB but when I need to do one or two invoices it is quicker to just copy and paste data. However if I could create a keyboard macro then it would be even quicker.
So is there any way of using VBA to run a keyboard macro that will enter a sequence like:
CustomerName <Tab><Tab><Tab><Tab> OrderNumber <Tab> OrderDate <Tab> Description <Tab><Tab> Amount <Tab> JobId