While using MS Excel are you getting error messages 'Can't insert object'? Are you unable to access or change the properties of any active controls on worksheets? Or while you are trying to refer ActiveX Control as a member of a worksheet, you are getting error 438? Then this article is for you.
Undoubtedly Excel is very important and high;y used application of Microsoft Office suite. But in many cases, this start showing various errors or gets easily corrupted. Today in this article I am going to describe how to fix Microsoft Excel ActiveX controls issues or repair broken ActiveX controls in Excel.
This is comm0only faced due to the issue with the update of the ActiveX Control patch in Excel. You may be thinking if your Excel file is working properly, and then what is the need for this update. These updates are necessary because it keeps your Excel file updated and helps in performing better. If after installing the updated patch, you are facing a problem, then it can be fixed by following the steps mentioned in this article.
Causes Of Excel File Corruption
- An ActiveX component is an application or library that is capable of creating one or more ActiveX objects. For example, Microsoft Excel exposes many objects that you can use to create new applications and programming tools. Within Microsoft Excel, objects are organized hierarchically, with an object named Application at the top of the hierarchy.
- 前提・実現したいことExcel for Macにて連想配列のサンプルコードを実行しようとしたところ 「実行時エラー '429': ActiveX コンポーネントはオブジェクトを作成できません。」 が表示され実行されません。調べる限りだとMa.
MS Excel is capable of serving the users who want to keep their record. With the use of its mathematical formula users are able to perform a very small to large calculations very easily. However, this Excel file sometimes might become corrupted. Let us have a look at some common scenarios:
Excel VBA works on Mac, but there are major problems with ActiveX controls, basically forget about ActiveX on Mac.
- Virus Infection: One of the most common reasons for the corruption of Excel file is the virus infection. A computer virus is a malicious program that is designed in a way that they corrupt file system of your computer or it may damage some saved files as well. If your computer is infected with any such kind of virus then the chances of corruption become higher.
- Improper System Shutdown: Sometimes, your excel file may also become corrupted due to improper system shutdown. However, sometimes reasons like sudden power cut or due to any other reason your computer turns off suddenly and the chances to open MS Excel sheet Closes all the opened files improperly during the shutdown.
- Large Size of Excel File: MS Excel file is not a database that can handle and manage a large amount of information. So, if your Excel file is too large in size then the chances of corruption is possible.
- Generation of bad sectors on your data storage device: Some of the data storage devices like external hard drive, local hard drive, pen drive, etc can develop bad sectors. If you have saved your Excel sheet in the bad sector then it may get corrupted.
- MS Excel application issues: MS Excel application issues like an unexpected closing of an open Excel sheet or improper closing of an opened file can corrupt MS Excel file.
Further Reading:
How to Repair Broken ActiveX Controls in Microsoft Excel
#1: Search the EMD Files
- Close all the Office applications.
- In Windows Explorer, you have to search for all *.emd files, while doing so, make sure that you have included all hidden system files and folders, and erase the *.emd files.
This file would generally be displayed in the following ways:
C:usersusernameAppDataLocalTempExcel8.0MSForms.exd
C:usersusernameAppDataLocalTempVBEMSForms.exd - After erasing the file restart your PC.
- Now open the Office apps and test its controls.
You must remember that when you would open your workbook with embedded active control, the.exd files be recreated created again, but it would not cause any issues. In this way, the Excel VBA ActiveX controls problem would be resolved. If still, the problem exists, then it can be fixed with the help of third party application software.
#2: Recover Data from Temp Files
It is recommended that apply manual repair method to fix Excel corruption and if you get unsuccessful then go with any other repair tool. Apply the below-given carefully to recover data from corrupted Excel file.
- At very first close MS Excel application and re-open it. Try to open the affected file.
- If you are unable to open the affected file then, reboot your computer and open MS Excel. Try to open the file again.
- If you are still unable to open the file then, delete the contents of your C:windowstemp directory then restart your computer. Try to open the affected file.
- If the affected file is still inaccessible then apply the below-given trick:
- Click on the Start button > Open run dialogue box and type-
- 'C:Program FilesMicrosoft OfficeOfficeexcel.exe' /s
- After it, try to open the file again
Are you unable to open the file again? if YES, then it is suggested to scan the file for possible virus infection. Make sure that your macro heuristics scanning option is set to ON.
After completion of the scan if no virus has been found then, rename the file name and replace the .xls extension with the .doc extension. After it, try to open the file with Word.
If all the above-given tricks failed to open the corrupt excel file or resolve ActiveX control Excel issues then try another trick:
Try to copy the damaged excel file to another location
- If the file you are unable to copy it to another location, then in actual there is a chance that the sectors on the disk may be damaged
- If the data is very important, then it is suggested to go for any professional service
Automatic Solution: MS Excel Repair Tool
Microsoft Excel Repair Tool is a special tool which is specifically designed to repair such kind of files so that one can easily continue to work in that file. This repair tool searches for .xls file in the folder specified by the user. The file which is found to be corrupted will create a preview in the Excel Repair window. The interface is very simple, with a large toolbar of buttons to add files or folder to the application. With this software, you can repair your corrupted Excel file. It can easily restore all corrupt excel file and also recover everything which includes cell comments, charts, worksheet properties and other related data. The corrupted excel file can be restored to a new blank Excel file. It has the ability to recover the complete data from the file and restore them even without modifying original formatting.
Enable Activex Excel
Steps to Utilize MS Excel Repair Tool:
Conclusion:
So, this is all about the Microsoft Excel ActiveX controls issues and how to repair the broken ActiveX controls issues in Microsoft Excel.
Hope after following the given solution you are able to fix the ActiveX Controls in Microsoft Excel.
Make use of the given solution to fix the error and start using the Excel file without any hassle.
Good Luck!!!
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.
I'm trying to get an Excel 2011 32-bit (for Mac) spreadsheet working that contains a macro. The problem is that this macro works fine on a PC, but not on the Mac. I tried to import Tim Hall's Dictionary.cls, but it still doesn't work. Same thing for KeyValuePair.cls.
Error: Run-time error '429'
ActiveX component can't create object
I'm not a programmer, so the problem is probably me, not knowing what to change to get things working. It's probably super easy for those who know what they are doing. Can anyone spend a few minutes looking at the files and tell me which parts I need to change to get this running? [I assume it does work…]
FWIW, I have tried to replace 'Scripting.Dictionary' with 'New.Dictionary' in two places (see below), but that didn't get it working.
RandomiseData file:
EDITED CODE
New.Dictionary is not a valid classname and will fail on PC as well. Usually the construct using early binding would be:
OR using late binding:
However, Mac OS does not have the Scripting Runtime library, so none of those things will be available to you — Dictionary, FileSystemObject, etc.
You'll need to use a Collection or other data type in lieu of Dictionary type, or you can borrow from this other answer and implement a custom dictionary-like Class.
I tried to import Tim Hall's Dictionary.cls, but it still doesn't work. Same thing for KeyValuePair.cls.
I suspect you simply didn't know that you also need to use conditional compilation method to assign the Dictionary class on a Mac OS, and the Scripting.Dictionary class on Windows OS.
Remove both of these lines:
Exchange server for microsoft account. Documentation » Connect to the Exchange Server using a Mac. Connect to the Exchange Server using a Mac. Select the options you want to use with your Exchange server. Mac OS X Mail Setup - Setting up a Printer in Windows - Smartphone and Mobile Device Setup. Solution: Contact your Microsoft Exchange account administrator. Ask your Microsoft Exchange account administrator to tell you which proxy server to use to connect to the Microsoft Exchange server. For information about how to configure a connection to a proxy server, see Mac OS Help. Use Server Settings preferences in Mail to change options for an account's incoming and outgoing (SMTP) mail servers. To change these preferences in the Mail app on your Mac, choose Mail Preferences, click Accounts, then click Server Settings.
They'll fail even in Windows, as I described above. Likewise, if you want to use this code in both Win and Mac environments, you can't use Scripting.Dictionary without taking some additional precautions to avoid errors.
You will need to implement conditional compilation using compiler directives to identify the OS. This is not overly complicated for anyone who's done it before, but it's not something that most beginners will even know is available to them, much less how to use it.
In pseudo-code, basically you're doing this:
Assuming you've copied the KeyValuePair.clsandDictionary.cls code from the other answer which implements the Dictionary replica in to plain text files, and imported both of the modules to your project's VBE.
I would put this code just above the line:
Practically speaking, as long as you place that code anywhere before you call on either of dAttributes or dValues, it doesn't matter where you put it.
This is comm0only faced due to the issue with the update of the ActiveX Control patch in Excel. You may be thinking if your Excel file is working properly, and then what is the need for this update. These updates are necessary because it keeps your Excel file updated and helps in performing better. If after installing the updated patch, you are facing a problem, then it can be fixed by following the steps mentioned in this article.
Causes Of Excel File Corruption
- An ActiveX component is an application or library that is capable of creating one or more ActiveX objects. For example, Microsoft Excel exposes many objects that you can use to create new applications and programming tools. Within Microsoft Excel, objects are organized hierarchically, with an object named Application at the top of the hierarchy.
- 前提・実現したいことExcel for Macにて連想配列のサンプルコードを実行しようとしたところ 「実行時エラー '429': ActiveX コンポーネントはオブジェクトを作成できません。」 が表示され実行されません。調べる限りだとMa.
MS Excel is capable of serving the users who want to keep their record. With the use of its mathematical formula users are able to perform a very small to large calculations very easily. However, this Excel file sometimes might become corrupted. Let us have a look at some common scenarios:
Excel VBA works on Mac, but there are major problems with ActiveX controls, basically forget about ActiveX on Mac.
- Virus Infection: One of the most common reasons for the corruption of Excel file is the virus infection. A computer virus is a malicious program that is designed in a way that they corrupt file system of your computer or it may damage some saved files as well. If your computer is infected with any such kind of virus then the chances of corruption become higher.
- Improper System Shutdown: Sometimes, your excel file may also become corrupted due to improper system shutdown. However, sometimes reasons like sudden power cut or due to any other reason your computer turns off suddenly and the chances to open MS Excel sheet Closes all the opened files improperly during the shutdown.
- Large Size of Excel File: MS Excel file is not a database that can handle and manage a large amount of information. So, if your Excel file is too large in size then the chances of corruption is possible.
- Generation of bad sectors on your data storage device: Some of the data storage devices like external hard drive, local hard drive, pen drive, etc can develop bad sectors. If you have saved your Excel sheet in the bad sector then it may get corrupted.
- MS Excel application issues: MS Excel application issues like an unexpected closing of an open Excel sheet or improper closing of an opened file can corrupt MS Excel file.
Further Reading:
How to Repair Broken ActiveX Controls in Microsoft Excel
#1: Search the EMD Files
- Close all the Office applications.
- In Windows Explorer, you have to search for all *.emd files, while doing so, make sure that you have included all hidden system files and folders, and erase the *.emd files.
This file would generally be displayed in the following ways:
C:usersusernameAppDataLocalTempExcel8.0MSForms.exd
C:usersusernameAppDataLocalTempVBEMSForms.exd - After erasing the file restart your PC.
- Now open the Office apps and test its controls.
You must remember that when you would open your workbook with embedded active control, the.exd files be recreated created again, but it would not cause any issues. In this way, the Excel VBA ActiveX controls problem would be resolved. If still, the problem exists, then it can be fixed with the help of third party application software.
#2: Recover Data from Temp Files
It is recommended that apply manual repair method to fix Excel corruption and if you get unsuccessful then go with any other repair tool. Apply the below-given carefully to recover data from corrupted Excel file.
- At very first close MS Excel application and re-open it. Try to open the affected file.
- If you are unable to open the affected file then, reboot your computer and open MS Excel. Try to open the file again.
- If you are still unable to open the file then, delete the contents of your C:windowstemp directory then restart your computer. Try to open the affected file.
- If the affected file is still inaccessible then apply the below-given trick:
- Click on the Start button > Open run dialogue box and type-
- 'C:Program FilesMicrosoft OfficeOfficeexcel.exe' /s
- After it, try to open the file again
Are you unable to open the file again? if YES, then it is suggested to scan the file for possible virus infection. Make sure that your macro heuristics scanning option is set to ON.
After completion of the scan if no virus has been found then, rename the file name and replace the .xls extension with the .doc extension. After it, try to open the file with Word.
If all the above-given tricks failed to open the corrupt excel file or resolve ActiveX control Excel issues then try another trick:
Try to copy the damaged excel file to another location
- If the file you are unable to copy it to another location, then in actual there is a chance that the sectors on the disk may be damaged
- If the data is very important, then it is suggested to go for any professional service
Automatic Solution: MS Excel Repair Tool
Microsoft Excel Repair Tool is a special tool which is specifically designed to repair such kind of files so that one can easily continue to work in that file. This repair tool searches for .xls file in the folder specified by the user. The file which is found to be corrupted will create a preview in the Excel Repair window. The interface is very simple, with a large toolbar of buttons to add files or folder to the application. With this software, you can repair your corrupted Excel file. It can easily restore all corrupt excel file and also recover everything which includes cell comments, charts, worksheet properties and other related data. The corrupted excel file can be restored to a new blank Excel file. It has the ability to recover the complete data from the file and restore them even without modifying original formatting.
Enable Activex Excel
Steps to Utilize MS Excel Repair Tool:
Conclusion:
So, this is all about the Microsoft Excel ActiveX controls issues and how to repair the broken ActiveX controls issues in Microsoft Excel.
Hope after following the given solution you are able to fix the ActiveX Controls in Microsoft Excel.
Make use of the given solution to fix the error and start using the Excel file without any hassle.
Good Luck!!!
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.
I'm trying to get an Excel 2011 32-bit (for Mac) spreadsheet working that contains a macro. The problem is that this macro works fine on a PC, but not on the Mac. I tried to import Tim Hall's Dictionary.cls, but it still doesn't work. Same thing for KeyValuePair.cls.
Error: Run-time error '429'
ActiveX component can't create object
I'm not a programmer, so the problem is probably me, not knowing what to change to get things working. It's probably super easy for those who know what they are doing. Can anyone spend a few minutes looking at the files and tell me which parts I need to change to get this running? [I assume it does work…]
FWIW, I have tried to replace 'Scripting.Dictionary' with 'New.Dictionary' in two places (see below), but that didn't get it working.
RandomiseData file:
EDITED CODE
New.Dictionary is not a valid classname and will fail on PC as well. Usually the construct using early binding would be:
OR using late binding:
However, Mac OS does not have the Scripting Runtime library, so none of those things will be available to you — Dictionary, FileSystemObject, etc.
You'll need to use a Collection or other data type in lieu of Dictionary type, or you can borrow from this other answer and implement a custom dictionary-like Class.
I tried to import Tim Hall's Dictionary.cls, but it still doesn't work. Same thing for KeyValuePair.cls.
I suspect you simply didn't know that you also need to use conditional compilation method to assign the Dictionary class on a Mac OS, and the Scripting.Dictionary class on Windows OS.
Remove both of these lines:
Exchange server for microsoft account. Documentation » Connect to the Exchange Server using a Mac. Connect to the Exchange Server using a Mac. Select the options you want to use with your Exchange server. Mac OS X Mail Setup - Setting up a Printer in Windows - Smartphone and Mobile Device Setup. Solution: Contact your Microsoft Exchange account administrator. Ask your Microsoft Exchange account administrator to tell you which proxy server to use to connect to the Microsoft Exchange server. For information about how to configure a connection to a proxy server, see Mac OS Help. Use Server Settings preferences in Mail to change options for an account's incoming and outgoing (SMTP) mail servers. To change these preferences in the Mail app on your Mac, choose Mail Preferences, click Accounts, then click Server Settings.
They'll fail even in Windows, as I described above. Likewise, if you want to use this code in both Win and Mac environments, you can't use Scripting.Dictionary without taking some additional precautions to avoid errors.
You will need to implement conditional compilation using compiler directives to identify the OS. This is not overly complicated for anyone who's done it before, but it's not something that most beginners will even know is available to them, much less how to use it.
In pseudo-code, basically you're doing this:
Assuming you've copied the KeyValuePair.clsandDictionary.cls code from the other answer which implements the Dictionary replica in to plain text files, and imported both of the modules to your project's VBE.
I would put this code just above the line:
Practically speaking, as long as you place that code anywhere before you call on either of dAttributes or dValues, it doesn't matter where you put it.
This should work on both operating systems, as the Dictionary.cls mimics the Scripting.Dictionary‘s methods.
NB: It's preferable to group these object assignments, rather than peppering them about haphazardly throughout the procedure, especially when you're using conditional compilation as it will be more human-readable and easier to maintain moving forward.
Answer：
I see you said 'I tried to import Tim Hall's Dictionary.cls, but it still doesn't work. Same thing for KeyValuePair.cls.'
Excel Activex Controls Examples
Tim Halls's 2016 Dictionary.cls is a complete replacement for Scripting.Dictionary and does not require KeyValuePair.cls which is a helper class I provided at https://sysmod.wordpress.com/2011/11/24/dictionary-vba-class-update/
for my 2011 Dictionary.cls. Use either his class or my pair of classes, but not both.
Activex Plugin Mac
The advice on conditional compilation is good for writing code that works in either Mac or PC. I would suggestthat if you have your own dictionary class you don't need the Windows Scripting.Dictionary at all. I think it's better to have one class under your control than two where they might deviate in some subtle way.
Excel Vba Activex Controls
Tags: excelexcel, object, vba
