This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Recently this computer got an update from Microsoft and the .xls files that used to be opened by Excel are now opened by Kingsoft. The problem is that when I tried to run my program that I wrote in Visual Basic for Applications, I could not find it. Did it just disappear, or is the link to it hiding in the menu bar somewhere?
Did you download and install Kingsoft? If not, I think that you computer was hijacked by some malware (or however you want to phrase that) - Kingsoft is a supposed Office workalike. But apparently it does not do VBA (based on what you said). First try uninstalling Kingsoft and see if your file types get set back to the Office ones. If that does not work, right click the xls file and change the program associations. If that still does not work, you might need to try a virus removal app to get your PC back (or even reinstall - Office first, then Windows if that doesn't work).
Sorry I was not specific. Now I will be more specific. Usually when I open my .xls file, Excel starts up, and then I get a message asking if I want to ignore macros or not. Of course I don't want to ignore macros because my VBA program is a macro. Then when the program finishes loading, I click tools tab, then choose VisualBasic in the macro item. Then the program goes to the Visual Basic editing mode, and I can see the code for my program displayed. Then I click the play button and start my program.
But now, there is no message asking if I want to use or ignore macros, and in the tools tab, there is no item for macros.
I wonder if the security is too high or something.
In Microsoft Office, there is an option to disable all macros without displaying notifications. You may need to re-enable it if it is already disabled - that depends on the version of the office that you are using. If you are using Excel 2007, try this out.
Joined: Oct 12, 2005
Thanks for the advice. I finally figured out what was wrong. When the Kingsoft program downloaded, somehow, that became the default application for all .xls files, so Kingsoft opened when I double clicked on my program icon. But Kingsoft evidently does not include the function that runs macros.
When I started up Excel first and then opened my file with Excel, everything went alright as usual.