Check if Workbook Exists

  • Thread starter Thread starter dimm
  • Start date Start date
D

dimm

Hi agin! :)

The user of my workbook has to save the old version as 'Myworkbook2 in the
specified folder before running my upgrade, and I need to check that they
have befre running the procedure.

Does anyone know how to check if the following workbook esists?

C:\Program Files\My Program\Data\Myworkbook.xls

Thanks for any ideas.....
 
Sub sssssstitw()
If Dir("C:\Program Files\My Program\Data\Myworkbook.xls") = "" Then
MsgBox ("not there")
Else
MsgBox ("is there")
End If
End Sub
 
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

Checking if a workbook exists 3
Macro problem where workbook name is saved in another name and macro reference changes 1
Save As and new workbook new name used in existing code 8
Check if workbook open (Not working) 3
Check a workbook exists before opening 4
Save Workbook with existing Name in the Folder 1
Macro for all Excel Workbooks to print to PDF 2
Check to see if a Workbook has a Macro 4

Back
Top