Check for file existance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is it possible for me to check for the existence of a particular excel file
before trying to save one with the same name?

I am trying to use access to automate some spreadsheets.


Regards,
Ron.
 
That just comes up with help for "Dir Property (Data Access Page)".

I'm using Access 2000, maybe the help is different.


Ron.
 
You need to do this in the code window, not the Access window. They provide
different help.

In any case, it's as simple as:
If Dir("C:\MyFolder\MyFile.xls") <> "" Then ...
 
Try

Dim strPath As String
strPath = "c:\FileName.xls"
If Dir(strPath) = "" Then
MsgBox "Can't find file"
Else
....
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automated Solution to Repair PST Files 2
Can a Check Box Prevent Other Fields from Being Used? 1
Access Print Files from Query Results 0
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
Does File Selection Dialogue box exist in Access? 2
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
default value for check box with existing data 5

Back
Top