I used to be able to use the transferspreadsheet action in macros when I had 
Access 2000 to auto transfer spreadsheets as part of larger macros with 9-10 
procedures tied to each macro.  My company has migrated to Access 2007 and 
now the transferspreadsheet action does not exist when I try to run macros in 
Access 2007.  Is the transferspreadsheet action part of an add in or a .dll 
that my company may not have?  I am also missing the setwarnings action.  I 
have the macros settings adjusted to accept macros and this did not change 
anything.  

Thanks,

Terry Carroll  

It's there, but for some reason, they hid it!  

Open up a macro in design view. Make sure that you are on the Design tab. 
There should be a Show/Hide box. Click on Show All Actions.
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Terrence Carroll" wrote:

> I used to be able to use the transferspreadsheet action in macros when I had 
> Access 2000 to auto transfer spreadsheets as part of larger macros with 9-10 
> procedures tied to each macro.  My company has migrated to Access 2007 and 
> now the transferspreadsheet action does not exist when I try to run macros in 
> Access 2007.  Is the transferspreadsheet action part of an add in or a .dll 
> that my company may not have?  I am also missing the setwarnings action.  I 
> have the macros settings adjusted to accept macros and this did not change 
> anything.  
> 
> Thanks,
> 
> Terry Carroll