Import Data from xml files into excel using vba

**DaoB-** · 03-13-2020, 04:48 AM

I need a Script to import website Data (since im a complete dummy), from xml files into excel. It needs to be automated due to it being 200+ files.
The data is on line 1 from a-as.
Literally just has to read out all data and throw it into one excel file.

Greetings Dao

**Kaper** · 03-13-2020, 05:09 AM

If it's just single action - and you gave no single detail about the files (where they are located, what is the naming convention, is the site password protected etc, etc.) for just 200+ files and "a dummy at a keyboard" I'd recommend go through this manually file by file.
See https://support.office.com/en-us/art...1-c736da817fa4

Or … share more details :-)

Import Data from xml files into excel using vba

LinkBack

Thread Tools

Rate This Thread

Display

Import Data from xml files into excel using vba

Re: Import Data from xml files into excel using vba

Thread Information

Users Browsing this Thread

Similar Threads

Import two txt files in excel and highlights the differece b/w two files data

Excel macro to import data from many files

Data import from .xls files into excel

Import data between excel files

Import data from other excel files

[SOLVED] Import data from multiple excel files

[SOLVED] few excel files :Import External Data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions