VBA to open specific file path using info from userform textbox

[S_SSharma1212]

I'm trying to open a specific folder on a network based on the information entered by user. This entered information updates the header info, so cell values won't be accessed. The input corresponds to a number and a name, that would also be part of Folder Name and Workbook Name as well. I've been able to prompt open the save as dialogue box once the user press enters on the form, but the path code I still can't figure out. If someone can help with this please.

 

[Michael M]

Something like

dim fpath as string
fpath = "C:\data\user\"
/CODE]
then add the strings from the Inputbox

 

[S_SSharma1212]

Something like

dim fpath as string
fpath = "C:\data\user\"
/CODE]
then add the strings from the Inputbox

Thanks, Michael. The issue is that user form input is not exactly the folder name but part of the folder name at a specific address. This is what I'm currently using to open the saveas dialogue box:

Dim bFileSaveAs As Boolean
    bFileSaveAs = Application.Dialogs(xlDialogSaveAs).Show

 

[S_SSharma1212]

Hey Guys, so I am using the following code currently to open up the save as dialogue box. The only issue is it doesn't save in the required file format (i.e. xlsx). I'm calling this sub in my userform okay button code to execute.
All and any help is appreciated.

Sub filesaveas()

Dim strDefaultPath As String
Dim strDefaultName As String
Dim strDialogBoxName As String
Dim strFilePath As String

strDefaultPath = "X:\Job Folders\"
strDefaultName = "-" & Jobnumber.Value
strDialogBoxName = "Save in the Desired Job Folder"

strFilePath = Application.GetSaveAsFilename(strDefaultPath & _
    strDefaultName)

    If strFilePath = "False" Then
        Exit Sub
    Else
        ActiveWorkbook.SaveAs filename:=strFilePath
    End If

ActiveWorkbook.SaveAs
End Sub

 

[S_SSharma1212]

So, using a slightly different approach, I've been able to open the specific location in which I want to save the file. The only issue I'm left with is prefilling the filename and the file type.

This is what I'm currently using to open the saveas dialogue box:

    ActiveWorkbook.Application.GetSaveAsFilename ManualFolderPath

I've similar process in a word document where the code used to open the saveas dialog is something like this:

With Dialogs(wdDialogFileSaveAs)
        .Name = ManualFolderPath
        UserSaved = .Show
    End With

I'm trying to figure out the suitable changes to the above word code to be used in the excel sheet.

Thanks for all the help.