Hi there,
Can anyone help with the following:
I want to be able to open an excel workbook with out any user intervention. So i've scheduled a task to open myWorkBook.xls. In here i've put in a sub workbook_open() which it will call other bits and pieces and then close down the workbook when done.
problem is i don't know how to overcome the Macro enable/disable prompt and also the Workbook password promt... any ideas at all??
many thanks!
e
Can anyone help with the following:
I want to be able to open an excel workbook with out any user intervention. So i've scheduled a task to open myWorkBook.xls. In here i've put in a sub workbook_open() which it will call other bits and pieces and then close down the workbook when done.
problem is i don't know how to overcome the Macro enable/disable prompt and also the Workbook password promt... any ideas at all??
many thanks!
e