This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes General Computing and the fly likes Visual Basic program disappeared! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Visual Basic program disappeared!" Watch "Visual Basic program disappeared!" New topic
Author

Visual Basic program disappeared!

Kevin Tysen
Ranch Hand

Joined: Oct 12, 2005
Posts: 255
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?
Devaka Cooray
ExamLab Creator
Saloon Keeper

Joined: Jul 29, 2008
Posts: 3029
    
  35

Kevin Tysen wrote:when I tried to run my program that I wrote in Visual Basic for Applications, I could not find it.

You meant you can't find the Visual Basic source project, or the installed application of your VB program ?


Author of ExamLab ExamLab - a free SCJP / OCPJP exam simulator
What would SCJP exam questions look like? -- Home -- Twitter -- How to Ask a Question
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

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).


JBoss In Action
Kevin Tysen
Ranch Hand

Joined: Oct 12, 2005
Posts: 255
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.
Devaka Cooray
ExamLab Creator
Saloon Keeper

Joined: Jul 29, 2008
Posts: 3029
    
  35

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.
Kevin Tysen
Ranch Hand

Joined: Oct 12, 2005
Posts: 255
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Visual Basic program disappeared!
 
Similar Threads
FileTimeToSystemTime?
creating dsn thru java
Old-school programming techniques you probably don't miss
Metaphorical Programming
Isnt SCJP an overkill