Path to save file

[Crispy85]

Hi,

Google and all these Guru's on this forum helped me to create a macro.
The location of this macro file is somewhere (different people use it and they have it on different places which shouldn't matter).

The macro picks up files from a selected folder. (so it opens a window where you can choose your folder where the files are.)

Somewhere later in the macro it asks to save a file, and i want to save it in the same folder as where it picked up the files earlier.

The code to pick up the items is:

Please Login or Register  to view this content.

The manual step now is that a window opens to save the file, which always needs to go in the folder where it picked the files earlier anyway.

the code i use for this is:

Please Login or Register  to view this content.

Does anyone know if it 'remembers' this Get_Folder_path. So it automatically saves this New file in the earlier chosen path?
Thanks for all the help and i'm sorry if i'm unclear....

Thanks,
Crispy85

[Kenneth Hobson]

As you can see, GetParentFolderName will suffice.

Please Login or Register  to view this content.

[Crispy85]

Hi Kenneth,
Thanks for your answer, but i don't really understand.

In this sub i still have to choose the folder where i want to save the "New.xls". I want it to automatically save the file in the folder that i have chosen earlier with:

Please Login or Register  to view this content.

Thanks

[Kenneth Hobson]

I am not sure what you are asking. Have you not gotten it when you used?

Please Login or Register  to view this content.

[Crispy85]

Sorry, i'm pretty much beginning in VBA so that's maybe why i am a bit unclear.
Step 1) i choose a folder with files with the macro i showed in my first post
Step 2) then it opens the files from that folder
Step 3) the macro makes adjustments and such things in the open files (script is not in my first post)
Step 4) then it makes a new book that it needs to save (In my example it is "New.XLS"

How things now are going it ask the user to save the file. This file always need to go in the folder that is chosen with step 1.

So i was wondering if anybody knows a way to let vba save the file (step 4) automatically in the same folder that is chosen with step 1. (it's one more step less manually)

[Kenneth Hobson]

Please Login or Register  to view this content.

[Crispy85]

Hi Kenneth!

Yes i was thinking about this, the only problem now is: it saves the file in the folder where the macro is located. While it should save it in the folder with the files i chose, if you understand what i mean.

[Kenneth Hobson]

Yes, I would expect that if the user chose that path. If they pick another in your function's dialog, then that one would be set.

The method I gave gives you the folder of some file. That may or may not help. It just depends on your goals.

[Crispy85]

Does anyone else have an idea?
I have an idea but i don't know how to program it lol.

Maybe when the folder is selected, it puts the path's name as value in workbook "Macro" and sheet "Start" in range A1.
Later it could use this as a reference to the right path?

[Crispy85]

Hi everyone,

i want to bump this topic.
As shown in my first post. My macro picks up files from a chosen folder.
Is it possible to put the chosen path as text in my sheet?

For example: the path C:\Test\test is chosen and the macro puts this as text in cell a1 in sheet "start"

Thanks for all the help.