Extract the submission number from gocanvas.com by adding to existing VBA code

Hi, I've done extensive Excel and VBA development for the investment banking industry, and having looked at your spreadsheet already, I can tell you that it's very straightforward to amend your code to include the submission ID. The submission ID is actually already being downloaded - to illustrate: Function "GetEstimateFields" includes the statement "Call GetAllMatches(all_res, "<Submission Id", "</Submission>", Estimates(), NumEstimates)" - the purpose of which is to split the downloaded xml formatted text into individual estimates for further processing - all the data fields (Name, Phone, Address etc...) are between the "<Submission Id" and "</Submission>" tags used in the above statement - the actual Submission Id is just after the "<Submission Id" text. The point is that the actual Submission Id is definitely being downloaded - it's just not being allocated first to a variable and then to a cell. So the good news is that no Canvas Web Service API calls need to be amended - it's quite literally a case of manipulating a text string.

Happy to help you with this project. Guaranteed quick turnaround Please feel free to message me if you need to discuss any questions

Hello Sir, I am an expert in VBA with over 10 years of experience. Ready to start Thanks, Alex ====

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

Hi: Please note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my projects are related to Excel and macro programming. Please connect with me to discuss more.

Hi, Please feel free to discuss the project with me ............................................................................ Thanks, Murtaza

Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# Thanks Abhinov

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, VBA for MS Office

I am expert in VBA and implemented several complex features in excel and access . I would like to work with you. Regards, Selvan

Hello I will use all my skills as a computer engineer to satisfy you and within the time specified. Also, I will do everything my expertise available to the project. More information, you may contact me See you soon

Greetings for the day!!! I have 5 years of experience in VB, VBA Macros with applications like SAP, Internet Explorer, PDF & Text files,Excel functions and formulas,Dashboard creations in excel like Pivots, Charts, MS Access and SQL Server databases. Hope if awarded with this project i can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M