zoso
Well-known Member
- Joined
- Oct 23, 2003
- Messages
- 725
Hi there!
I have a fantastic workbook put together with the generous help of a few of the members of the board over 2 or 3 years. However, with upgrading to Office 2007 and Vista I now have 2 problems with the code in the book:
Office 2007:
The workbook runs fine while it's open, but since I upgraded to Office 2007 when I've made amendments, saved and closed the workbook I've always had a vbe6.dll error message on close. When I simply open and close the workbook without making any amendments & saving there's never a problem.
Vista:
When the workbook opens an embedded OLE wav file plays. In XP I simply hear the sound file, but since using Vista, Excel locates the object and opens Windows Media Player, neither of which I wanted to happen.
Unfortunately for me I'm not knowledgeable enough to know how these can be fixed as the code runs fine in earlier versions of Office and XP, but because of the importance of the workbook (I do a lot of running and it's my own personal diary) I'm even willing to pay for these amendments to be made so it opens and closes properly.
Would anybody be prepared to take a look at my workbook please?
Many thanks!
I have a fantastic workbook put together with the generous help of a few of the members of the board over 2 or 3 years. However, with upgrading to Office 2007 and Vista I now have 2 problems with the code in the book:
Office 2007:
The workbook runs fine while it's open, but since I upgraded to Office 2007 when I've made amendments, saved and closed the workbook I've always had a vbe6.dll error message on close. When I simply open and close the workbook without making any amendments & saving there's never a problem.
Vista:
When the workbook opens an embedded OLE wav file plays. In XP I simply hear the sound file, but since using Vista, Excel locates the object and opens Windows Media Player, neither of which I wanted to happen.
Unfortunately for me I'm not knowledgeable enough to know how these can be fixed as the code runs fine in earlier versions of Office and XP, but because of the importance of the workbook (I do a lot of running and it's my own personal diary) I'm even willing to pay for these amendments to be made so it opens and closes properly.
Would anybody be prepared to take a look at my workbook please?
Many thanks!
