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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File names

Status
Not open for further replies.
solo7

solo7

Technical User
Mar 14, 2001
243
NO
I'm creating a spreadsheet from a query and exporting it to Excel, but I need to do this several times and so
I need to save a file of the same name several times , but I want to surpress the 'FILE ALREADY EXISTS. ARE YOU SURE YOU WANT TO CONTINUE.....etc'. Does anyone have any info to share on this one ???

Steady ... [thumbsup2]
 
Sort by date Sort by votes
Use the SetWarnings facility

DoCmd.SetWarnings False
'Run the query & export file
DoCmd.SetWarnings True



QED

G LS
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
462
dhookom
dhookom
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
209
combo
combo
rdpress
  • Locked
  • Question
Question Open Shellling to File Explorer
Replies
3
Views
184
Andrzejek
Andrzejek
Aurillius
  • Locked
  • Question
Help with Unzipping a file and saving to a folder in Excel VBA
Replies
1
Views
369
Aurillius
Aurillius
AS Mughal
  • Locked
  • Question
Select Multiple Images and store their file path and image name in text fields of ms access table 1
Replies
7
Views
336
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top