thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 954
- Office Version
- 365
- Platform
- Windows
Hi all,
I need to download a few hundred excel files from a cloud-based database that when downloading, gives the workbook name a random number/name. If I open the workbook, the correct file name is located in cell A1. Is there anyway to auto rename each workbook to the value in cell A1, so that I do not have to manually rename each one and I can just spend my time downloading each file from the cloud?
Many thanks in advance!
/m
I need to download a few hundred excel files from a cloud-based database that when downloading, gives the workbook name a random number/name. If I open the workbook, the correct file name is located in cell A1. Is there anyway to auto rename each workbook to the value in cell A1, so that I do not have to manually rename each one and I can just spend my time downloading each file from the cloud?
Many thanks in advance!
/m