Test if something has been done

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

Payroll entry database. One of my users seems to sometimes leave out a step.
Before the database is updated from current week to year to date, the user
has to export data to excel (which creates a Quickbooks iif import file),
where she has to run a macro to format the data and creates the tab delimiter
file, which add the week ending data to the file name.

How can I test if this file has been created? The file created is
"PostingSumMMDDYY.iif".

Or perhaps usesable on other occasions is:
how I can test if commandbuttonOne has been clicked when commandbutton2 is
clicked?
 
if you know the filepath where the file should be stored, you can check for
it using the Dir() function, as

If Dir(<put filepath and filename here>) = "" Then
Msgbox "The file was not created."
End If

read up on the Dir() function in VBA Help, so you'll understand how it
works.

hth
 
Back
Top