Excel Sheet to Combine all data within a folder

[Fredbugatti]

I have a sheet which I created which basically combines multiple excel sheets within a folders data into one main sheet.
I am getting the attached error saying it cant run on 64 bit.

I have attached the sheets, the main sheet is named MergeExcels and the error message is attached as well.


I appreciate the help, Thanks!

[Syrkrasi]

Here is what I found which may resolve your issue.

According to Microsoft the Existing Declare statements will not compile in 64-bit VBA until they have been marked as safe for 64-bit by using the PtrSafe attribute. You can find samples of this type of conversion at Excel MVP Jan Karel Pieterse’s Web site at: http://www.jkp-ads.com/articles/apideclarations.asp.


The Office Code Compatibility Inspector user’s guide is a useful tool to inspect the syntax of API Declare statements for the PtrSafe attribute, if needed, and the appropriate return type.