I am running a form in Outlook that pulls a value from an Excel workbook. The value is used in a Text box on a Users Form in Outlook.
I need to close the Excel workbook when the user closes the form. Right now, the value pulls just fine, but the workbook becomes Read Only.
I have tried .Close and setting the variable for the workbook to Nothing.
If anyone can let me know what I am missing will be greatly appreciated.
Thanks.
Bookmarks