English 中文(简体)
缩略语
原标题:Access copied graph in VBA

我已经复制并贴出关于另一工作表格的图表:

With ActiveChart
        .ChartArea.Copy
End With

Worksheets("Legends").Paste

Dim LegendGraph As Object
LegendGraph = Worksheets("Legends").ChartObjects(Worksheets("Legends").ChartObjects.count)

最后一行赢得了工作。 我如何查阅抄本的图表?

最佳回答

我可以这样说:

Worksheets("Legends").ChartObjects(Worksheets("Legends").ChartObjects.count).Chart
问题回答

暂无回答




相关问题
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 ...

热门标签