excel sheet does not open

[excel_student]

Hello
i am working on a legacy project using VB. i am trying to open this excel sheet to check out its contents but when i click on its reference in the windows explorer , it does not open. only the Excel applications starts and there is nothing there.

i think it is somehting to do with protection, can you guys tell me how to open it.

also can you point me to some sort of tutorial where i can learn how to work on an excel object from VB. can i also work on an excel sheet from C also?

[Leith Ross]

Hi,

I'm not sure when you say VB if you mean (Visual Basic) or VBA (Visual Basic for Applications). If the program your are trying to run is a VBA program, and I think it is, you may have to start it once you are in Excel. You can check the Macro List for Excel by Selecting "Tools" from the Menu, Then Select "Macro". You should see a listing of all program macros. The other way is to press "ALT" & "F11" together. This will start the VBE (Visual Basic Editor). Once in, you can explore the project (if there is one). I don't know if C will do you much good. The code Microsoft uses for developing system calls and objects is C+ and C++. Rather than books, you better off surfing the web for forums and blogs on what you are looking for.

Hope this helps,
Leith Ross

[excel_student]

i tried to look at its macros, does it appear to be any. when i make a copy of the excel file and try to open its copy i get the same response.

i can open the file in notepad and see the funny symbols.


i did manage to import its data into another file & then i prceeded to do the following

wrote a small VB program, and modified the excel sheet from the VB program. then imported its data into another excel sheet. that works.

but can you tell me why i can't open the excel sheet in the first place, is there some sort of protection on it which also gets copied when i copy the file?