How to find an existing excel file

electrogeeks
03-26-2003, 09:45 PM
First, I would like to say what a great place this is...I am VERY new to Visual basic and have learned a lot from reading the postings thanx to everyone!!!

My question is: I would like to have my program (when it is first started) check to see if a specific excel file exists and if it does not exist to create a new excel work book. Also (if possible) if the user were to save the updated workbook in a different location would It be possible to automatically open it the next time the program is started?

Any help would be greatly appreciated...

JordanChris
03-27-2003, 04:27 AM
To check if a file exists:

Function FileExist(ByVal strPath As String) As Boolean
FileExist = Len(Dir$(strPath)) <> 0
End Function

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum