frompath

  1. J

    VBA to Change SourceData Based on Cell Value - Invalid Procedure Call or Argument

    Hi, I'm having the Debug error:Invalid Procedure Call or Argument for the following code. I'm trying to change the source (excel file saved on a public drive) of pivot table. In the "CONTROLS" tab I have in B3 the path and range of the source. The Debug error happens at the point where I try to...
  2. H

    Copy and Move files and folders

    I found this solution elsewhere on Mr. Excel to (hopefully) tackle a project I was wanting to take on. I found this Ron de Bruin automation macro and I want to copy files from a mound of floppy discs to a location on my PC. The problem I am encountering with the code is that if I want to copy...
  3. V

    File Path from cell value

    Hello All I am trying to modify this piece of code to point to a cell value for the file path instead of hard coding the path which I would have to change for different users. Sub Merger() Dim bookList As Workbook Dim mergeObj As Object, dirObj As Object, filesObj As Object, everyObj As...
  4. J

    Create new folder

    Hi guys, I'm pulling my hair out as to why the following isn't working. Basically, I am looking to move CSV files from one folder to a another one which will be create if doesn't exist. However, when the below is run FSO.CreateFolder (ToPath) gives me an Error 76 - PATH NOT FOUND, rather...
  5. E

    Copying Last month's files to a different location

    Hi I am trying to build a macro that will move last month's files to a different location. files names are BDP_171002.CSV to BDP_171031.CSV. These files are generated based on weekdays. I want to move files based on last month file names NOT date modified. what do i need to adjust on my...

Some videos you may like

This Week's Hot Topics

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