Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check IF new folder has any workbooks in it.
Hi,
Every month I run macros which populate the latest months folder. I wish to run a macro to test whether I have ran this macro yet this month. So I thought of running a macro that tried to call up a known file from that folder and if a file is there, a MsgBox returns "Macro already ran this month". However if I run it and nothing is there, becuase I asked for the designated workbook to be there, it will cause a debug error. How do I get round this (I thought with an If statement) Thanks in advance :-) Simon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check IF new folder has any workbooks in it.
You can use Dir to test if the file is there
If Dir("C:\Testfolder\ron.xls") < "" Then 'is there Else 'not there End If -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Simon" wrote in message ... Hi, Every month I run macros which populate the latest months folder. I wish to run a macro to test whether I have ran this macro yet this month. So I thought of running a macro that tried to call up a known file from that folder and if a file is there, a MsgBox returns "Macro already ran this month". However if I run it and nothing is there, becuase I asked for the designated workbook to be there, it will cause a debug error. How do I get round this (I thought with an If statement) Thanks in advance :-) Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check for file in folder, if not there, open folder to rename file | Excel Programming | |||
Check for Folder | Excel Programming | |||
Update workbooks in folder, new name and save in new folder | Excel Programming | |||
Check if a folder has x files in it. | Excel Discussion (Misc queries) | |||
Check if folder exists, if yes just copy sheet in to folder? | Excel Programming |