Results 1 to 3 of 3
  1. #1
    unrealtb is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    2

    Exporting to Specific Excel Sheet

    Hey all,
    Thanks in advance for the replies.



    What I am trying to do is EXPORT a query to an Excel Workbook which is read only and I need the data to land in a specific sheet in the excel workbook.

    I have tried transferspreadsheet vbcode etc. but nothing works quite right and the fact the spreadsheet is Read Only does not help.

    The Name of the Query is "Accrual"

    The Name and location of the Excel Spreadsheet is "c:\register.xls"

    The Sheet inside the workbook is called "data".

    I need the data to land in the "data" sheet over the top of the previous data and not create a new sheet or mess with the forumales that are linked to the "data" sheet.

    if someone could write me some code I would appreciate the help so much!

    Thanks!

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    As far as I know, you can't send to a read only worksheet.

  3. #3
    unrealtb is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    2
    hmmm are you sure there is not anyway around that, temporary make it not read only? If that is the case I will make the file un read only. what code would i need anyway? can you help?

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

Similar Threads

  1. Export Query to Specific Sheet and Rows/Columns
    By chewbears in forum Queries
    Replies: 7
    Last Post: 11-30-2011, 09:44 AM
  2. Exporting to .txt with Specific Format
    By KrenzyRyan in forum Import/Export Data
    Replies: 12
    Last Post: 11-18-2011, 04:57 AM
  3. VBA to create Excel sheet and a copy as PDF
    By MichaelC in forum Programming
    Replies: 2
    Last Post: 05-04-2011, 02:32 PM
  4. Exporting only specific data
    By cypress in forum Access
    Replies: 1
    Last Post: 09-24-2010, 10:41 AM
  5. Replies: 2
    Last Post: 07-15-2009, 04:08 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