Notify when file is open?

R

Rbp9ad

I want to open a file when notified that it is aailiable for editing. How
could i do this in code?

Workbooks.Open filename:="the file" _
notify:= true
'Upon notification
Workbooks.open filename:="the file"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with MACRO for opening workbook 1
Make "File in use" message appear when 2 people open the a shared document in the same time 3
RTD server : Updatenotify does not return and Excel not calling refreshData method 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
code to open another workbook 0
Open Workbook Question 1
Template opens instead of copy 2
Open four Wbooks, copy four columns from each to Master Wbook 16

Top