P.S. Previously, the file attribute didn't show up as Read Only so instead I wrote a stopcheck macro to see if any duplicate files were created, delete them, and notify the user that the file was locked. Way easier that dealing with OAuth, but only as secure as your computer is. Generally, Box can't handle files with macros so by creating a separate document outside of Box that can make these calls you've got yourself a template for updating any excel file you store on Box. This has worked consistently for my team even with heavy traffic both through Box.com and my helper Excel file. At the end of the update macro, I suppress alerts, save the workbook, and close. The updates queued are executed only if the offline copy can save to the Box serversĥ. If Not ((GetAttr(path) And vbReadOnly) = 1) Then Call UpdateMacroĤ. A second macro checks to make sure that the file is in the unlocked state by checking the Read Only property: C:\Users\your_username\Box\main_folder\sub_folder\file_name.xslx)ģ. In this separate workbook, I added a button macro that opens the file I want to change via the Box Drive path In a separate workbook I track the changes that need to be madeĢ. Step 1) Open your VBA editor Under Developer tab from the main menu, click on Visual Basic icon it will open your VBA editor. You just need more tools. Here's how I did it:ġ. Record a macro applying the format you want, and then replay the macro whenever needed. You can apply a single format to all of them using a macro. Imagine you have dates in random formats. While not strictly through Box.com, the end result is the same. VBA in Excel - create a macro Excel 2013 You can automate a repetitive task in Microsoft Excel by recording a macro. In my case, I needed to update product statuses in a shared file on Box.com. Super late to the party, but I was asking this same question and found my own wrap-around way to update an excel file through Box Drive.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |