Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 279
Default Run time error '49': Bad DLL calling convention - solved

I run Windows Vista, Excel 2003 and code in ...\XLSTART\PERSONAL.XLS.
Some days ago, I hit this error. I solved it by Export File in the
Visual Basic Editor, deleting the offending sub and importing it again.
All very tedious and error prone.
I've had the error a second time.
I started going through my old microsoft.public.excel.programming posts.
In response to "Excel startup problem. Possible problem with
stdole32.tlb" of "26 September 2011 12:39:49", Jim Cone suggested
Two things you haven't mentioned that should be done...
1. Clearing out the Windows Temp folder... Start | Run | %Temp%
2. Deleting the Excel11.xlb file - usually found near (on Windows XP)...
"C:\Documents and Settings\~name\Application Data\Microsoft\Excel"


I deleted most files from %temp%.
When deleting folders, I got a report a folder was shared.
The deletion took forever and I forced a shutdown.
I restarted and tried again.
I got another forever and went for a 10 minute coffee.
Safe mode got me down to a single file.
The problem remained.
Deleting excel11.xlb was ineffective.

I reported "Code Cleaner menu entry disappeared" on 21 July 2013
12:16:24 and was unable to solve the issue.

When I first hit the bad DLL problem, I diarised
20160524 orlando.mvps.org vba decompiler

I downloaded and applied that.
My PERSONAL.XLS was reduced by about a third and the bad DLL problem
went away.
--
Walter Briscoe
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Macro Error - almost solved Michael C Excel Discussion (Misc queries) 2 May 15th 08 04:04 AM
Run-time error after calling a procedure hmm Excel Programming 6 August 21st 07 02:31 PM
Run-time error '-2147319779 (8002801d)1: solved! [email protected] Excel Discussion (Misc queries) 0 December 3rd 06 06:52 PM
Error 49: Bad .dll Calling Convention Jarrett Sadowsky Excel Programming 1 January 20th 04 08:52 PM
Bad DLL Calling Convention (Error 49) Shaikh Excel Programming 3 November 18th 03 11:18 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"