Excel VBA macro data entry
Budget: $15 – $25 USD
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.
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.