View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Berj Berj is offline
external usenet poster
 
Posts: 28
Default A condition and a variable

I want to use a command or two in a macro in Excel where it checks for the
existence of a file "ABCD" in folder C:\2009. If the file exists, then it
should close the active file without saving. Otherwise if the file doesn't
exist in continues the execution of the rest of the macro lines.

Another question:
How can I assign a text value in a variable?