VBA call analyze with Excel

[Guest]

Hello,

1)I want to call the "analyze with Excel"-function to
export data of a table (export can't be used)
programmically from a button in a form.
If you call this function from the button in the form,
would that give a problem to export the data of a table?

2)Want to call code at the opening of db. How to do this?

Can somebody help (would be greatly appreciated) me on
this matter?

 

[Nikos Yannacopoulos]

1.
DoCmd.OpenTable ([Table Name in quotes, or variable])
DoCmd.RunCommand (acCmdOutputToExcel)

2.
Put your code in a module. Then make a macro with action
RunCode to call your code procedure, and name this macro
Autoexec. Your job is done.

Nikos