filedialog

  1. L

    Opening files and editing them

    Hey guys, I ran into a small problem that I can't figure out. The code lets a user choose a location, once chosen it goes through all the files in the folder and makes a txt named the same as the file. Sub GetFileNames() Dim sFolder As String Dim MyFSO As FileSystemObject Dim...
  2. Jaafar Tribak

    FileDialog InitialView Property doesn't work !

    Hi dear forum members, Sub Test() Dim oDlg As FileDialog Set oDlg = Application.FileDialog(msoFileDialogOpen) With oDlg .Title = "Select a file" .InitialFileName = "C:\MyPictures" .AllowMultiSelect = False .InitialView =...
  3. S

    Use FileDialog to copy a file address

    Morning All I am trying different methods of getting links to files into a Listbox. One method is to paste the file address into a Textbox and then transfer that over to the Listbox as a hyperlink (posted on this forum). The next method I want to explore, which I think may be a little cleaner...
  4. A

    Loops of file, filter, save

    hello all! i'm trying to learn to code and have worked through some old broken code for years trying to help my department function. i'm now trying to rebuild the code and am in need of some assistance in building this code. i have a list of people, with a datasheet needed for each. i have the...
  5. A

    How to browse a file txt and import all the info to a excel workbook

    Hi good day! I need help please, I need a macro to be able to select a ".txt" file (using the windows browser) and import all the information on that txt to a new workbook. Then save that new workbook as "BOMNAV" on a file that I choose Here is what I have so far but Im stuck.... Sub CopyData()...
  6. P

    Need help please

    Hi all thanks for taking a look and any help provided. The object of this sub is to mailmerge to a word documeny depending on a listbox selection. the sub works fine upto a certain point but having trouble completing it fully with added functions. the sub runs to the end as it stands with the...
  7. C

    File Dialog Excel 2013 Error

    Hi, I have the below code that is working for most of my users but is crashing in the red line for some of the users. The only common trend I've found for those that this is not working is that they are Excel 2013 users as everyone else is Excel 2010. The Excel 2013 users have a run-time error...
  8. D

    User input FileDialog to path for source files in VBA

    Greetings, **What code does:** I have a code that reads the files in a folder, prints the names in the active workbook, and then puts the names in ascending order. **Obs1:** I have follow up codes that use this information for calculations, but this part is not relevant to the current...
  9. A

    VBA Import, Merge & Modify files

    Hello, I have the following code which lets me pick multiple files from a specific folder and then merges all of them together. The code works great, except I ran into the issue where some files had a blank Column A and since the code is trying to find the last used row before pasting the new...
  10. M

    FileDialog.InitialView Property

    Does anyone else share my frustration with the following? Or better still has found a solution? I am using Office 2016 on a Windows 10 64 bit OS. I cannot get the FileDialog.InitialView Property to take effect - i.e. no matter which of the msoFileDialogView constants I use it is not applied in...
  11. A

    Dereference in Application.FileDialog

    I'm trying to have a FileDialog select a shortcut (*.lnk) file, and not the destination file in VBA. E.g. 'C:\MyShortcut.lnk' is a shortcut to 'C:\SomeFolder\BurriedDeep\MyFile.xls' and I want to select the shortcut and update it to 'C:\SomeFolder\BurriedDeep\MyNewFile.xls' MSDN link about...
  12. D

    VBA - Open files automatically in order sorted in folder

    I have a macro that modifies an Excel file and pastes ranges into PowerPoint. However, it opens each file based on windows numbering system: 1 11.1 111.2 2 22.1 I need it to open the files in the order it is sorted in the folder as: 1 2 11.1 22.1 111.2 This is the opening code I would like to...
  13. CsJHUN

    Optimalization

    Hi guys! I wrote this, and got some useful info from here(i guess :) ) now I would like to ask you to give me any optimalization ideas (shortening the code, or runtime) The task for this macro are: let user select files via "Open" window open/close each file copy and paste selected datas below...
  14. S

    Get Collection of Files in Folder

    Hello, I'm working on a project that requires me working with files and directories. I haven't had any issues yet with setting up user forms, letting users set file paths to folders or even selecting and importing files, etc... but I'm not sure how to grab all the files in a particular folder...
  15. M

    putting the path from FileDialog into a text box

    So, what I want to do is, allow the user to browse the hard drive, pick a file, and then have the path to that file appear in a text box. I found a popular solution that does something similar: it allows the user to choose multiple files, and it puts the paths for those files in a listbox. But...
  16. U

    Semi colon as csv separator

    Hi all, I have a macro where i'm trying to convert an excel file to csv with semi-colon separator. I thought the method was to convert to csv, and secondly to replace coma by semi-colon but it's not working. It seems we can force the separator somehow, but I don't know how to do it inside my...
  17. 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...
  18. S

    Special requirements for Save As File dialog box

    Hello, I want to open Save As File dialog box in Excel. I need it to have these features: 1) ability to add filters (msoFileDialogSaveAs does not support it) 2) ability to change Save As button text 3) Unicode support I was able to get all my mentioned functionality with...
  19. bigturnip

    FileDialog Question

    When using the file picker or open dialog via the FileDialog property you can select multiple files to open, is it possible to restrict users to only selecting one file?

Some videos you may like

This Week's Hot Topics

Top