Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I stop the Yes/No/Cancel Buttons when saving an Excel Doc in A

Status
Not open for further replies.
lowflight9

lowflight9

Technical User
Feb 4, 2003
7
DE
How can I stop the Yes/No/Cancel Buttons when saving an Excel Doc in Access?
 
Sort by date Sort by votes
You could try the Sendkeys function. For example, assuming the default for the question is Yes, then send a carriage return via the SendKeys function.
 
Upvote 0 Downvote
If you're using the excle object, set the DisplayAlerts to False:

Code: 
Dim xlApp as Excel.Application

'... code to set objects here

xlApp.DisplayAlerts = False

'... Manipulate & save workbook


HTH

Cheers
Nikki
 
Upvote 0 Downvote
If you use code, add it: doCmd.setworning false.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
112
combo
combo
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
339
Andrzejek
Andrzejek
Moss100
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
329
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
353
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
178
Viswa.R
Viswa.R

Part and Inventory Search

Sponsor

Back
Top