getting excel to wait

[hainejo]

I have a macro that prints an excel worksheet as a post script file and saves it to a folder on the server. The file is then converted by Acrobat Distiller into a PDF file and saved into another folder. The macro then tells Outlook to create an e-mail and attach the PDF file. The problem is that the macro executes to fast. It looks to attach the PDF file before Distiller can create it. Is there a way to slow the macro down? I have tried the application.wait command but I don't know how to define the amount of time it should wait. Can anyone help me?

 

[Andrew Poulsom]

You can use the Dir function in a loop to wait until the file has been created:

x = Dir("YourNewFile") ' Change name to include Path
If x = "" Then
   Do
      x = Dir()
      DoEvents
   Loop While Dir = ""
End If

 

[hainejo]

I am getting an error on the line
'x = Dir()'
I am getting Invalid procedure call or argument.

 

[rikrak]

Hi,

Hope this works:
Do
x = Dir("YourNewFile")
DoEvents
Loop While x = ""

 

[hainejo]

that worked! Thanks!