What I'm trying to do is copy a row from an Access table and paste it into Google Sheets.
What I would normally have to do is manually enter information into each cell in Google Sheets.
I was able to create an access program using mostly VBA and forms that would allow me to enter the information into textboxes on my form. Then I would click a button and it would output that information into a row in Microsoft Excel with specific formatting. Then I would copy the row in Excel and paste it into Google Sheets.
My program does work and saves a lot of time, but I'd like to make it more efficient if possible. As long as Access is running, is there a way for it to copy the Excel row and close it automatically so I don't have to manually select the row, copy it, and then close Excel? Then, when I click the button, the only thing I would manually need to do is paste into the Google Sheet. I would need to keep the formatting from excel. This would be much for convenient than having to do the copy and pasting and closing Excel myself since I have to this often.
Also, I'm using Access 2016.
Thanks,
Brad