I have to copy and paste text data from a web-based report into an Excel
spreadsheet. I then clean up the spreadsheet data by several macros and
transfer it to MS Access for further processing there. What I'd like to do is
automate and simiplify the process as much as possible. I can't avoid
selecting the web report data and copying it into the clipboard with Ctrl-C,
but I'd like to automate the opening of Excel and pasting the information
from the clipboard...and even the saving of the Excel file to a predetermined
folder location. Does anyone have any ideas on this? Can I do it from an
Access module, or does it have to be done from Excel? I'm more familiar with
Access than I am with Excel.