English 中文(简体)
Access command from the Quick Access Toolbar
原标题:

When I use a macro, that opens a new email from a template, I would also like to access one of the commands from the Quick Access Toolbar and make sure a particular option is selected from the drop-down list on this command.

For example, the tab on the toolbar is called Add-Ins and within this tab the area on the toolbar is called custom toolbars . There is a command in this section entitled ACT! History , and I would like to automatically chose None from the drop-down list for this command. I do have a screen grab of the toolbar I can send you if this helps.

The current macro is a very simple one as the text below shows.

Sub MakeItem()
    Set newItem = Application.CreateItemFromTemplate("C:UsersjfieldAppData[file location]New Placement!.oft")
    newItem.Display
    Set newItem = Nothing
End Sub
问题回答

暂无回答




相关问题
Handling no results for docmd.applyfilter

I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...

Outlook 2007 CommandBarControl.Execute won t work

I recently switched to Outlook 2007 and noticed that my VBA-macros won t work. I use the following code to open a new appointment-item (and fill it automatically). It worked perfect in Outlook 2003, ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

MS Access: list macro from VBA

I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...

热门标签