Help with a Chart Fill from Access to Excel

E

EAB1977

I am trying to put a nice touch to the background of a chart that I
have, but I keep getting a Error 1004 Application object error on this
part of the code:

.Selection.Fill.OneColorGradient Style:=msoGradientHorizontal,
_
Variant:=1, Degree:=0.36

I am doing Excel automation from Access and I get this error every
time. If I do this in Excel, I do not get this error.

Has anyone tried this and had any success?
 
E

EAB1977

I have found my answer on my own.

When using the above code in Automation with Excel, for some reason,
the msoGradientHorizontal was not registered correctly. In my
instance, it automaticlly registered for me and now works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Extract embedded excel file from word document 0
Move Chart with Text 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Creating a Chart on form from selected data in query. 0
Merging from an Excel file with graphics 1
Integrating information from Word to Excel (not mail merge) 1
VSTO C# add in Outlook.Appointment error 0

Top