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.

Share This Page