Results 1 to 4 of 4
  1. #1
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    vba to save a file to icloud

    Good morning all!



    Does anyone have any idea on how to save a file to icloud? Currently I use this to save to a folder on my C drive. But would like to save to my icloud drive. Thank you in advance.
    Code:
    Dim strReportName As String
        Dim strpath As String
        Dim strFilePath As String
        Dim date2 As String
        'Forms!contacts!date2 = Forms!contacts!BidDate
            
        'set variables
        strReportName = "bidreportfromGoBid"
        strpath = "c:\bids\"
        strFilePath = strpath & Forms!gobid!FullName & Forms!gobid!date2 & ".pdf"
        Me.filelocation = strFilePath
         Me.ReportName = strFilePath
        Me.filelocation = "BID" & "#" & strFilePath
        If IsNull(Me.Typeofbid) Then
        Me.Typeofbid = "detailed"
        End If

  2. #2
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    Nevermind - save to icloud drive

    I answered my own question. Duh.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

  4. #4
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Code:
    strReportName = "bidreportfromGoBid"
        strpath = "C:\Users\Topdesk\iCloudDrive"
        strFilePath = strpath & Forms!gobid!FullName & Forms!gobid!date2 & ".pdf"
        Me.filelocation = strFilePath
         Me.ReportName = strFilePath
        Me.filelocation = "BID" & "#" & strFilePath
        If IsNull(Me.Typeofbid) Then
        Me.Typeofbid = "detailed"
        End If

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

Similar Threads

  1. Report to save as Excel file
    By ashu.doc in forum Reports
    Replies: 7
    Last Post: 07-20-2015, 10:18 AM
  2. save report as pdf file
    By linoreale in forum Reports
    Replies: 5
    Last Post: 01-31-2015, 10:47 AM
  3. Export report as RTF but save file name as .doc
    By Ruegen in forum Programming
    Replies: 3
    Last Post: 06-06-2014, 03:16 AM
  4. Replies: 6
    Last Post: 07-23-2013, 11:57 AM
  5. Save imagebox to file?
    By EmSox in forum Forms
    Replies: 0
    Last Post: 07-28-2010, 10:32 AM

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