Okebiz Video Search



Title:8 (SOLVED )Compile Error in Hidden Module Module 1/ 2/ 3 (Tax Query by Harmeet)
Duration:06:11
Viewed:142,200
Published:31-07-2013
Source:Youtube

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

https://www.youtube.com/watch?v=GiR1b... --~--
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 ,
(1)http://download.microsoft.com/downloa...

For 64 bit Microsoft office version , you can download this patch file at this location ,
(2)http://download.microsoft.com/downloa...

The parent url for downloading the patch file is
(1)http://www.microsoft.com/en-in/downlo...

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 .

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
How to build Interactive Excel Dashboards How to build Interactive Excel Dashboards
52:26 | 647,899
Drone Programming With Python Course | 3 Hours | Including x4 Projects (2021) Drone Programming With Python Course | 3 Hours ...
33:03 | 292,110
Microsoft Access 2016 Tutorial: A Comprehensive Guide to Access - Part 1 of 2 Microsoft Access 2016 Tutorial: A Comprehensive...
11:43 | 683,821
دليلك لتعلم الاكسل من الصفر حتى الاحتراف في فيديو واحد! دليلك لتعلم الاكسل من الص...
57:18 | 995,547
Creating Easy Data Entry Forms in Excel Creating Easy Data Entry Forms in Excel
09:52 | 457,541
Active Directory Tutorial for Beginners Active Directory Tutorial for Beginners
28:45 | 797,123
GST Eway bill Bulk Tool Compile error in Hidden module sheet 3 and date format error solved GST Eway bill Bulk Tool Compile error in Hidden...
09:10 | 16,959
Protect Excel VBA Code With VBA Compiler (How-To Get Started) Protect Excel VBA Code With VBA Compiler (How-T...
09:32 | 805


coinpayu