Dec 10 2019
10:45 PM
- last edited on
Feb 01 2023
12:45 PM
by
TechCommunityAP
Dec 10 2019
10:45 PM
- last edited on
Feb 01 2023
12:45 PM
by
TechCommunityAP
Hi! I'm considering purchasing an Office 365 subscription, but before doing so want to make sure it will meet my needs. I'm hoping you can help guide me to know if it will meet my needs. I currently own Office 2007.
My need is to:
- have a shared spreadsheet three local users on my LAN can edit simultaneously
- be able to run a script in that spreadsheet that loops through rows repeatedly.
For each row, scans the local file system for a file matching that row. When there's a match, it needs to:
I'm concerned that the new Office might only work with online files and may not work for my need, being able to access local files and such, while allowing the shared file capabilities.
Looking forward to any guidance you can offer! Can Excel 365 do this? Do I need to somehow make Excel 2007 work? If using Excel 365, perhaps I have the local looping CMD file scanning for new local files and doing the copying stuff, Dropbox Sync take care of the upload, and then use Excel 365 in the cloud to take care of the Dropbox link sync and e-mailing?
Thank you again for any steering and/or sample code you could point me to!
:) Rob