View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen[_4_] Stephen Bullen[_4_] is offline
external usenet poster
 
Posts: 205
Default XML Mappings to VBA

Hi Koketso,

Is there a way to map xml tags to controls like Checkboxes,Comboboxes in
excel. I want to extract the data into xml.


Not directly, but you can set the controls' linked cell so it writes its
values to a cell, then map that cell to an xml tag.

Another thing is I have this huge project where I have to convert an online
wb app into an offline excel app. Are there any black spots i need to be
aware of?


I guess that depends on the design of the web app. If it uses lots of complex
web services, you might struggle to consume them through the Excel web
services toolkit.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev