Opening a folder from VB

Axxess · September 6th, 2006, 05:00 AM

I need to select manually the final subfolder to save target file.
How can I get visual basic to activate similar to "save as"-function and capture the final folder location (after opened) to a variable to get the target file saved into the final folder.

:):):) Axxess

maccas · September 6th, 2006, 05:10 AM

Axxess,

Do you mean VBA or VB - I'm assuming you mean VBA (i.e. the language packaged with Excel). If its VB you're after then a slightly different answer will apply.

You do this by using Application.GetSaveAsFilename, which will open a Save As dialog box for the user to manually enter a save file name. The method returns a string which can then be used to save the file. An example would be as follows:

Code:

Sub TestSave()

Dim strNewFileName

    strNewFileName = Application.GetSaveAsFilename(InitialFileName:="Test.xls", Title:="Test Save Procedure")
    ThisWorkbook.SaveAs Filename:=strNewFileName

End Sub

Axxess · September 6th, 2006, 05:49 AM

THANKS A LOT maccas!!!

I got one step further with the project.
Tested and does exactly what you described.

:D:D:DAxxess (and also Eksel etc..)