dropbox

I have just installed the Dropbox add-in for Office 2016 (365). This add-in allows the user to see the Dropbox icon/ folder in the browse (left-hand) menu of the File -> Save option from any Office application. We have a BeforeSave event firing on an Excel application. However, if the user...

Can any of you clever people out there help me please? I have reached the end of my tether... I have this code to try and save a workbook as an XLS file to folder in Dropbox using text from the worksheet as a filename. I had it running beautifully on Macs but we are now moving over to PCs and...

Hello, I've inherited a leave calendar and am having trouble figuring out how it functions. Am I able to link it here via dropbox and have someone have a look at it? Regards Tom

Within our company we use a number of Excel workbooks that link to other Excel workbooks with VLOOKUP. We use Dropbox and have run into issues when opening the same file on different computers - the files being linked to the file return with "#VALUE!" in each cell. With all of the services we...

Need to update a file with a link to a spreadsheet on Dropbox. Throws into debug mode every time. Any solutions out there?

Hello First 'Seasons Greetings' to all you users. I have a spreadsheet with the root path for over 1,000 documents that get sent out via a mail merge. The problem is that although this system works perfectly well, if the document contains errors that recipient will always have a hard copy of...

I found the Mac filepath with the "Go To Folder" application and confirmed it through "Terminal" /Users/ant/Dropbox/1100-Timesheet/1100-03-160216-Database.xlsm I have tried adding .xlsm or not. I have tried using : and / as separators I tried adding Macintosh HD to the beginning of the...

Has anyone found a way for VBA to copy the share link of a Dropbox folder? Many file explorers (such as XYplorer, which I use), have a context menu option to "Copy Dropbox Link" on my Dropbox files. This also works with OneDrive. I assume XYPlorer and its ilk are using the cloud service's API to...

Many of my excel projects are stored in a Dropbox folder through the Dropbox desktop app on PC, windows 7 and 8.1, Excel 2013, 2016. Dropbox recently updated to include Dropbox Badge when excel files from a Dropbox folder are open in excel. When Dropbox Badge was implemented I started getting a...

Hi all, I am trying to set up a financial accounting system that involves linking a central spreadsheet to various source spreadsheets (salaries, receipts) in different Dropbox folders. This is simple enough when working from my own computer, but the system needs to be accessible and editable...

Hi, I have some files saved in a Dropbox folder that is shared between two people. I want to set up an excel file on the dropbox to open another excel file when I open the first one. But how to I do this using a macro? Below is the macro I use currently, but the problem is the user name in...

Hi, people of excel;) Straight to the case: I want to make a drop-down list where the alternatives is the updated filenames in a dropbox folder. It is important that the references is either relative (the excel-document is also on dropbox) or to the dropbox web page, so that it will work...

Dear All, I am using an input box to get the user input. With the user input, I am setting autofilter criteria. Here is the code: Dim SelSeg As String ActiveWorkbook.Sheets("Jan 2015").Activate Range("a1").Select SelSeg = InputBox("Please enter name of segments for which you are...

Until recently (late Jan 2015) I was able to SUCCESSFULLY use a VBA macro with the principal command "ThisWorkbook.SaveCopyAs" to save to one of my Dropbox folders a separate date & time stamped backup copy of my Personal.xlsb file which is located on my employer's LAN. (The filename of the...

I apologize if this is covered elsewhere. I searched, but could not find a good solution. Our company uses DropBox to sync and share folders between employees. We store Excel workbooks in these folders. We are having issues when using formulas in one workbook that link to data in another...

Hello everyone. I'm new to this forum - any help would be greatly appreciated! I have a file that I use for work that several people share. The macro that I wrote opens a file from a location in Dropbox. For those of us using Windows, I just made sure everyone's Dropbox location is...

Hello! I am trying to do a simple database for a small, but very busy, company. I have decided to make it in Access after a lot of reading... there's a huge debate out there in the web related to Access and SQL and I would like to avoid any discussion in this post if possible. We currently...

I have a dropdown in which a state can be selected. A second dropdown then retrieves and displays a list of the counties in that particular state that the user can choose from. The available county list is retrieved using an array formula: {=IFERROR(INDEX(RatingTables!$MF$8:$MF$3195...

Dropbox help didn't help. Just joined board. Searched archive and didn't find answer. I'm creating a spreadsheet index and I would like to hyperlink cells in an Excel spreadsheet to open and view documents stored on Dropbox. I can do a hyperlink that permits download of the document, but I...

I'm using Windows 7 and Excel 2007. When opening an Excel file that was previously shared with Dropbox (but which is now saved on my hard drive) I get a series of HTTP/1.0 404 error messages. Each message indicates that Excel is unable to open a file in my Dropbox folder. None of the files are...