Grab file from network?

Is it possible to Remote Desktop Connect into server and grab text file? With correct id and password of course?
If so, please show me how or point me to correct thread because my search doesn't come up with what I'm looking for.

So I want to:
logon to one server
multiple folders copy it's .txt files
copy it to active excel workbook or sheet

I was able to logon to server and grab a file and capture it with macro.
With the code below, why does it still pop up about the delimmited or fixed?
I don't need those features I just want to copy and paste it. I want the way it is.

Please Login or Register  to view this content.

Capture.PNG