Home

Can Excel 365 script to run local cmd/batch files and update spreadsheet data w/Dropbox file link?

%3CLINGO-SUB%20id%3D%22lingo-sub-1059584%22%20slang%3D%22en-US%22%3ECan%20Excel%20365%20script%20to%20run%20local%20cmd%2Fbatch%20files%20and%20update%20spreadsheet%20data%20w%2FDropbox%20file%20link%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1059584%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi!%20I'm%20considering%20purchasing%20an%20Office%20365%20subscription%2C%20but%20before%20doing%20so%20want%20to%20make%20sure%20it%20will%20meet%20my%20needs.%20I'm%20hoping%20you%20can%20help%20guide%20me%20to%20know%20if%20it%20will%20meet%20my%20needs.%26nbsp%3B%20I%20currently%20own%20Office%202007.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EMy%20need%20is%20to%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E-%20have%20a%20shared%20spreadsheet%20three%20local%20users%20on%20my%20LAN%20can%20edit%20simultaneously%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E-%20be%20able%20to%20run%20a%20script%20in%20that%20spreadsheet%20that%20loops%20through%20rows%20repeatedly.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EFor%20each%20row%2C%20scans%20the%20local%20file%20system%20for%20a%20file%20matching%20that%20row.%20When%20there's%20a%20match%2C%20it%20needs%20to%3A%3C%2FSPAN%3E%3C%2FP%3E%3COL%3E%3CLI%3E%3CSPAN%3Ecopy%20the%20local%20file%20to%20another%20local%20location%20(Dropbox%20sync%20will%20upload%20to%20Dropbox%20from%20here)%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ERun%20an%20O%2FS%20command%20(ffmpeg%2C%20to%20create%20another%20version%20of%20the%20file)%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ERun%20code%20to%20find%20a%20same-named%20file%20in%20an%20online%20Dropbox%20folder%2C%20create%20or%20fetch%20it's%20shared%20link%2C%20and%20update%20that%20link%20into%20a%20column%20in%20that%20spreadsheet%20row%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ESend%20an%20e-mail%20with%20that%20link%20to%20a%20user%20specified%20in%20that%20spreadsheet%20row%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%3EI'm%20concerned%20that%20the%20new%20Office%20might%20only%20work%20with%20online%20files%20and%20may%20not%20work%20for%20my%20need%2C%20being%20able%20to%20access%20local%20files%20and%20such%2C%20while%20allowing%20the%20shared%20file%20capabilities.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ELooking%20forward%20to%20any%20guidance%20you%20can%20offer!%26nbsp%3B%20Can%20Excel%20365%20do%20this%3F%26nbsp%3B%20Do%20I%20need%20to%20somehow%20make%20Excel%202007%20work%3F%26nbsp%3B%20%26nbsp%3BIf%20using%20Excel%20365%2C%20perhaps%20I%20have%20the%20local%20looping%20CMD%20file%20scanning%20for%20new%20local%20files%20and%20doing%20the%20copying%20stuff%2C%20Dropbox%20Sync%20take%20care%20of%20the%20upload%2C%20and%20then%20use%20Excel%20365%20in%20the%20cloud%20to%20take%20care%20of%20the%20Dropbox%20link%20sync%20and%20e-mailing%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you%20again%20for%20any%20steering%20and%2For%20sample%20code%20you%20could%20point%20me%20to!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3A)%3C%2Fimg%3E%20Rob%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1059584%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Red-Rob
Occasional Visitor

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:

  1. copy the local file to another local location (Dropbox sync will upload to Dropbox from here)
  2. Run an O/S command (ffmpeg, to create another version of the file)
  3. Run code to find a same-named file in an online Dropbox folder, create or fetch it's shared link, and update that link into a column in that spreadsheet row
  4. Send an e-mail with that link to a user specified in that spreadsheet row

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

Related Conversations
Convert string to number of days
arjsharm in Excel on
0 Replies
Header
MaryUMF in Excel on
1 Replies
Formula help?
JennivL in Excel on
1 Replies