Results 1 to 2 of 2
  1. 01-22-2013, 03:25 PM #1
    togo
    togo is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    83

    Transferspreadsheet method, sheet name with spaces

    how do you do that



    clearly this isn't how:

    Code:
    DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12, "CraneAndEquipment", JohnCranes, -1, "'[Crane And Equipment]"
    I've tried many combinations of this, quotes, exclamations on either side, whatever
    Reply With Quote Reply With Quote
  2. 01-22-2013, 03:42 PM #2
    togo
    togo is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    83
    got it
    http://www.tek-tips.com/viewthread.cfm?qid=1503151

    use full path for path, then use worksheet name as normal
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Macros to make Sheet 1 Look like Sheet 2 in EXCEL
    By taimysho0 in forum Misc
    Replies: 26
    Last Post: 01-08-2013, 04:55 PM
  2. Transferspreadsheet Method
    By allenjasonbrown@gmail.com in forum Programming
    Replies: 11
    Last Post: 06-30-2011, 11:40 AM
  3. Read-only Excel file after using TransferSpreadsheet Method
    By SCFM in forum Access
    Replies: 2
    Last Post: 02-27-2010, 06:53 AM
  4. Transferspreadsheet Help Please
    By graviz in forum Programming
    Replies: 0
    Last Post: 11-30-2009, 02:56 PM
  5. transferSpreadsheet
    By rabbit in forum Import/Export Data
    Replies: 1
    Last Post: 06-09-2006, 04:01 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums