Results 1 to 3 of 3
  1. #1
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,367

    Update excel file on one drive

    Hi all, i currently update an excel spreadsheet on a local network drive ie: T:\Main Folder\Excel Files\ & "daily update.xlsx"



    I am going to need to update a file on one drive, is it as easy as changing the path from T:\Main Folder\ etc to www.onedrive\file\ etc etc ?

    Thanks

  2. #2
    redbull's Avatar
    redbull is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    You are going to need to have your onedrive directory mapped inside of file explorer. I'm not familiar if it does this natively... it might show up as a network location, try going to the file's location and right click on the file and select properties... what is the file location it provides?

  3. #3
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,367
    Hi redbull, thnk you for your reply, im not able to try as yet as customer hasnt given me a link but doing homework!!

    how do you mean one directory drive mapped inside of file explorer ? what is the method ?

    my initial though was once i get the link to the file, fid it's path and replace my current path from onsite file to one drive address...

    many thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-24-2016, 04:54 PM
  2. need code to copy one file from C drive to E drive
    By ChuckRS in forum Programming
    Replies: 5
    Last Post: 02-23-2015, 07:27 AM
  3. VBA to update Products Table from excel file
    By Mclaren in forum Programming
    Replies: 2
    Last Post: 07-26-2012, 12:14 AM
  4. Replies: 10
    Last Post: 03-04-2012, 12:17 AM
  5. Output tables to an excel file on a network drive
    By GraemeG in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2011, 03:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums