| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if Workbook Exists
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..... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if Workbook Exists
Sub sssssstitw()
If Dir("C:\Program Files\My Program\Data\Myworkbook.xls") = "" Then MsgBox ("not there") Else MsgBox ("is there") End If End Sub -- Gary''s Student - gsnu200775 "dimm" wrote: 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..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check a workbook exists before opening | Excel Programming | |||
| Help - How to check if value exists in closed workbook? | Excel Programming | |||
| check if file exists | Excel Programming | |||
| Check if a worksheet exists | Excel Programming | |||
| Check if sheet exists in a closed workbook | Excel Programming | |||
Linear Mode
