Search results

Thanks Chergh. I tried again taking away the references and with the dot as suggested but the error "variable not defined" comes up again. I wanted to keep it "referenceless" as well because of the same reason you mentioned: other users may need to access the application. So, help me out... what...

Thanks Brianwarnock, indeed that's waht was needed (chergh, thanks for the tip but didn't work without the reference selected). Brianwarnock, can I take advantage of your knowledge for one more question? I need to import a tab into a access table. I want to cancel the existing table first in...

Brianwarnock, I think the references are not selected. I tried selecting in it by going into "Tools" and then "References" in the VBA editor but I am afraid I was not able to find the proper reference to Excel. Which one should I thick off? thanks.

Dear all, I am new to VBA programming and I need some support (actually as much support as I can get...). I created a module in Access that opens a workbook, copies data from one tab to another and then saves and closes the workbook. To capture a defined set of data in the tab I am using the...