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!

 

[Nils_Junker]

Lets sort this out and get onto the next stage.
I don't speak German so I cannot translate the messages.
You need the following folders as sub-folders of the workbook folder.
Downloads
ImportedData
You need a folder called Unzipped which is a sub-folder of the Downloads folder.
You can only select cells in column one.
If you select any cells outside of that column and or not containing a valid filename then
you will get a message as in the attached image.

Please confirm that you have been able to download and unzip at least one file.

Okay so I hadn't created the folder ImportedData butz i've done that now.
Problem is still the same. If I fill for example Column A2 in the query in which range i want to select the error comes up.

And so no i wasn'T able to download and unzip the folders.

If i click on help this site comes up:

Thanks for your help and time. I hope we can find a way together to make that work.

 

[Nils_Junker]

Okay so I hadn't created the folder ImportedData butz i've done that now.
Problem is still the same. If I fill for example Column A2 in the query in which range i want to select the error comes up.

And so no i wasn'T able to download and unzip the folders.

If i click on help this site comes up:

View attachment 93817

Thanks for your help and time. I hope we can find a way together to make that work.

Is it possible that i have top change some settings in my excel?
or is there a differentation between english and german in the setteíngs?

 

[Herakles]

There probably is a difference but not that should have an effect on this running.

Can you put a Breakpoint at the top of the code and step through each line of code using F8.

Only select one file to start with and then two on the next attempt.

If an imported file appears, go back to the VBA Editor and press F8 to continue.

 

[Nils_Junker]

There probably is a difference but not that should have an effect on this running.

Can you put a Breakpoint at the top of the code and step through each line of code using F8.

Only select one file to start with and then two on the next attempt.

If an imported file appears, go back to the VBA Editor and press F8 to continue.

how do i put a breakpoint?

 

[Herakles]

how do i put a breakpoint?

See image

Click where pointed to add a breakpoint.

 

[Nils_Junker]

See image

Click where pointed to add a breakpoint.

okay did it.

if i come to this line

then i have to answer if i want to clear the data (where you said i should tick "yes" and afterwards i have to insert the range. and at that point the error comes up

 

[Nils_Junker]

See image

Click where pointed to add a breakpoint.

Another question, if you run it on your PC/Laptop does it even work?

 

[Nils_Junker]

See image

Click where pointed to add a breakpoint.

okay i am a little bit closer to the problem.
Firstly I didn't had the worksheet "ImportedData"

now if i go through the code with F8 an error comes up in the following section:

the link when i click on help is the fololwing:

Application-defined or object-defined error

Office VBA reference topic

learn.microsoft.com

So it looks like this at my laptop:

On english thi is Runtime Errror 3004, Applicatiob or object defined error.

i think we are close to an end!

 

[Herakles]

Another question, if you run it on your PC/Laptop does it even work?

I have managed to download and extract all of the files.

Next step is to process the data.

 

[Herakles]

okay i am a little bit closer to the problem.
Firstly I didn't had the worksheet "ImportedData"

now if i go through the code with F8 an error comes up in the following section:

View attachment 93848

the link when i click on help is the fololwing:

Application-defined or object-defined error

Office VBA reference topic

learn.microsoft.com

So it looks like this at my laptop:
View attachment 93849
On english thi is Runtime Errror 3004, Applicatiob or object defined error.

i think we are close to an end!