subscript out of range error when running testImport

hilkoc / vbaDeveloper

Tools for development and version control of vba code

MIT License

510 stars 138 forks source link

subscript out of range error when running testImport #24

Closed abbood closed 7 years ago

abbood commented 7 years ago

I'm running this on Excel 2016 (as part of the office 365)

I followed the detailed instructions.. but when I put the cursor on the testImport function and ran f5.. I got this error:

any ideas?

brochuJP commented 7 years ago

I had the same problem. If you select vbaProject (vbaDeveloper.xlam) in the Project window, and after you go in the Properties window, you must see the name "VbaDeveloper". In other therms the Property Name of you VBA project must be equal to the variable proj_name that is declare in testImport.

hilkoc commented 7 years ago

Indeed as brochuJP said, don't skip step 3 in the installation steps, to rename the vba project to vbaDeveloper.