Help!

ADO Query AfterRefresh Event in shared environment

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Query DAO RSS
Next:  Installing BCM 2007 database after installing Vis..  
Author Message
Poole



Joined: Feb 04, 2008
Posts: 1
PostPosted: Mon Feb 04, 2008 9:25 am    Post subject: ADO Query AfterRefresh Event in shared environment
Hi Everyone,
I hope someone can provide insight to see if this is possible. Current setup: ADO Query from AS400 dumps into Excel-works. Trying to see if an AfterRefresh Event could be used eg. Class1 module. If so, could this be setup in Excel's Share WorkBook? Confused

I was using MS Query with the AfterRefresh but when I placed the workbook in a Shared Environment, the MS Query does not work and the options to Get External Data is grayed out hence the ADO.

Any help would be great...still new to VBA!!
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Query DAO All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum