file name folder get

  1. S

    help with existing vb code

    Need help modifying the code below to meet my requirements. Instead of having the InputBox prompt for Vendor No & Vendor Name and then saving to C:/. I would like to code to automatically use the file name I am converting into .CIF and store to a specified folder. Also, need the bottom part...
  2. B

    Extracting same cell range + file name from multiple books

    Hi all, I am writing to ask for help with a macro to help me perform 2 principal tasks across 60 files I have in a folder: Extract cells B6:B8 from each of the 60 files Extract the first part of the file name [the date] - each file is named "DD MM YY Report" (e.g. "01 06 2017 report") and I...
  3. T

    Excel 2010 file open default

    Just upgraded from Excel 2003 to Excel 10. When I try to open an existing file I keep getting a message that the file does not exist. This happens if I enter the file name without the .xls in the file name box. If I include the .xls after the file name in the file name box, the file...
  4. M

    Help with VBA code for "File Save As" and path

    I have an Excel 2003 workbook that, once the user is finished with, prompts the user to save the updated workbook. I used the Application.Dialogs(xlDialogSaveAs).Show command to prompt the user for the file name, however, I want the "default" save to folder to be the one in which the current...
  5. P

    Handling multiple files in macro

    Hi to all experts, I have a problem to be solved that is probably easy for an expert. I can make a simple macro – in most cases based on a recorded macro. For this is typical VBA programmers knowledge required. Description of my problem: I have a workbook (database) with the following contents...
  6. E

    Get file names from a folder

    I am trying to get all the file names out of a folder and paste them into cells A1 to A# , how can I do this?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top