| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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..... |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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..... |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Already exists on the destination workbook | ChrisP | Microsoft Excel Worksheet Functions | 3 | 11th Jul 2008 08:13 PM |
| Check a workbook exists before opening | Symbiosis | Microsoft Excel Programming | 4 | 14th Sep 2007 12:06 PM |
| Help - How to check if value exists in closed workbook? | c mateland | Microsoft Excel Programming | 3 | 16th Apr 2007 03:05 AM |
| Check if sheet exists in a closed workbook | FrigidDigit | Microsoft Excel Programming | 2 | 25th Oct 2005 06:44 AM |
| How do I check if a worksheet exists in my workbook ? | =?Utf-8?B?U2lyaXVzLVZpY3Rvci1PbmU=?= | Microsoft Excel Worksheet Functions | 2 | 20th Oct 2004 02:46 AM |
