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

    Return Data From Excel Online Sheet

    Hi Guy's, i have a text box (txtXLRow) on the db, when i click on a record, this corresponds with the xl Row from an online sheet



    What i am trying to so is return the Data in Column H / txtXLRow

    https://onedrive.live.com/view.aspx?resid= etc etc (removed login)

    firstly when i Set xlWB = "http://onedrive etc etc", i get compile error type mismatch

    1: Can the online one drive sheet be set as XLWB ?
    2: Can i return the value in Column H / Row Me.txtXLRow

    If anyone can give me an example would be great

    Thank you

  2. #2
    hci_jon is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Location
    Montgomery, IL
    Posts
    9
    Code:
    Sub open_excel_from_one_drive()
    
    sfilename = "https://1drv.ms/x/s..."
    Set xl = CreateObject("Excel.Sheet")
    Set xlsheet = xl.Application.Workbooks.Open(Filename:=sfilename, ReadOnly:=True)
    
    End sub

    Try using the above routine, but I think you will need to "Share" the file from one drive and use the link generated. It might work from other links though.
    Last edited by hci_jon; 05-28-2020 at 02:07 PM. Reason: messed up code tag

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

Similar Threads

  1. Excel Sheet data import into Access
    By joesephb in forum Import/Export Data
    Replies: 5
    Last Post: 04-09-2018, 02:09 PM
  2. Replies: 5
    Last Post: 04-25-2017, 01:38 AM
  3. Cant Export data to specific excel sheet by ADODB
    By rangga_osh in forum Import/Export Data
    Replies: 4
    Last Post: 03-14-2013, 04:20 AM
  4. Import excel sheet data into Ms-access using VBA macros
    By gokul1242 in forum Import/Export Data
    Replies: 2
    Last Post: 10-02-2012, 04:39 AM
  5. Replies: 4
    Last Post: 10-07-2010, 04:45 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