one drive

I had a number of workbooks that other co-workers use. I have have vba code: Workbooks.Open filename:=(Environ(“userprofile”) & how do I convert that to work with One drive? Unfortunately my dept. received no warning on this update from our higher ups so it’s reeking havoc with running van...

Hi, I was thinking about being slightly more productive and having an excel document on my desktop at work pull data from multiple Teams spreadsheets as a link, these spreadsheets are natively uploaded in Teams, so link may be variable on each upload, unfortunately. In the case it's variable...

Hi! I have a problem with Save As dialog. I wrote a code that saves excel file with predefined name and path on Desktop, which works fine. When I change Path in code to One drive folder, Save As opens in that path but, name is not defined. Dim Path As String Dim filename As String Path =...

My question is: I use VLOOKUP all the time in Excel and am very good at it. I am being forced to start using Excel on-line with OneDrive and, major issues. I can’t figure out how to reference the Table_Array. I have two spreadsheets, Book1 [where the formula will go] and Book2 [where the...

Hello! I need to open a onedrive file command in VBA upon opening another file so auto Linked data will update!!! Does anyone know that open file command in VBA??? :confused::confused::confused: Thanks 2 ALL!!!

Hello Excelers! I have 3 excel files linked together on my onedrive! How would I update these Links without opening the other data host files??? If this isn't possible, how would open these other files auto. upon opening my master file??? Please HELP!!! Thanks 4 any help...