This morning a user of my just updated to Office 365. This is where the fun began. All of a sudden she starts to get errors that one of the worksheets is not found?? This can be solved if she only have one instance of Excel running, however, if she has multiple instances, the macro fails. I am wonder is there a way for me to set my Workbook and Worksheets explicitly (which office 2010 does, with MDI)
How do I overcome of this problem, for the time being, I told her to only have one Excel running :-(.set WB = workbook.open ("c:\data.xlsx") ' this runs fine set WS = WB.Worksheets("Data") ' this fails if multiple Excel is running
Thanks