Hello Team,
Looking for VBA support to complete the one automation. I have one shared drive (web-based) folder and every day there will be one file will be saved in this drive. I need to move this file to an input folder (define the path) and after moving the file that file data should post only *A1" values to another sheet of the same.
Example as below:
Source folder = C:\Test\File1.xlsx
Input Folder = C:\Test\File1.xlsx
Completed Folder = C:\Test\File1.xlsx
Now source File1.xlsx has a few columns "D" to "K" and this file should move from Source to the input folder. Later this input folder file data only Column "A" data should be copied to the same file in the second sheet and moved to the completed folder.
Is this something that can be achieved via VBA please note this should work in ShareDrive (web-based).
Thank you,
Looking for VBA support to complete the one automation. I have one shared drive (web-based) folder and every day there will be one file will be saved in this drive. I need to move this file to an input folder (define the path) and after moving the file that file data should post only *A1" values to another sheet of the same.
Example as below:
Source folder = C:\Test\File1.xlsx
Input Folder = C:\Test\File1.xlsx
Completed Folder = C:\Test\File1.xlsx
Now source File1.xlsx has a few columns "D" to "K" and this file should move from Source to the input folder. Later this input folder file data only Column "A" data should be copied to the same file in the second sheet and moved to the completed folder.
Is this something that can be achieved via VBA please note this should work in ShareDrive (web-based).
Thank you,
