USERFORM TO SEARCH FILE EXPLORER

[geno32080]

Has anyone ever used a UserForm to open File Explorer, and be able scroll to a file, and click on a command button on the Userform to select that file? I have a Excel template, from there I have a command button that opens a Userform, this is where I would like to have that option of scrolling thru file explorer and choosing a past work book and have it open that work book, copy some specified cells, close that work book and paste the copied cells to specific cells on the template. Think that's possible?

 

[Micron]

Research msoFileDialogFilePicker for files, msoFileDialogFolderPicker for folders. Button click event on form could run code for this. Once the dialog returns the path of the selected file/folder your could would open the workbook, copy the range and paste into the target workbook. I probably wouldn't close the source file until the paste is successful.
If the source file range is edited, your copy would be out of sync so is this the best approach? Can you not just specify the source workbook as a linked data source which then causes the target file to remain current?

 

[geno32080]

Research msoFileDialogFilePicker for files, msoFileDialogFolderPicker for folders. Button click event on form could run code for this. Once the dialog returns the path of the selected file/folder your could would open the workbook, copy the range and paste into the target workbook. I probably wouldn't close the source file until the paste is successful.
If the source file range is edited, your copy would be out of sync so is this the best approach? Can you not just specify the source workbook as a linked data source which then causes the target file to remain current?

Nothing is in stone. right now I'm creating the idea of how it could work. I'm basically converting a work order to a Invoice. The template being the Invoice and the sheet to open and copy from is the work order.

 

[geno32080]

Decided to experiment with the msoFileDialogOpen
Followed this advice.
Add a Userform.
Add a ComboBox to the userform.
Change the Name property to "cboFileName".
Change the DropButtonStyle property to "fmDropButtonStyleEllipsis".
Add a CommandButton to the userform.
Change the Caption property to "Cancel"
Double click on the combobox and add a handler for the "DropButtonClick" event. ( this is a confusing term, the instructions say to use the UNC path, I've tried it both ways,\\folder\file name, and C:\folder\ file name, when I click on the ellipsis, I can't get it to show the path to select a file)

This suppose to allow you to browse for a folder or file location when the ellipsis is pressed.
Any one have any Ideas?

 

[Micron]

Post the code?

 

[geno32080]

Post the code?

Not much coding required, Other than what is above, This is the coding for the userfrom,

Private Sub ComboBox1_Change() "fmDropButtonStyleEllipsis".
C:\LARL EXTREME CLEANING\
End Sub

Private Sub CommandButton1_Click() SELECT ORDER BUTTON

End Sub

Private Sub CommandButton2_Click() CANCLE BUTTON
Me.Hide
End Sub

Private Sub UserForm_Initialize()
HideTitleBar Me
End Sub

 

[Micron]

Sorry, you lost me. I see 2 procedures (the 1st two you posted) that do nothing and 2 that have nothing to do with the file dialog you asked about.

 

[geno32080]

Sorry, you lost me. I see 2 procedures (the 1st two you posted) that do nothing and 2 that have nothing to do with the file dialog you asked about

It is kinda confusing, I could post a couple of screen shots? I uploaded the work book to google drive,

LARL MAIN MENU.xlsm

TO DO CREATE WORK ORDER PAGE,CREATE INVOICE PAGE,WORK ORDER INQUIRY POPULATE WORK ORDER NUMBER,POPULATE INVOICE NUMBER ,CREATE SEARCH FEATURE ADD EMPLOYEE ASSIGNED ,ADD CHECKED BY EMPLOYEE CHANGE TITLE DATE OF SERVICE TO DATE OF WORK ORDER,ADD DATE OF COMPLETED ADD DATE OF SERVICE,ADD SAVE AND...

docs.google.com

Let see if I can get you a copy of the work book.