I have an Excel sheet that contains VB code as well as macros and it works
fine except for some times we get "unexpected error (32809)" error message.

The spreadsheet's performance is inconsistent
thank you for your help and effort

post the code

On Feb 2, 12:00 pm, Student wrote:
I have an Excel sheet that contains VB code as well as macros and it works
fine except for some times we get "unexpected error (32809)" error message.

The spreadsheet's performance is inconsistent
thank you for your help and effort

I can't it is about 5-6 pages

"Susan" wrote:

post the code

On Feb 2, 12:00 pm, Student wrote:
I have an Excel sheet that contains VB code as well as macros and it works
fine except for some times we get "unexpected error (32809)" error message.

The spreadsheet's performance is inconsistent
thank you for your help and effort

is there a log that you can check to see what kind of things triggers this
error message please.
thank you

"Susan" wrote:

post the code

On Feb 2, 12:00 pm, Student wrote:
I have an Excel sheet that contains VB code as well as macros and it works
fine except for some times we get "unexpected error (32809)" error message.

The spreadsheet's performance is inconsistent
thank you for your help and effort

Why not enter debugging mode (assumes XL offers you a choice of 'debug') and
take it from there?
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"Student" wrote:

I can't it is about 5-6 pages

"Susan" wrote:

post the code

On Feb 2, 12:00 pm, Student wrote:
I have an Excel sheet that contains VB code as well as macros and it works
fine except for some times we get "unexpected error (32809)" error message.

The spreadsheet's performance is inconsistent
thank you for your help and effort

Would anybody be interested in helping me without looking at the code?
This is secured data and I can't post it.
Also, I don't thing the code is causing the error since the code works most
of the time. I think this might be a deficiency with Excel or an environment
error. Is there a log that Microsoft keeps to track what might trigger the
error message.
Please advice. Thank you


"Student" wrote:

is there a log that you can check to see what kind of things triggers this
error message please.
thank you

"Susan" wrote:

post the code

On Feb 2, 12:00 pm, Student wrote:
I have an Excel sheet that contains VB code as well as macros and it works
fine except for some times we get "unexpected error (32809)" error message.

The spreadsheet's performance is inconsistent
thank you for your help and effort

Without any idea of what the code is attempting to do, all anyone can say is
that it is something "unexpected".
If a Repair of Excel/Office does not help, step through every line until the
error occurs.

NickHK

"Student" wrote in message
...
Would anybody be interested in helping me without looking at the code?
This is secured data and I can't post it.
Also, I don't thing the code is causing the error since the code works
most
of the time. I think this might be a deficiency with Excel or an
environment
error. Is there a log that Microsoft keeps to track what might trigger the
error message.
Please advice. Thank you


"Student" wrote:

is there a log that you can check to see what kind of things triggers
this
error message please.
thank you

"Susan" wrote:

post the code

On Feb 2, 12:00 pm, Student wrote:
I have an Excel sheet that contains VB code as well as macros and it
works
fine except for some times we get "unexpected error (32809)" error
message.

The spreadsheet's performance is inconsistent
thank you for your help and effort

I am having the same issue with Excel VBA code.
I have a workbook that has 27 worksheets. (24 worksheets are either
blank or have text/numeric values, no formulas)
I'm using Excel 2003 (11.8117.8107) SP2 on Windows 2000.

As the other poster mentioned, the workbook is inconsistent with this
error. Sometimes it's fine, othertimes it crashes.

My first sheet has five command buttons and three checkboxes. One of
the checkboxes is named "chkDelFile1" .. on occasion the VB Editor will
say "Method or data member not found" when referring to
sheet1.chkDelFile1, which is not the case.

The second sheet has 720 calls to a function macro called "getData()"
which is located in a standard Module.

The code also connects to Outlook, enumerates the Inbox, downloads an
email attachment and opens another Excel workbook (which has no macros
of its own.)

On occasion, when the workbook opens, it gives the error "Type Mismatch
Error" (this will often be an indicator that Excel will crash; sometimes
when the workbook is Recovered & Repaired, the macros are stripped from
it.) Other times it gives the 32809 error, and then automatically
enters a breakpoint at the getData() function. Macro security is set to
"Medium."

The "Type Mismatch Error" will let me continue to use the workbook. The
32809 error will stop the macros cold.

I suspect that the workbook is corrupt in some way, and I plan to
copy-paste everything to a new one.

*** Sent via Developersdex http://www.developersdex.com ***