I have written some vba that runs from MS Outlook, reads the currently selected email, does some processing and updates information in a spreadsheet. I cannot convert the spreadsheet to macro enabled because it is used by another system that can't handle macro enabled spreadsheets.
Following are the key elements of my code (I have removed some of the steps that don't relate to my problem). All of this works well but if I have the sheet open in Excel it crashes. So my question is: Is there any way to modify my code so it will perform the updates while I still have the spreadsheet open and visible in Excel? That would make it possible for me to check the entry, and possibly make minor adjustments, without having to open and close it in Excel after every update.
Set xlApp = CreateObject("Excel.application")
Set xlbook = Workbooks.Open(FileName:=WorkbookName, Notify:=bReadOnly) 'bReadOnly is set to true if I don't need to update
' various steps follow to find and update the relevant data
Set xlbook = Nothing
Set xlApp = Nothing