file picker

Hi: I'm trying to use this standard bit of code: Dim fd As Office.FileDialog Dim strFile As String Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .AllowMultiSelect = False If .Show = -1 Then strFile = .SelectedItems(1) End If End With But I'm getting...

Hi, Using M365. A new data file is created daily. in .xlsx format. How can I setup power query to always prompt user to select a file? I was able to create the connection to a csv file using Legacy Wizard from Text and this is always prompting me to chooses a csv file But I cannot seem to...

I keep getting a subscript out of range error when I run this code Private Sub CommandButton1_Click() Dim file_path As String Dim xlApp As Excel.Application Set xlApp = CreateObject("Excel.Application") file_path = FileSelectBox("*.xlsx") xlApp.Visible = True 'xlApp.Workbooks.Open...

I am having trouble with the following code. It appears to be a very simple answer that eludes me. There is a Master Director that certain files will be copied from to a folder of the users choosing. I used the folder selector dialogue box for the selection but no matter which folder the user...