Thanks for any help.
I have a macro that opens workbook, copies some info in, then closes it.
Sometimes afterwards I get a notice from Excel that the workbook is available
for read/write access, and I think this is because when the macro opened it,
it was already opened by someone. Now that the file is available, Excel
displays a notice, I believe is what is happening. But I don't need the
notice anymore, the file opened fine, and the data was copied in. Is there a
way of stopping the notice from happening?
workbooks.open has an option, Notify, but the workbook help says that if it
is omitted, no notification is requested, and I omit it in my workbooks.open
command.
Any ideas?
Thanks.