As to your second question, we can find the document from the link. From the document, we can know that the Compatibility Pack is used to open, edit, save, and create files that were created in Office 2013, Office 2010 and the 2007 Office systems with Microsoft Office XP, or Office 2003. So I think the Compatibility Pack cannot help you. I have an Excel Query that pulls information in from another database one of the fields comes across in HTML format. I have found the code below to convert it to text however it leaves a lot of empty spaces above and below. Addintools Assist for Microsoft Excel v.1.6 Supports Microsoft Office/Excel 2007 now!Convert data between Date, Numeric, and Text formats. Microsoft Office Marketplace logoFast, smart, and safe to work with.Recognize more than ten date formats including:, 2006-12-31. 'The VBA Converter Pack is not included as a part of the Microsoft Office suites. At the top of this article, click View and request hotfix downloads' I cant see this option.
Chandana_Gadugu
New Member
Microsoft Vba Converter
Now the same needs to be migrated in Microsoft excel 2010 (32 bit)version.Yesterday, when we tried to open the excel tool in 2010 but i was not able to run and aborted the process with the error message which was as below:
Opening the VBA project in this file requires a component that is not currently installed. The file will be opened without the VBA project.
For more information, search Office.com for 'VBA converters'
But some of the tools of Version 2003 we are able to open them in 2010.Are there any specific problems w.r.t VBA converter w.r.t certain excel tools.
Please can anybody help me regarding the same.
Thanks In Advance,
Chandana
Prerequisites
You need to have the Microsoft Windows 7 or higher as well as Microsoft Office 2007 SP3 or higher with the latest service pack and updates installed on your computer.
Please make sure that Microsoft Office Visual Basic for Application (VBA) component is selected in your MS Office installation. To verify that you need to open Microsoft Excel and click Alt+F11 key combination. If the VBA Project is opened that means you have Visual Basic for Application (VBA) in your Excel installation.
Before protect your workbook with XCell Compiler you need to enable “Trust access to the VBA project object model” MS Excel option via the following path:
Excel Options >> Trust center >> click button “Trust Center Settings…” >> Macro Settings >> enable check box “Trust access to the VBA project object model”
You need to perform this step only once, before the first compilation.
Watch this video on YouTube
Steps
1.Download the DoneEx XCell Compiler and install it on your computer. Detailed instruction how to download and install the product you may find in video above.
2. Open your workbook by double clicking on it in the Windows Explorer. If it did not open then do the following:
Open Excel from Windows Start Menu shortcut and load your Excel spreadsheet by using the Excel File Open menu, or just Drag-and-Drop your workbook on to the Excel window.
3. Find DoneEx menu at Excel main menu.
Click DoneEx >> XCell Compiler >> Compile
4. Fill out the compilation form with your data and preferred options, then click on the “Compile” button.
5. When compilation is completed, close Excel, and run the EXE file. You may find the compiled EXE file at the location that you have chosen in the “Target Path” field on the compilation form.
Excel Formula To Vba Converter
Vba Converters Excel
The workbook is secured now. You can send the compiled application to your client with peace of mind.