Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-13-2005, 06:26 AM
Novice
 
Join Date: Jun 2005
Posts: 1
Barry Richardson is on a distinguished road
Thumbs up Delete excel files by code in Access


I have a program that exports to excel spreadsheet, the fields it exports are variable, if i export many fields, then a couple of fields then again many fields the transfer spreadsheet fails as the file says there are too many fields.
#It would appeat that what I need to do is delete the spreadsheet before exporting, I am looking for code to check existence of file and then to delete if exists.

any help?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Excel or Access ? inferno Excel 0 10-03-2008 03:42 AM
Excel ->VB code for Checkbox (control toolbox) kirkstyle Excel 0 08-16-2006 04:17 PM
FileSaveAs with Code bsmith Office 0 01-05-2006 08:43 AM
MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM


All times are GMT -7. The time now is 08:02 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft