Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Verify if a workbook exist with a macro

hello,
i want to verify if a workbook exist in a disk with a macro???

regardes

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Verify if a workbook exist with a macro

Hi Homero

You can use Dir

Sub test()
If Dir("C:\Data\test.xls") < "" Then
MsgBox "Exist"
Else
MsgBox "Not exist"
End If
End Sub




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Homero" wrote in message ...
hello,
i want to verify if a workbook exist in a disk with a macro???

regardes



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
verify if spesific sheet exist Miri Excel Discussion (Misc queries) 3 February 26th 07 01:04 PM
verify data with macro? Elizabeth New Users to Excel 1 November 16th 06 09:29 PM
How do I verify the password date of an excel workbook develcom Excel Discussion (Misc queries) 0 June 13th 06 12:14 AM
Verify if Comment exist in a cell Tom LeBold Excel Discussion (Misc queries) 2 September 15th 05 08:47 PM
Verify starting cell for macro Don Cameron Excel Programming 3 September 6th 03 03:29 PM


All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"