Colby, John
JColby at dispec.com
Tue Jul 20 11:09:50 CDT 2004
Yea, that seems to be the answer. JWC -----Original Message----- From: Hale, Jim [mailto:Jim.Hale at fleetpride.com] Sent: Tuesday, July 20, 2004 11:38 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Preventing user prompts from Excel Hmm... If I recall correctly if you open an excel sheet and don't make changes it won't ask you if you want to save, i.e. you can just close it thereby avoiding the message box. If you can get the name of the sheet and use it in your connection string without changing the sheet name you may be able to avoid the stupid message box. As you know, you can give a linked table in Access whatever name you desire regardless of the source table name so your queries wouldn't have to change. The sole trick is to access the data without changing the workbook so the message box doesn't pop up. Something like appExcel.activeworkbook.Sheets(1).name should retrieve the name for use in your connection string. Anyway, just a thought. Jim Hale -----Original Message----- From: Colby, John [mailto:JColby at dispec.com] Sent: Tuesday, July 20, 2004 9:58 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Preventing user prompts from Excel No! 8-( JWC -----Original Message----- From: Hale, Jim [mailto:Jim.Hale at fleetpride.com] Sent: Tuesday, July 20, 2004 10:22 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Preventing user prompts from Excel Did you find a solution to this problem? Jim Hale -----Original Message----- From: Colby, John [mailto:JColby at dispec.com] Sent: Tuesday, July 13, 2004 2:45 PM To: 'accessd at databaseadvisors.com' Subject: [AccessD] Preventing user prompts from Excel Since this is an automated process there is no one around to answer yes (Excel can be so stupid sometimes). Is there any way to force a yes (or no, I don't really much care what the format is!) JWC -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com