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 www.facebook.com/filingreturnsonline where i keep on adding more stuff and where you would find all the stuff that i have created till date .

Nguồn: https://laneletters.com/

Xem thêm bài viết khác: https://laneletters.com/tong-hop/

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

    Vineeth Naidu July 5, 2020 5:39 am Reply
  • compile hidden module error: myvbacode please tell me solution

    Vineeth Naidu July 5, 2020 5:39 am Reply
  • This is not working on my system.

    Sourabh Luniya July 5, 2020 5:39 am 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 July 5, 2020 5:39 am Reply
  • How do we resolve this on Mac with Microsoft Excel ver 15.11.2 ?

    Naresh Kapse July 5, 2020 5:39 am 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 July 5, 2020 5:39 am Reply
  • Can you help me, I am using a MacBookPro with MSO 2016 (Compile error in hidden module: Module2)

    SELECTOR SABY July 5, 2020 5:39 am 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 July 5, 2020 5:39 am Reply
  • Thanks a lot for the wonderful solution………special thanks to Harmeet for raising such issues

    Keyur Mehta July 5, 2020 5:39 am Reply
  • Thank u so much for this video link now i can fix it

    Praveen Kumar July 5, 2020 5:39 am 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 July 5, 2020 5:39 am Reply
  • Hi. Can you give a solution for Mac? I am getting the same error.

    Lovish Sikka July 5, 2020 5:39 am 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 July 5, 2020 5:39 am 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 July 5, 2020 5:39 am Reply
  • Hi Amlaan,

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

    Thank bro.

    Varun Bhoopalam July 5, 2020 5:39 am Reply
  • thanx

    Mahendra Spad July 5, 2020 5:39 am Reply
  • Thanx a ton… It worked.

    Amit Agarwal CA July 5, 2020 5:39 am Reply
  • Thanks a lot Amlan… it worked..

    Kunjan Goyal July 5, 2020 5:39 am Reply
  • I have Service pack 2 & MS Office 2007, pls tell how to remove error, Compile error in hidden module 1

    Chander Prakash Gupta July 5, 2020 5:39 am 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….

    PIYUSH SHARMA July 5, 2020 5:39 am 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 July 5, 2020 5:39 am Reply
  • thank you very much alman

    Sreepal Reddy Gurrala July 5, 2020 5:39 am Reply
  • Thanks buddy great work… 

    esubeesh July 5, 2020 5:39 am Reply
  • Thanks a lot Amlan…

    Vaibhav Jain July 5, 2020 5:39 am Reply
  •  same bug i m getting while running the aces.gov.in application , i download the patch hope this is work,

    Alankar Tomar July 5, 2020 5:39 am Reply
  • by what name should i find u on facebook?

    Ankit Baranwal July 5, 2020 5:39 am Reply
  • any solution for Mac book

    Manish Rawat July 5, 2020 5:39 am Reply
  • Wow! it really works, thank you so much YOU GENIUS……

    Suriya Vimal July 5, 2020 5:39 am Reply
  • Great.. Helped me solve d problem.. Thanks a lot…
    Good job.. 🙂

    Dipika Agarwal July 5, 2020 5:39 am Reply
  • Thank you so much….

    Krishna Rao Konakala July 5, 2020 5:39 am Reply

    himanshu vyas July 5, 2020 5:39 am Reply
  • Thank's Amlan
    Thank u very much.
    And hope you help me again in future.

    Pankaj Jha July 5, 2020 5:39 am Reply
  • Hello,
    I am getting the same problem for Windows 7. how to solve this?

    Rangarajan M.S July 5, 2020 5:39 am Reply
  • Hi Amlan,

    Thanks a lot for that fix as well. I was stuck with SP2 –> SP3 Transition so replying late.
    And now i can very well play with that excel also.

    I have to appreciate your work again, and i mean it.
    You have explained these things in a very lucid manner.

    Will definitely spread the word.
    And hope to ask you for help again in future. 🙂

    Have a great time.
    Cheers !

    harmeet singh July 5, 2020 5:39 am Reply

Leave a Reply

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