unexpected error (32809)
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 |
unexpected error (32809)
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 |
unexpected error (32809)
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 |
unexpected error (32809)
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 |
unexpected error (32809)
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 |
unexpected error (32809)
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 |
unexpected error (32809)
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 |
unexpected error (32809)
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 *** |
All times are GMT +1. The time now is 01:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com