| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening XML files using Office 2000 or VB6
Thanks!
"Gareth" <nah wrote in message ... Microsoft provide an SDK that allows you to work with XML files within VBA. I've used it with XL2000 in the past. (I think this is the right link...) http://www.microsoft.com/downloads/d...DisplayLang=en HTH, G Amir wrote: Hi, I'm using Excel 2000 and I wish to build a VBA macro which will compare specific fields in a given .xml file to specific fields in a standard Excel .xls file. I know the VB / VBA which is needed to compare fields in 2 worksheets, but I don't know how to open the .xml file using Excel 2000. Is that possible to open xml file using Excel 2000 or I have to use higher version of Excel? If it's not possible to do that in Excel 2000, can I use VB6 to do that despite the fact that I don't have higher version of Excel? How can I use VB6 to open the records/data in that XML file? Should I use ADODB for that? Is that possible? I know it's not a VB discussion group so if you direct me to a better group for that question it's fine. I'm using: Office 2000, Windows 2000 Pro, and Visual Studio 6. I know VBA, some VB and a bit of API calls. I do NOT know VB.NET. Kind Regards, Amir. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| has anyone had problems opening csv files in office 2007 ? | Excel Discussion (Misc queries) | |||
| Opening an Office 2003 Excel doc with Office 2000 NT | Excel Discussion (Misc queries) | |||
| Opening a CSV file makes MSI want Office 2000 SR-1 Premium disk (DATA1.MSI) | Excel Discussion (Misc queries) | |||
| Opening a CSV file makes MSI want Office 2000 SR-1 Premium disk (DATA1.MSI) | Setting up and Configuration of Excel | |||
| How do I open Excel 4.0 files in Office 2000? | Excel Discussion (Misc queries) | |||
Hybrid Mode
