User Sahil
New Member
- Joined
- Nov 26, 2013
- Messages
- 1
I am facing a great trouble for applying the same change to all the excel files on my google drive.
The case goes like this:
I have folder "Amritsar" on my PC Desktop with 700 Excel (.xlsx) files inside it.
I have uploaded folder name "Amritsar"" on the Google Drive with conversion on.
Now, I have this folder containing 700 Excel files online on Google Drive.
All these files are in identical format but file names are different.
Now I want to apply a single change to all the sheets of my all my files.
The change is that I want to insert formula at cell B501, =COUNTA(B7:B500)
I am not sure whether vb marcos will work on the google drive or not, as the google drive is likely to be managed by script.
Kindly help me with script that I may use to apply the same change to all the 700 files without opening them one by one.
Any help would be appreciated!
Thanks!
The case goes like this:
I have folder "Amritsar" on my PC Desktop with 700 Excel (.xlsx) files inside it.
I have uploaded folder name "Amritsar"" on the Google Drive with conversion on.
Now, I have this folder containing 700 Excel files online on Google Drive.
All these files are in identical format but file names are different.
Now I want to apply a single change to all the sheets of my all my files.
The change is that I want to insert formula at cell B501, =COUNTA(B7:B500)
I am not sure whether vb marcos will work on the google drive or not, as the google drive is likely to be managed by script.
Kindly help me with script that I may use to apply the same change to all the 700 files without opening them one by one.
Any help would be appreciated!
Thanks!