Does anyone know a fix for VBA Converter for Excel 2013?

vba excel office-2013 excel-2013
user2520447 picture user2520447 · Jun 25, 2013 · Viewed 9.6k times · Source

We have a program that outputs an old excel format. When we used Excel 2010, we had to use a Microsoft Hotfix that allowed the old formats to be converted, found here: http://support.microsoft.com/kb/926430 ... the fix says it should work in 2013, but I haven't had any luck. My hunch is that there is not a VBA 7 folder as described, but a VBA 7.1 folder instead. 32-bit systems. (I'm aware that the link says for 64-bit, it contains a 32 and 64-bit fix.) Hopefully someone has already run into this problem and has some advice!

Thanks in advance.

Answer

Yuhong Bao picture Yuhong Bao · Nov 27, 2013

It should work the same as 2010, and yes you drop the DLLs into the VBA7.1 folder instead of the VBA7 folder.

Related questions

Excel 2013 64-bit VBA: Clipboard API doesn't work

I used to be able to use Windows API calls in Excel VBA to set text on the clipboard. But ever since upgrading to 64-bit Office 2013, I cannot. Below is some code that does not error, but it is also …

Read More
How do I make an Office 2013/2016 application run in separate process on Microsoft Windows?

I am developing a Excel plugin. It works all right for Excel versions before 2013. But a lot of features is broken when it runs against Excel 2013. I found the root cause is all windows are running in only one process …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More