Hello all,
I need help with this build
.
Basically I want to be able to create a path within the code to search this folder for excel files with Xlsx/Xlsm/Xls, open, save as, same name, but new extension. In this case I am converting older files to Xlsb in order to save space.
There are three main environments I will need to do this in
As always any suggestions would be greatly appreciated. Thank you in advance.
Regards,
Hollando
I need help with this build

Basically I want to be able to create a path within the code to search this folder for excel files with Xlsx/Xlsm/Xls, open, save as, same name, but new extension. In this case I am converting older files to Xlsb in order to save space.
There are three main environments I will need to do this in
- A Users Desktop
- A Users Documents
- Sharedrive Folder
As always any suggestions would be greatly appreciated. Thank you in advance.
Regards,
Hollando