search

ronle / Json-To-Excel

30 stars 20 forks source link

Error when opening file #1

Open neodjandre opened 9 years ago

neodjandre commented 9 years ago

I cannot open any JSON files. Using Excel 2013. The VBA code errors out. The open file window does not appear at all

ghost commented 9 years ago

Same problem. On office 2010 it works but on 2013 it said "unable to find reference or library"

ronle commented 9 years ago

Hi duydangle, neodjandre, First, apologize for long reply time, had to find time and get my hands around Office 2013 first to try and reproduce the error. However, running my script on my machine I was unable to reproduce the error which may suggest an internal VB reference is not enabled on your machines.

Could you kindly check if under Excel "Developer tab --> Visual Basic", open VB editor and select "Tools --> References" the enabled add-ins? The ones I'm using for this script to work are:

-Microsoft Script Control 1.0 -Microsoft Forms 2.0 Object Library -Microsoft Windows Common Controls 6.0 (SP6) -Microsoft VBScript Regular Expressions 5.5

I've also added a picture of these references. Let me know if these helped with resolving the problem. If so I will add these at default upload level so they would be automatically defined once the script runs.

Thanks much, Ron