Hi Al, one of the nice things about Excel is that you can record a macro and
then inspect the code. I recommend that this is the method that you use to
learn what you want to do in this case. Then just copy the code into your
Access routine.
You did not ask how to set a reference to Excel and then open a workbook. So
I assume you know how to do this. If you're not sure, then this site has a
good search engine to allow you to browse existing responses to this issue.
Hi Al, one of the nice things about Excel is that you can record a macro and
then inspect the code. I recommend that this is the method that you use to
learn what you want to do in this case. Then just copy the code into your
Access routine.
You did not ask how to set a reference to Excel and then open a workbook. So
I assume you know how to do this. If you're not sure, then this site has a
good search engine to allow you to browse existing responses to this issue.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
