Recent content by melver

That is exactly what I need.... Thanks very much!

The new object is any excel spreadsheet I open up while my application is running. It could be a spreadsheet that keeps my timesheet info in or any other spreadsheet, as long as I open it from a saved file. This new workbook adds itself the excel application object I created in my access vba...

When I realised what was happening I rewrote as much as I could of the vba to remove references to active workbooks sheets etc. I substituted selection and active use for named worksheets to get to the correct cells for import and export. I now mostly get subscript of range errors as the...

Hi, First time poster and appreciate any help I can get. I am using a Access adp and vba to import and export from sql to excel and visa versa. Depending on the month some of the exports will take up to 20 minutes to finish. I instantiate the excel objects from access and leave them...