windows explorer

  1. K

    Copy a Folder Template and Create Multiple Folders Based on an Excel Spreadsheet

    Hello, I created a folder template which has several sub-folders. I want to copy this template and create new folders with names from an excel spreadsheet. The path for this template is: C:\Users\woodenk\Documents\Employee Personnel Files\_Folder Template. I also placed the spreadsheet...
  2. S

    use vba to put address from open win explorer instance into the clipboard

    I am working on Windows 7 and Office 2013. I have an open instance of windows explorer that has been navigated to a folder. From excel vba I would like to load that win explorer address into the clipboard. I do not have a clue how to do this. Can anyone assist me?
  3. E

    Create list of files from windows explorer folder

    Hello all! I am new at VBA, so any help is much appreciated. Here is a summary of what I'd like the end result of this project to be: When I open Workbook A, Macro #1 automatically runs as the file is opening. This macro will analyze the contents of the "Seed Folder" (through Windows...
  4. N

    Open files from active explorer

    Hello, Is there any way to open selected excel files from windows explorer with VBA code? Suppose that I have file1.xls, file2.xls and file3.xls in a folder c:\files but I just want to open file1 and file3 (those files that I have selected). Can I do that with VBA? Thank you.
  5. L33

    Run macro from the Windows right-click "Send To"

    Hi, I have a file with a number of macros for data editing, formatting etc to create large Excel report. The first stage of this is always to pick a flat Excel data file to feed in to it from a simple file open dialog. I would like to right-click on that data file in Windows Explorer and from...
  6. G

    Importing file names from Windows Explorer

    How would I go about doing a group import of a list of file names from Windows Explorer into a column on an Excel spreadsheet? For example, one of the folders on my PC contains a list of 22 files. If I want to make an accurate copy of the file name, I must right click it, select Rename...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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