Rod wrote:
I am new to VB. I was told Access cannot update xls via access, but must use
VB. I do not know of a VB community so am hoping this forum can help me
without breaking any rules. Here is the problem:

<SNIP

you can control excel with access. i do it all the time. add the
excel reference to the VBE within Access and write some code.

AR