Data import folder

[maksim]

Hi all,

Can you please assist. I currently got a macro that imports data (.dat), however i can only get it to pick it up from a specified location. The requirement is to make it pick up the files (they are always the same) from the same location that the spreadsheet is in. So pretty much fileName = ActiveWorkbook.Path + "<file name>". However, i can not get it to work. Can someoine please help me make the path the active workbook path. Thanks.
My current code is.

Please Login or Register  to view this content.

[Leith Ross]

Hello maksim,

Welcome to the Forum!

To make posts easier to read, copy and edit, please use code tags. I have done this for you because you are new. Do take some time to read the forum rules. These help make it easier to find and get answers quickly to your questions.

As a new member, please take some time to familiarize yourself with the rules.
Click here for the Forum Rules

[JBeaucaire]

Hi Maksim. You don't show the rest of your macro, so I don't know if you're familiar with declaring and using variables.

Please Login or Register  to view this content.

[maksim]

THANK YOU!!!

Its solved. Before posting, i tried declaring them path as variable but couldnt get the write syntax in the ""TEXT;" & fPath & fName, Destination:=Range("A1"))" line.
But now its perfect.

Once again, thank you!

[JBeaucaire]

Glad to help.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.