Hi All
I am using Excel 2003 SP3 and have had an ongoing issue with query tables being deleted after I refresh the data. Sometime ago a kind soul provided me with the following script that seems to work most of the time (but not always) assuming also that I have actually added this into my spreadsheet. Just wondering if anyone else has come up with a solution to this problem.
Thanks
Karen
Please Login or Register to view this content.
Last edited by VBA Noob; 10-26-2007 at 03:33 AM.
Hi Karen,
I experience this problem ALL the time (well quite often) and yours is the first post I have read on any messageboard that confirms it- I had always assumed it was something I was doing wrong!
Its caught me out big time in the past as the query has been deleted (unnoticed) and the spreadsheet saved so that the next time it is called up the data is unchanged and everybody assumes my spreadsheet is crap!
My solution is somewhat simplier as I just put a querytables.count in the BeforeSave Event and if this number is not equal to the number of QT expected then I pop up a message box to contact me and don't allow the user to save the file. This causes occasional user frustration but not nearly as much as the file being saved minus the queries!
I shall watch this thread with interest.
Regards,
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks