Hi,
I would like to add a command button to a form which exactly mimics a particular ribbon command being clicked. Is there a vba command to run a ribbon command, and how do I find the list of ribbon commands available etc.?
Basically I want to exactly replicate what happens when you click the Export to Excel button on the External Data tab. (I know there are various vba commands; outputto, transferspeadsheet, docmd.runcommand accmdOutputTooExcel etc, but none of these do exactly what I want. I want to bring up the Export - Excel Spreadsheet dialog, so the user has some control.)
The ribbon on my app is hidden and I don't want to go down the route of customised ribbons etc.
Many thanks for any help,
Jim
I would like to add a command button to a form which exactly mimics a particular ribbon command being clicked. Is there a vba command to run a ribbon command, and how do I find the list of ribbon commands available etc.?
Basically I want to exactly replicate what happens when you click the Export to Excel button on the External Data tab. (I know there are various vba commands; outputto, transferspeadsheet, docmd.runcommand accmdOutputTooExcel etc, but none of these do exactly what I want. I want to bring up the Export - Excel Spreadsheet dialog, so the user has some control.)
The ribbon on my app is hidden and I don't want to go down the route of customised ribbons etc.
Many thanks for any help,
Jim