workbooks.open results in approx. three seconds of beeps

[DanGrostick]

I've written a couple of programs in Visual Studio that opens an Excel file
in order to read data. The program I am currently writing does this as well,
but with undesirable side effects. When the program executes the
workbooks.open method, there are many system beeps each second for about
three seconds. However, the Excel file does open successfully and I am able
to select worksheets and read data. I just need to find a way to get the
code to stop making this noise.

I suspect the problem is because the Excel file is write-protected.
However, I am only trying to open this file in read-only mode so this
shouldn't be too much of an issue.

Again, I am able to open the file and I am able to read data, so I don't
think it is necessary to post code. Furthermore, when I use a different
Excel file I do NOT get this noise. Unfortunately I am required to reference
this existing Excel file so using a different one is not an option.

I am hoping someone has encountered this problem before and knows how to get
this noise to stop. Thanks in advance for any help.

Dan

 

[Cindy M.]

Hi =?Utf-8?B?RGFuR3Jvc3RpY2s=?=,

Well, what do you see / what happens if you open the file as an end-user? This
would give some clues as to what the problems might actually be...

And you should take this to the excel.programming newsgroup, where you'll find a
much higher density of specialists with ideas on how to circumvent the issue.
Don't forget to include the Excel VERSION you're working with in the
information.

I've written a couple of programs in Visual Studio that opens an Excel file
in order to read data. The program I am currently writing does this as well,
but with undesirable side effects. When the program executes the
workbooks.open method, there are many system beeps each second for about
three seconds. However, the Excel file does open successfully and I am able
to select worksheets and read data. I just need to find a way to get the
code to stop making this noise.

I suspect the problem is because the Excel file is write-protected.
However, I am only trying to open this file in read-only mode so this
shouldn't be too much of an issue.

Again, I am able to open the file and I am able to read data, so I don't
think it is necessary to post code. Furthermore, when I use a different
Excel file I do NOT get this noise. Unfortunately I am required to reference
this existing Excel file so using a different one is not an option.

I am hoping someone has encountered this problem before and knows how to get
this noise to stop. Thanks in advance for any help.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail