A few months ago, I decided to upgrade from Windows XP / Office 97 to Windows 7 / Office 2010. I now have 2 XP computers and 1 Win 7 computer. My main reason for the change to Win 7 is that it is supposed to be more secure. This interested me, because no matter how careful I was, my XP machines always managed to get glitches, sometimes requiring reformatting and reinstalling everything.
At this point, my XP machines have minor quirks that I can live with. I can also live with most of Windows 7, though I am finding it a bit of a challenge. Excel 2010, however, is giving me fits. Under XP / Office 97, I wrote and downloaded a number of very useful add-ins. I am now finding that a particular add-in I downloaded (Trigono.xla) does not work under Excel 2010. I do not have the source code for this add-in, and the messages I get about VBA converters lead to a dead end.
Add-ins that I wrote myself under Excel 97, do work under Excel 2010, but I have been unable to edit them. When I edit and save in the VBA editor, I see the xla file update to the new date/time in Win Explorer, but then when I exit Excel, the save time reverts to the pre-editing date/time. Even if I copy the updated file to another folder while still in the editor, close the editor, then replace the older file with the new one, when I open the editor again, the pre-edit file is all I get.
When I create a new xla file in Excel 2010, it seems I only get one editing session in which I can save changes. Once I close the editor - no more changes - just as described above. A work-around is to do all my code writing in a text editor. When I want to try changes, I have to delete the module that's in VBA, insert a new module, and paste the modified code into it. Pain in the bit.
I have tried many different combinations regarding xla, xlam, xls, xlsm, loading and deleting add-ins, different directories for add-ins, enabling macros, etc., and I'm just not getting anywhere. When I was working in Excel 97 VBA, I felt marginally competent, (though certainly not proficient). Working in Ecxel 2010 VBA, I feel like I might as well be trying to write code in Sanskrit. Seems like it might even be some kind of buggy pre-beta tool for legacy support of something MicroSoft really wants to disappear.
Can anybody steer me to a good book or tutorial that will help me make some progress here?
At this point, my XP machines have minor quirks that I can live with. I can also live with most of Windows 7, though I am finding it a bit of a challenge. Excel 2010, however, is giving me fits. Under XP / Office 97, I wrote and downloaded a number of very useful add-ins. I am now finding that a particular add-in I downloaded (Trigono.xla) does not work under Excel 2010. I do not have the source code for this add-in, and the messages I get about VBA converters lead to a dead end.
Add-ins that I wrote myself under Excel 97, do work under Excel 2010, but I have been unable to edit them. When I edit and save in the VBA editor, I see the xla file update to the new date/time in Win Explorer, but then when I exit Excel, the save time reverts to the pre-editing date/time. Even if I copy the updated file to another folder while still in the editor, close the editor, then replace the older file with the new one, when I open the editor again, the pre-edit file is all I get.
When I create a new xla file in Excel 2010, it seems I only get one editing session in which I can save changes. Once I close the editor - no more changes - just as described above. A work-around is to do all my code writing in a text editor. When I want to try changes, I have to delete the module that's in VBA, insert a new module, and paste the modified code into it. Pain in the bit.
I have tried many different combinations regarding xla, xlam, xls, xlsm, loading and deleting add-ins, different directories for add-ins, enabling macros, etc., and I'm just not getting anywhere. When I was working in Excel 97 VBA, I felt marginally competent, (though certainly not proficient). Working in Ecxel 2010 VBA, I feel like I might as well be trying to write code in Sanskrit. Seems like it might even be some kind of buggy pre-beta tool for legacy support of something MicroSoft really wants to disappear.
Can anybody steer me to a good book or tutorial that will help me make some progress here?
