I have been working on an application that queries data from Access, loads
it into an array, and then writes it to an Excel spreadsheet. I use the
array approach to have fine control over spacing, formatting, etc. I have
gotten the first part of this to work by opening an Excel spreadsheet,
writhing the data, saving the spreadsheet and closing it. But what I would
like to do is to not actually open up Excel outside of Access. I want to
write the data to a spreadsheet embedded on the main form.
When the form runs, I can click on the spreadsheet and manually enter data,
but I cannot figure out what VBA commands to use to grab hold of the
spreadsheet. Can anyone point me in the right direction? Thanks.