Re: Waiting for process end , how?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I been trying to do that with the following code
Dim pr As Process

pr.Start(Fname) where Fname is the filename to use with the process.

However I get a message in the IDE saying that Access of Shared member,
constant member.... etc. qualifying expression will not be evaluated.

Got any code snippets to do this? It seems straightforward but <GGGG> :-)

Thanks for your help.

Bob



"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:ev8wQ89vGHA.4932@xxxxxxxxxxxxxxxxxxxxxxx
Bob,

How about to use the wait for exit in the process class to wait on the
exit of that process.

:-)

http://msdn2.microsoft.com/en-us/library/fb4aw7b8.aspx

I hope this helps,

Cor


"Bob" <bdufour@xxxxxxxxxx> schreef in bericht
news:uSv4E59vGHA.3392@xxxxxxxxxxxxxxxxxxxxxxx
Process.start("Mydoc.doc") starts Word with the file. I need to wait for
Word to be closed before more code can execute in my app. How can I do
this?

Thanks for any help
Bob





.



Relevant Pages

  • Re: Put Filename Variable in Macro
    ... Set wbSum = FName ... Set wbSum = Workbooks.Open ... Workbooks.Open (Filename) ... > Dim wbSum As Workbook, ...
    (microsoft.public.excel.misc)
  • Re: GetOpenFilename path vs filename
    ... Dim FName As Variant ... Dim FileName As String ...
    (microsoft.public.excel.programming)
  • RE: date format in CSV
    ... I added the message box to see if you are passing the filename correctly to ... the WriteCSVmacro. ... Call WriteCSV(ActiveWorkbook, FName) ... Dim FName As String ...
    (microsoft.public.excel.programming)
  • RE: Breaking down imported information
    ... Single-record append query: ... ' Check if at EOF of Recordset (rsDataViaCode) ... ' if at EOF Exit Do. ... Dim rsDataViaCode As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: THANK YOU!!!
    ... > Dim Justi1 As New clsJustifyText TO Dim Justi8 As New clsJustifyText ... > Call Justi1.fRecordSection(Me, Me.txtTestmemo, PrintCount) TO Call ... > Private Sub Detail_Print ... >>> Exit For ...
    (microsoft.public.access.reports)