With more and more providers stopping us from being able to download data in QIF format for software like Microsoft Money and Quicken, many of us can only download CSV files instead.
In this video, I explain how to automatically convert a CSV file into to a QIF file Using a simple Microsoft Excel Add-In
Here’s the link to the add-in software download page used in the video:
…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
I FIXED IT! The Compile Code Error! I chased down what the error was stating, and took a crash course (through annals of Google) to understand how to open the hood, make a couple changes, put it all back together, turn the key, and rev'r up! It's a matter of cracking the password on the XLA VBA project (simple with HEX editor). Then, it's a simple matter of adding PtrSafe safe word to every Declare statement in the TOOLS module within the project (there are only two of them, I believe). So, instead of the code reading Declare (yadda yadda), it should read Declare PtrSafe (yadda yadda). Enjoy (and if there are any viruses in this, I didn't put it there – I only did exactly what I said above – use at your own risk, and be sure to scan all software before installing/running): https://www.dropbox.com/s/exj8q0w7wci7kxe/xl2qif_1.11.ccomplie.fix.zip?dl=0
Hi I appreciated the video as well but now wish I had read the comments first. I have also run into the 64bit incompatibility problem with my Excel365 – "Compile error in hidden module" whenever I open Excel. Does anyone know how to fix that?
Thank you for an exceptionally thorough and helpful video. Your clear instructions, calm manner, and structured approach all make this complex process understandable. I truly appreciate it.
Same compile error as other posters. Using Win 11 and Office professional 2021. "Compile error in hidden module: Tools. This error commonly occurs when code is incompatible with the version, platform or architecture of this application". Re-installed on old laptop with Win 10 Pro and Excel2000 (seriously) and it works OK.
I got the compile error in hidden modeule message also.
I could modify the original code and have a working version on Excel 365. Don't remember well how I did it but it works…., I think I found a way to crack the password to the VBA project and made the changes necessary for it to work in 64 bits that I found somewhere…
I'm getting the "Compile error in hidden module" message. I'm using 64 bit Office 365 on Windows 10.
How did you manage to not get the compile error in hidden module for using this 32 bit add in. Are you using a 32 bit Windows/Excel?