Share a single ADODB connection across multiple worksheets

[anthony1312002]

Hey everyone, I've got problem I'm trying to solve. Is it possible for me to use this single connection below across multiple worksheets? What I want to do is get away from having this connection on every worksheet that needs to pull data from the server. I just want to be able to have every sheet reference this single connection. After I pull the data of course I close and cleanup so that connection is never left open.

Please Login or Register  to view this content.

[mjr veverka]

Ersatz - "Share" a single ADODB connection across multiple worksheets ... e.g.:

Please Login or Register  to view this content.