msofiledialogfilepicker

  1. G

    Find header row on the sheet and copy it

    Hello, I need your help, actually i'm using this code to copy data (essentially data on table format vite headers and line of data). Sub Extract() ' Wrkb_Org for the file which is gonna be copied using msoFileDialogueFilePicker the base file ' Wrkb_Trs for the "Template.xlsm" file in...
  2. G

    Extract data without openning (msoFileDialogFilePicker) the file on the workbook only if it's an Excel type file

    Hello, I need your, help actually i'm using this code to allow the user to extract data from a unopened excel file, The macro will open a window to allow the user to select the file that he wants to copy data on the actual workbook : Sub Extract() Dim Wrkb_Org As Workbook 'Variable to link...
  3. G

    Export data from a unopen file CSV using msoFileDialogFilePicker but data are not correctly placed

    Hello, I use this code to export a data from the sheet_1 from a unopen file to the actual workbook by using a macro This is the code : Public Sub Export() Dim Wrkb_1 As Workbook Dim Wrkb_2 As Workbook Dim Way As String With Application.FileDialog(msoFileDialogFilePicker)...
  4. G

    How to take data from the a unopen workbook first sheet without specifying the actual name (because it change every week)

    Hello, For a project I actually use a macro to export data from one unopen workbook sheet to the actual xlsm workbook sheet. I recently found a problem on the export sheet, this sheet has to be updated every single week but probel the change the name of the sheet changes every week. But on my...
  5. A

    msoFileDialogFilePicker Throws Error: object variable with block variable not set

    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...
  6. R

    fileDialog.show does not show a window

    I am trying to choose a file to open later. This piece of my code used to work until a few days ago and is supposed to show the file dialog box. What happens now is that the dialog box does not show and returns 0 (cancel). I have MS Office Pro Plus 2010 Excel version 14.07 Sub...
  7. T

    What to use instead of FileDialog in 2000?

    I have a model that I run off of Excel 2003; however, I have about 25% of the users with 2000. I used the following code that works in 2003, but didn't realize the FileDialog doesn't work in Excel 2000 (get the variable not defined error). Are there any quick ways to fix this code so it will...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top