EXCEL VBA讀取XML解析取出資料
XML檔內容如下 <Form formVersionId="5449540f"> <FormFieldValue> <FieldItem fieldId="0" fieldValue="180900010" realValue="" enableSearch="True" /> <FieldItem fieldId="1" fieldValue="台北" realValue="ec3a9bd9" enableSearch="True" /> <FieldItem fieldId="2" fieldValue="XXXXX" /> <FieldItem fieldId="9" fieldValue="單位" realValue="" enableSearch="True" /> <FieldItem fieldId="5" fieldValue="台北醫院" realValue="" enableSearch="True" fillerName="XXXX" fillerUserGuid="e1aee539" fillerAccount="0122" fillSiteId="" /> <FieldItem fieldId="7" fieldValue="2018/09/20" realValue="" enableSearch="True" fillerName="XXXXXX" fillerUserGuid="e1aee539" fill...