[AccessD] Preventing user prompts from Excel

Hale, Jim Jim.Hale at FleetPride.com
Tue Jul 20 10:38:15 CDT 2004


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



More information about the AccessD mailing list