8 (SOLVED )Compile Error in Hidden Module Module 1/ 2/ 3 (Tax Query by Harmeet)

Please watch our new work on
How to order food in zomato step by step at the following link

Using Windows XP service pack 2 and getting this bug when trying to generate XML using ITR workbook I must admit that this was a strange bug for i personally didn’t face it since i have a service pack 3 for windows XP but few people using service pack 3 also complain of this bug .

One of my subscriber’s while trying to fill the return (excel workbook ITR 1 )was getting this message .After analysing the message he got via his send email screenshot and going through his comments , i understood that it was not easy for me to replicate the problem because it seemed to be a operating system issue and in my parent laptop ,it didn’t seem a good idea to virtualise (create a seperate system for this version of windows XP),so i virtualised my other laptop and yes the bug did came in service pack 2 ,

.Basically the VB coding done vide modules used to generate the Extended mark up document don’t compile properly with versions of windows XP OS lesser than service pack 3 version…so people using windows XP service pack 2 might face this problem ,because when i installed windows XP service pack 2 in one of my 5 laptops , i got the same error ,

Firstly pressing alt +F11 opens up the visual basic editor which shows the module which the developer has coded for the excel workbook to work and generate the XML ,
Since clicking the XML throws up this error , it can be presumed that the OS with which it does has some compatibility issue ,next would be be to download a patch which enhances XML generation across such bugging operating systems ,

So ,being a developer i understood , that the solution then lies in enhancing the XML capacity of the OS and so my search on google for XML enhancing patches for Opreating system XP with service pack 2 started ,

Of the various patches i downloaded , the one shown in the video worked for my case .Across any version of operating system for windows XP(service pack 1/2/3 etc or windows 7, this is tested and works .I say this because r i did virtualisation and checked my 5 laptops for various combinations of operating systems / Office versions and the patch passed off beautifully ,

The links to download this xml enhanced patch directly from microsoft website are as follows ,

For 32 bit version Microsoft office version , you can download the Microsoft Core XML Services 6.0 Service Pack 1 from here ,

For 64 bit Microsoft office version , you can download this patch file at this location ,

The parent url for downloading the patch file is

Now, run this patch and then whether you run the excel workbook on windows XP or windows 7 or whatver and use whichever version , you should be sorted ..
Like the name of the file suggest’s , you should be now able to easily create XML files from the excel workbook …there is a alternative way to solve this issue as well by going to excel options and doing a few tricks but all that for a later time ,for i have too much to do ,

Hope this helps harmeet ,let me know whether it worked (cause it did in my other laptops where i replicated your Operating system, got the same bug and after installing this , it sorted out the issue ),

Cheers ,

Amlan Please Check my facebook page where i keep on adding more stuff and where you would find all the stuff that i have created till date .


Xem thêm bài viết khác:

Article Categories:
Tổng Hợp


  • How to Merge Form 16 Part A and Part B in Excel Free – V.365 file downloaded in my os windows 10 and office 2010

    Vineeth Naidu June 27, 2020 8:04 pm Reply
  • compile hidden module error: myvbacode please tell me solution

    Vineeth Naidu June 27, 2020 8:04 pm Reply
  • This is not working on my system.

    Sourabh Luniya June 27, 2020 8:04 pm Reply
  • My computers service pack is 1 and i am using microsoft excel 2007 and i have download the msxml , but there is a compile error

    Ragul Transport June 27, 2020 8:04 pm Reply
  • How do we resolve this on Mac with Microsoft Excel ver 15.11.2 ?

    Naresh Kapse June 27, 2020 8:04 pm Reply
  • Can you help me pls. I'm using word 2003 and when i copy or paste it is notification ( compile error in hiden module : modDirectEdit). I can not copy or paste in word 2003 T_T

    Mai Nhat Nam June 27, 2020 8:04 pm Reply
  • Can you help me, I am using a MacBookPro with MSO 2016 (Compile error in hidden module: Module2)

    SELECTOR SABY June 27, 2020 8:04 pm Reply
  • Thank you very much for your excellent idea. Your idea is very much helpful to me to upload the newly introduced VAT forms from July, 2016 by the Tamil nadu government. Once again I thank you sir.

    Muthusamy pillai Dhandapani June 27, 2020 8:04 pm Reply
  • Thanks a lot for the wonderful solution………special thanks to Harmeet for raising such issues

    Keyur Mehta June 27, 2020 8:04 pm Reply
  • Thank u so much for this video link now i can fix it

    Praveen Kumar June 27, 2020 8:04 pm Reply
  • when i give command to Calculate/ validate on my ITR1 XL filled filledup file , i get error saying RUN TIME ERROR 1004 so what shd i do pl

    Shreddy Karnam June 27, 2020 8:04 pm Reply
  • Hi. Can you give a solution for Mac? I am getting the same error.

    Lovish Sikka June 27, 2020 8:04 pm Reply
  • Hello Amlan,

    I also have problem in using excel with windows 7, we have some fixed templates and are password protected and very restricted… below is the msg i see when i open the the specific excel sheet i have to use… COMPILE ERROR IN HIDDEN MODULES. THIS ERROR COMMONLY OCCURS WHEN CODE IS INCOMPATIBLE WITH THE VERSION, PLATFORM, OR ARCHITECTURE OF THIS APPLICATION. 

    thank you
    hope to here from you soon.

    Rahim Popalzai June 27, 2020 8:04 pm Reply
  • Hi Amlan,

    My computer is 64-bit Windows 7 and has service pack 1. But I still get the "Compile Error in Hidden Module: Module 1" error message. I tried downloading the 64-bit msxml 6 service pack 1 but it is still not working, and I am getting the same error message. Do you have any ideas on how to fix this? Thank you!

    Anh Pham June 27, 2020 8:04 pm Reply
  • Hi Amlaan,

    Your solution worked amazing. Now I don't get any of those Error Pop-Ups.

    Thank bro.

    Varun Bhoopalam June 27, 2020 8:04 pm Reply
  • thanx

    Mahendra Spad June 27, 2020 8:04 pm Reply
  • Thanx a ton… It worked.

    Amit Agarwal CA June 27, 2020 8:04 pm Reply
  • Thanks a lot Amlan… it worked..

    Kunjan Goyal June 27, 2020 8:04 pm Reply
  • I have Service pack 2 & MS Office 2007, pls tell how to remove error, Compile error in hidden module 1

    Chander Prakash Gupta June 27, 2020 8:04 pm Reply
  • I am getting an Error " Compile Error In Hidden Module – Module-11", in Windows-8.1, I have downloaded that patch file but still getting the same error, May you help in this….

    Rajesh Sharma June 27, 2020 8:04 pm Reply
  • Hi, I'm facing an Error of Compile error in hidden module: modImportXML while filing the excel ITR Sheet. I'm Using Windows 8 64 bit. I tried to install MSXML Parser 6.0 service pack 2 but it didn't work..can you help..Thanks

    Avinash kumar June 27, 2020 8:04 pm Reply
  • thank you very much alman

    Sreepal Reddy Gurrala June 27, 2020 8:04 pm Reply
  • Thanks buddy great work… 

    esubeesh June 27, 2020 8:04 pm Reply
  • Thanks a lot Amlan…

    Vaibhav Jain June 27, 2020 8:04 pm Reply
  •  same bug i m getting while running the application , i download the patch hope this is work,

    Alankar Tomar June 27, 2020 8:04 pm Reply
  • by what name should i find u on facebook?

    Ankit Baranwal June 27, 2020 8:04 pm Reply
  • any solution for Mac book

    Manish Rawat June 27, 2020 8:04 pm Reply
  • Wow! it really works, thank you so much YOU GENIUS……

    Suriya Vimal June 27, 2020 8:04 pm Reply
  • Great.. Helped me solve d problem.. Thanks a lot…
    Good job.. 🙂

    Dipika Agarwal June 27, 2020 8:04 pm Reply
  • Thank you so much….

    Krishna Rao Konakala June 27, 2020 8:04 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *