MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Import XML

  Asked By: Jodon    Date: Nov 12    Category: MS Office    Views: 949

I created a transform workbook and would like to write a macro to allow
the user to import different XML files. in the workbook (Excel 2007) i
issue the command under the Developer tab / XML / Import. It open a
file dialoged box, I select my file and the data is refreshed.

I searched help and do not understand the "expression.XmlImportXml
(Data, ImportMap, Overwrite, Destination)"

an you help me with an example of proper code or the correct object to



1 Answer Found

Answer #1    Answered By: Flynn Jones     Answered On: Nov 12

I do not know the answer but ..

Can you record a macro  doing what you want to do and see what the parameters
seem to be?

Didn't find what you were looking for? Find more on Import XML Or get search suggestion and latest updates.