ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run time error 3085 (https://www.excelbanter.com/excel-programming/398513-run-time-error-3085-a.html)

[email protected]

Run time error 3085
 
Hello all,

I have a vb written in excel that opens up a new workbok and renames 3
excel sheet tabs. When i try to get data from a query in Ms Access
the following line gives me a run-time error '3085', i'm not sure why
this is happening. Can somesome assist me?

Sheets("Live Dates By Month").[a13].CopyFromRecordset rec

The line above is where i get the message. Thank you.



All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com