dropbox

Hi everyone, I have excel spreadsheets saved in a shared dropbox folder so that myself and colleagues can access and update. I have entered formulas to pull in information however its looking on my C drive which obviously returns an error when a colleague opens the spreadsheet. Current...

I apologize if this has been addressed and solved. I have been searching the interwebs for hours and while I can find my question many times over, I can't find a solution. My company uses Dropbox and every user has his/her own Dropbox account, although they all point to the same shared folders...

Hello everyone I have a question regarding the path for a file in a dropbox folder in excel VBA: Currently, I use path = "C:\Users\" & Environ("username") & "\PVAP Dropbox\..." I use Environ("username") because it has to work on multiple computers. But is it also possible to make a changeable...

When you install Dropbox, it generates a folder path that incorporates your Windows username. So on my main computer, the path is: C:\Users\peter\Dropbox\files\ but on my secondary computer (different Windows username but access to the SAME dropbox folder), it's: C:\Users\david\Dropbox\files\...

Hi Everyone, I have a problem with dropbox we have a number of users that have access to my dropbox account but i'm getting problems with them opening other documents in dropbox using VBA with my filepath. the code " Environ$("UserProfile")" and the first part "Fold1 = "Dropbox (ALL)" " work...

Hi Guys, I'm currently at college, and on my new course, we have started a module that goes over spreadsheets. As I am very new to using spreadsheets, would it be possible if anyone could give me any guidance on completing this task? I will attach a dropbox link for you to view the question...

Good day everyone! I share an Excel workbook through Dropbox. It's a character sheet for a roleplaying game. It allows users to pick from a plethora of options to create their character, those options then get calculated in a few other pages that the user can then export into PDF. They can...

Hi my name is Sandy. I am trying to create an excel workbook that both my boss and I can access and edit through Dropbox. The file is an invoice with and A/R ledger. As of now I am the only one who can open the file in dropbox. When my boss tries to open the file he receives the following...

Hello and thanks for considering an issue I'm bringing up. First off - this is relevant only to files stored on DropBox or, very likely, other cloud storage platforms. And only due to the files being accessed on different computers. The problem appears to be that Excel typically uses absolute...

Hi All, I have a macro which worked beautifully on my PC to save a workbook to Dropbox. However, when a colleague tried to use it, it didn't work because Dropbox on their PC is not in the usual place. I have looked into obtaining the Dropbox directory from the json file but I don't know how to...

Hello, I have a combobox that is populated from a column(C) in a worksheet. I only want items from that column to show in the dropbox if a value in a corresponding column(F) is greater than zero. is there a way to do this? here is the code that populates the dropbox. Private Sub...

On dropbox there is the possibility of requesting files by creating a link for sending. There is someone who already has experience in sending files with this system automatically with a macro. the link I generated for sending is: https://www.dropbox.com/request/dA4PwiYqMIc9pXRN4vGf...

In my UserForm is a dropbox with multiple names like Emergency, Maintenance, HR, .. and 2 textboxes. Is there a vba code to lookup the dropbox value and paste the 2 textbox values under the dropboxvalue in the sheet. See screenshot https://imgur.com/a/riaakva Thx in advance

I have created a Quote template for employees. I have several guys who regularly do quoting and they work from multiple locations. Currently I rely on them to save the quotes they create to a shared Dropbox folder for me to access. That is not working for multiple reasons, main one being...

First time using dropbox for this. I want to create VLOOKUPs referencing several different files, but the problem is that everything is in Dropbox and I need to download the files to work on them. Is there any way to create the links without having to download all of the files onto my local drive?

I need help creating a dashboard that contains 3 Comboboxs that then cascades through selection down to the resulting machines test results. EX: Bulldozer > John Deere > 750K or Excavator > CAT > D264 My excel workbook is comprised of Multiple sheets for every type of construction machine...

Hi I am having a really strange issue that I can't seem to figure out. I couldn't even figure out how to title this thread very easily. My problem is as follows I work with macro enabled spreadsheets where I have a heap of data in a bunch of separate workbooks. I use another workbook to go...

Good day. I am experiencing some issues with regards to some excel files with external links when shared across Dropbox between different users. The issue is around the username in the path, which differs per user. For example: The path for user1 (Frank) would be as per line 1 below, while...

I am writing a large programme - far too big to post - and, after it runs through two or three reiterations, it starts to put a standard "Go To" Dropbox up. I have no idea what is causing it - there is nothing in my code calling for that to happen. Please can anyone suggest what might be happening?

Hey MrExcel. I have ran into what I consider to be a rather complex problem. I have millions of lines of data that I need to merge into a single sheet, however it is not as easy as simply copying and pasting the columns next to each other as intervals are missing. I should mention that case...