Hi
I tried transferring data to a new workbook using code from Here
I got an error with the line below. The file is there because it passed If Fname = "" Then Exit Sub
Says Run time error 1004 Sorry we couldn't find test.xlsx. Is it possible it was moved renamed or deleted
If it did work, Can this be made quicker or more efficient by
* checking if open or exists
* transfer data to closed workbook last row
* Copy back updated data to thisworkbook.
Not sure of quickest/best way to do this
Either by copy data to closed workbook and copy back the updated data or
Transfer data Copy and then Data > Get Data from File Workbook using vba
I tried transferring data to a new workbook using code from Here
I got an error with the line below. The file is there because it passed If Fname = "" Then Exit Sub
VBA Code:
With Workbooks.Open(Fname, UpdateLinks:=0)
Says Run time error 1004 Sorry we couldn't find test.xlsx. Is it possible it was moved renamed or deleted
If it did work, Can this be made quicker or more efficient by
* checking if open or exists
* transfer data to closed workbook last row
* Copy back updated data to thisworkbook.
Not sure of quickest/best way to do this
Either by copy data to closed workbook and copy back the updated data or
Transfer data Copy and then Data > Get Data from File Workbook using vba
Last edited by a moderator: