Hi Expert, I need your fover. let me explain you context. First I need to call web service from excel, I have to pass username and password to this web service, after user is validate .xsd schema well be download and stored locally. in this .xsd schema there is some validation rules. then I need to compare and validate excel sheet, if excel format not match as .xsd rule then highlight those cells and in last column of the excel sheet there put any error msg. if this excel error free then pass to wed service as argument. my .xsd file and excel file is attache with mail for your reference. please help me out. I don'e have any idea how to do this.
-- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
sample_bh_xsd.xsd
Description: Binary data
sample_bh.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
