VBA, opening files.

[asaunders123]

Hello all.
I'm relatively new to VBA, and learning how to use it has been very useful. I am currently stuck on something, the below code shows what I have so far.

I can use this piece of code to find out the path of my workbook:
Path = Application.ActiveWorkbook.Path


And this piece of code opens a file with a .LOG extension from a pre-determined file path(same filepath as the workbook), copies the sheet, pastes it into my workbook and loops. This works well.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

I need to combine the two so I don't have to manually type in/copy paste the file path. Any help would be massively appreciated.

Thanks

[6StringJazzer]

This seems obvious to me so maybe I don't understand the question:

Please Login or Register  to view this content.

[Marc L]

Hi !

To 6StringJazzer : works only if you do not forget to add the path separator at the end of the workbook path !

[asaunders123]

Hi,

I had been using "Activeworkbook.Path" with no success. I then researched the ways of implementing the path separator.

I have come up with this :Path = ActiveWorkbook.Path & Application.PathSeparator
And it works!

Thanks for your guidance (Y)

[6StringJazzer]

I had been using "Activeworkbook.Path" with no success. I then researched the ways of implementing the path separator.

I have come up with this :Path = ActiveWorkbook.Path & Application.PathSeparator
And it works!

Thanks for your guidance (Y)

Glad to help and sorry that I did not give the correct answer. On a Windows machine you can just use

ActiveWorkbook.Path & "\"

but the code you came up with will run on both Windows and MacOS.