NO Transferspreadsheet option in 2007?

Discussion in 'Microsoft Access Macros' started by Phil Smith, Jul 22, 2009.

  1. Phil Smith

    Phil Smith Guest

    I am working with a 2003 database, and a 2003 excel spreadsheet.

    I am trying to add a new feature to my menu, hit the button,
    transferspreadsheet to s:\reports\myreport.xls.

    Problem is, in creating the macro that will be tied to that button,
    (which does a few other things first,) TransferSpreadsheet is not an option?

    Only thing I say in the help was to "Trust Center Security" BS, buyt my
    trust center has macro security set to "Enable All Macros."

    Help?
     
    Phil Smith, Jul 22, 2009
    #1
    1. Advertisements

  2. You need to "Show All Macros". See this help article for more information.
    http://office.microsoft.com/en-us/access/HA012142021033.aspx

    --

    Ken Snell
    <MS ACCESS MVP>
    http://www.accessmvp.com/KDSnell/


    "Phil Smith" <> wrote in message
    news:...
    >I am working with a 2003 database, and a 2003 excel spreadsheet.
    >
    > I am trying to add a new feature to my menu, hit the button,
    > transferspreadsheet to s:\reports\myreport.xls.
    >
    > Problem is, in creating the macro that will be tied to that button, (which
    > does a few other things first,) TransferSpreadsheet is not an option?
    >
    > Only thing I say in the help was to "Trust Center Security" BS, buyt my
    > trust center has macro security set to "Enable All Macros."
    >
    > Help?
    >
     
    Ken Snell [MVP], Jul 23, 2009
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Greg

    TransferSpreadsheet

    Greg, Jul 8, 2003, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    1,076
    dennis
    Jul 10, 2003
  2. Scooby912

    TransferSpreadSheet help

    Scooby912, Aug 1, 2003, in forum: Microsoft Access Macros
    Replies:
    3
    Views:
    3,571
    Scooby912
    Aug 5, 2003
  3. Joe R.

    TransferSpreadsheet/OutputTo Spreadsheet Help

    Joe R., Aug 13, 2003, in forum: Microsoft Access Macros
    Replies:
    2
    Views:
    1,103
    Joe R.
    Aug 14, 2003
  4. Clifford S. Morton

    TransferSpreadsheet

    Clifford S. Morton, Sep 8, 2003, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    539
    Clifford S. Morton
    Sep 8, 2003
  5. adodson

    Office 2007 TransferSpreadsheet Import

    adodson, Jul 28, 2008, in forum: Microsoft Access Macros
    Replies:
    5
    Views:
    326
    Pete D.
    Jul 31, 2008
Loading...

Share This Page