frompath

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...

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...

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...

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...

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...