Results 1 to 2 of 2
  1. #1
    Jrw76 is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2013
    Posts
    38

    Opening an existing xls file.

    I currently have this code:

    Private Sub Command21_Click()
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
    "GRAPHING", "C:\Users\Me\Desktop\GRAPHING.XLS", True
    End Sub

    On this same button after this function, I want to open this file. I know, seems redundant, but I have this exporting so I can see a chart and access isn't letting me create one. I'm just opening to see the chart.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    If you don't want to open the file as an object that can be manipulated with VBA, try FollowHyperlink:
    Application.FollowHyperlink "C:\Users\Me\Desktop\GRAPHING.XLS"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. how export and replace existing file
    By sk88 in forum Access
    Replies: 6
    Last Post: 10-01-2012, 12:55 PM
  2. Knowing file version without opening
    By elamaranr in forum Access
    Replies: 1
    Last Post: 07-29-2011, 08:02 AM
  3. opening an excell file from out of access
    By FSCHAMP in forum Access
    Replies: 1
    Last Post: 01-05-2011, 10:17 AM
  4. problem opening .mdb file
    By honeybee in forum Access
    Replies: 7
    Last Post: 06-25-2010, 11:33 AM
  5. Value List with opening a file.
    By seaper in forum Forms
    Replies: 0
    Last Post: 10-21-2009, 01:32 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