TransferSpreadsheet action

[Terrence Carroll]

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

 

[Jerry Whittle]

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.