Multiple data import from text files

[Nils_Junker]

Hi everybody,

I got the following problem:

I need to get data from round about 500 text files.
Problem one is that I just need a part of each text file, (the part I need always stays the same)
Problem two is that I dont have enough time to manually convert all the text files one by one.

The following link shows all the files I want to include in my excel

Index of /climate_environment/CDC/observations_germany/climate/10_minutes/air_temperature/recent/

Also how many lines can i insert in Excel?

If you need further Information, please send me an info!

Thanks for your help!

 

[Herakles]

Dim WbMain As Workbook
Dim WsFileList As Worksheet

Public Sub subDownloadZipFileFromWeb()
Dim strFileUrl As String
Dim objXmlHttpReq As Object
Dim objStream As Object

 

[Nils_Junker]

Whoops -Sorry

You need to make reference in Tool - References in the VBA Editor to the last two ticked libraries on the attached image.

didn`t see that where can i do that?

 

[Herakles]

didn`t see that where can i do that?

Tool - References in the VBA Editor

 

[Nils_Junker]

Whoops -Sorry

You need to make reference in Tool - References in the VBA Editor to the last two ticked libraries on the attached image.

where can i change that?

 

[Herakles]

I assume that you are in the VBA / Visual Basic Editor.

Select Tools from the menu and then References.

Select Microsoft Shell Control and Automation
from the list. (Click in the small box to the left of it).

Also select Microsoft Scripting Runtime in the same way.

Click OK

 

[Nils_Junker]

I assume that you are in the VBA / Visual Basic Editor.

Select Tools from the menu and then References.

Select Microsoft Shell Control and Automation
from the list. (Click in the small box to the left of it).

Also select Microsoft Scripting Runtime in the same way.

Click OK

man i'm sorry it's been a long day, where exactly? am i even a little bit right?

 

[Nils_Junker]

View attachment 93651

man i'm sorry it's been a long day, where exactly? am i even a little bit right?

got it

 

[Herakles]

I don't speak German. Sorry

 

[Nils_Junker]

I don't speak German. Sorry

now this error comes up

 

[Nils_Junker]

I don't speak German. Sorry

do i have to download all the zip-files firstly?