MAX VBA Code
Budget: $30 – $250 AUD
Hi
I need some VBA code to return a maximum value from a column in a closed Excel workbook. The source file name and path is in a named cell "Data_FilePath" in the application workbook and the value would be returned to another named range in the application workbook. The full file path cannot be hard coded into the VBA as the file names and paths change for different entities/departments. I have been using the the MAX function in the destination cell but this does not now suit as the names/paths change.
We use Office 365 and the Excel version is 64 Bit. All source files are stored in DropBox folders
I have attached a sample source file spreadsheet
Regards
Mark Dindas
I need some VBA code to return a maximum value from a column in a closed Excel workbook. The source file name and path is in a named cell "Data_FilePath" in the application workbook and the value would be returned to another named range in the application workbook. The full file path cannot be hard coded into the VBA as the file names and paths change for different entities/departments. I have been using the the MAX function in the destination cell but this does not now suit as the names/paths change.
We use Office 365 and the Excel version is 64 Bit. All source files are stored in DropBox folders
I have attached a sample source file spreadsheet
Regards
Mark Dindas