1. S

    Avoiding Error if User clicks the Cancel Button in BrowseFolder

    Hi I am using BrowseForFolder to Select Folders. The code works fine but everytime I click the "Cancel" Button an Error occurs. Here is the code: Dim objShell Dim strFileName Dim strFilePath Dim objFile Set objShell = CreateObject("Shell.Application") Set objFile = objShell.BrowseForFolder(0...
  2. M

    Selecting a folder and making it your filepath

    Morning all, A little help please. I'm trying to open a folder and copy data from numerous files into the active sheet but have hit a few snags. I've tried to make my file path a cell reference in a sheet with an ActiveX button (where the user pastes the file path for the desired folder) and...

Some videos you may like

This Week's Hot Topics