Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello.
    In Access 2007 what has happened to the TransferSpreadsheet macro action?
    I would like to create a macro to do this.
    Thank you, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    It should still be there: Access 2007 Developer Reference > TransferSpreadsheet Macro Action.
    But this article states "Note This action will not be allowed if the database is not trusted." So make sure that your database is trusted.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    It should still be there: Access 2007 Developer Reference > TransferSpreadsheet Macro Action.
    But this article states "Note This action will not be allowed if the database is not trusted." So make sure that your database is trusted.
    Thank you. Although I've trusted my folder location and closed re-opened Access, the
    TransferSpreadsheet action doesn't appear for a new macro.
    Do you think this means it's only available now using VBA and DoCmd? Andy.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't have Access 2007 so I cannot check it, but according to the help article I referred to, the TransferSpreadsheet macro action should still be available. Hopefully someone who has Access 2007 will have a suggestion for you.


  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In Design View of the Macro, go to the Design ribbon and in the Show/Hide Ribbon and click on "Show All Actions".
    Attached Images Attached Images
    Francois

  6. #6
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Francois View Post
    In Design View of the Macro, go to the Design ribbon and in the Show/Hide Ribbon and click on "Show All Actions".
    Thank you! That seems an odd design change though. Perhaps the actions that are then shown
    are considered to be "less safe"? Otherwise it seems pointless. Andy.

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    In 2007 macros are supposed to be safer than code, and allow databases to be used without being trusted.
    The standard list of macro actions are the safe ones. If you use any of the other ones, the database will need to be trusted.
    Here is the tool tip associated with the Show All Actions command.
    [attachment=86445:showall.gif]
    Attached Images Attached Images
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •