onedrive

Hi all We have a shared Excel file in a Teams channel. Everyone has the channel set as a Onedrive shortcut too, so it creates a daily backup of itself on the first opening each day using a Workbook_Open script. This script also sets a temporary view so people don't mess up what each other is...

This is really messed up. Please help me with a workaround that works. I'm completely disabled. I have a workbook called Journal.xlsm and another workbook named TokenHandling.xlsm. TokenHandling.xlsm is stored on my OneDrive but I access it via my local OneDrive folder on my harddrive...

Hello again. I have searched this forum and cant find help on my topic. I have a file on a users desktop that will contain a number of pdf files. These files will save to specific folders on Teams ( i have those pathways and have done it with .xlsx and .xlsm files before.) The files have a...

Hello and thanks for reading! I have a spreadsheet that is saved on multiple users desktop. The issue is i don't (and won't) know who the users are. On the sheet there is a command button that will save it to a folder also on their desktop. This folder ("Finished Work") will have the same...

Our company uses Onedrive for our team file distribution. All work is done locally and then files are synced up when wifi is available. I have a few macros built in to our files to ready them for client distribution. The problem is sometimes the files get overwritten after the macros run and we...

I want to connect a file from OneDrive as a data source in Power Query. I understand that the best way to do this, is to copy the OneDrive file path and then paste the link into New Source>Other Sources>Web (see reference pictures below). However, I do not see the same "Copy File Path" icon...

Hello, I've got an issue with FIleCopy command in VBA. I always used this when i wanted to copy/paste some file from one folder to another. (but it was local or based on the server). Unfortunately at that moment i have to wokr with onedrive solution. I need to build some file (or rather wanna...

Hello, I am trying to create a column where there is a drop down list in each cell and have the ability to select multiple options. I know how to get the drop down list with data validation and I found this page that allows me to successfully select multiple (without repetition) with a VBA...

Hi, I am trying to import data from onedrive excel file to excel desktop through power query. (using add-in on Excel 2010). 1. If i copy below links in power query>import from web, import selection space is not showing sheets in the file 2. If i select to open file in desktop app, it is asking...

Good afternoon, I want to activate an Excel file that resides on OneDrive. This code opens the file. Sub Copy_Data_From_Excel_File_On_OneDrive() Set objLogExcel = CreateObject("Excel.Application") objLogExcel.Visible = True Set wkbStockTransTable = objLogExcel.Workbooks.Open _...

Hi everybody, I am Paul, and I recently joined that forum. I would like to share to other computers an excel file which contains formulas to fetch live quotes from Bloomberg. My idea was actually to push to OneDrive or Sharepoint a copy containing only values and being updated with a Macro...

Good morning everybody, I am trying to set up a document that is shared by 3 users. I need the document to be present on all 3 user's OneDrives so that when we make a change to our individual version, all 3 versions will reflect the changes. Is this possible? If not, does an idea as to how this...

Hi there, When trying to run a sql update statement (on a sheet) that works fine locally, I get 'Cannot update. Database or object is read-only' when I move it on to OneDrive. My assumption is that it's because of co-authoring. My connection string is...

I've searched everywhere and I've tried using the tips I've come across, however I still run into isses using Thisworkbook.path. This code works fine if I use $Environ(username), and put the path, but I'm not sure the other ones in my office has the onedrive folder saved in the same location. It...

Hello I have an Excel spreadsheet saved on my One Drive for Business called "MasterXXX.xlsm" which I am trying to run the VBA script below, however I am getting the run time error "Error 52 Bad File Name". When I try it in my own local drive, I can run it perfectly. I have already looked at...

Hi, Struggling with VBA .SaveAs from Desktop (365) to Sharepoint. It's failing intermittently with an "Error 1004 Document not saved." I've check the paths and they exist and receive the files when it works. I've found other documentation on this subject concerning Onedrive and Sharepoint but...

I have updated the source many times and I have also tried using the links but it is not working. Any ideas how I can overcome this error and make the Query work? The Pivot and the Data are on same file and stored on OneDrive? Best regards, SK

When I use ThisWorkbook.path I get back a URL (https://...) instead of a file path (C:\...). How do I use VBA to get the local file path? For context, the workbook I'm using is saved in my OneDrive folder.

OneDrive offers to backup files to the cloud, but it does something I thought was way too heavy handed, it moves the path for all the items in "My Documents" to \OneDrive\"Documents\" while still leaving the (now empty) My Documents folder behind. Of course the path is obscured in File...

Hi, Please I am new to VBA. I have two worksheets. One on my laptop (and workmates. clones) and the other on office 365 Onedrive. when my colleagues fill their respective workbooks each on their systems and click a submit button, the data in the selected range is pasted in the Onedrive...