Access 2007 - Macro Question

wyebird

Hi

I wonder if anybody could help please?

I have a series of saved imports in an Access 2007 database and I would like to write a macro which would run them all, rather than me going in to run them one by one, but I can't see how to do this.
Microsoft site seems to suggest that it is possible, but I can't see how to do it?

Thank you

JG007

http://msdn.microsoft.com/en-us/library/bb177446.aspx
create a macro similar to this -

Sub Macro_Import()
DoCmd.RunSavedImportExport ("MySavedImportName1")
DoCmd.RunSavedImportExport ("MySavedImportName2")
End Sub

just replace the "MySavedImportName" with the name of your Macro1 and add the DoCmd line as many times as required