Results 1 to 2 of 2
  1. 12-01-2011, 06:19 PM #1
    Badvgood
    Badvgood is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    4

    Macro saving file path to xlsx but can i specify what sheet

    Hi again,

    I am using a macro to output to an excel file path.

    I can get it to write to the correct .xlsx file but is it possible to say what sheet in the .xlsx file you want the output written to?

    ie sheet3

    Thanks BVG
    Reply With Quote Reply With Quote
  2. 12-02-2011, 10:43 AM #2
    Badvgood
    Badvgood is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    4
    Any ideas anyone?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Open Excel .xlsx file from Access
    By Bigmix in forum Programming
    Replies: 6
    Last Post: 02-28-2012, 09:55 AM
  2. path\file access error 75
    By PRASANNA in forum Programming
    Replies: 2
    Last Post: 04-25-2011, 04:50 AM
  3. Saving OLE Linked Objects with Relative Path
    By bnnook in forum Access
    Replies: 1
    Last Post: 03-18-2011, 04:07 PM
  4. How to have the path of the open file on the title bar?
    By jamal numan in forum Access
    Replies: 1
    Last Post: 01-06-2011, 11:23 AM
  5. parametrize file path
    By ysrini in forum Access
    Replies: 3
    Last Post: 03-01-2010, 09:37 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums