I would like to be able to export an excel speadsheet on
monthly bases by appeding it to an Access table. Since I
don't know how long the file would be each month I am
wondering if there is any way to write a vb function
checking for the end of the file. Ultimately, I would like
to have a command button that would append the file to an
Access table with vba behind it telling it what the excel
file range is so that blank lines don't get exported.
I appreciate your time and help.
Diana