Hi arnelgp,
thanks for your work I will update and look at your code!
Ok yes I guess that would be a better and simpler way doing so.
I will keep that in mind! But for me was just also a good practice to see if I can make it work.
Many thanks for your input!
Cheers!
Hi,
hmm ok..I just created to chart by selecting the Data and then once I did with right click and then create the Chart.
The other time with the ribbon.
I am not really familiar with charts not really using them just wanted to be able to make it work in Access for later reference.
Hi I did attach a Folder with all relevant Documents maybe someone could take a look to see what I am missing to get this chart into the Word Dokument.
Hope this is correct how I attached the folder?
Many thanks
Albert
Yes I did try your post too but got also an Error.. I think it was runtime Error 9 Out of scope or somthing down that line
Ok I will downsize it and put it on here.
Cheers
I am not sure what I suppose to try again.
The worksheet name ="Diagramm1"
The chart when I click on it and assign a macro to it it tells me that the chart is also named "Diagramm1"
I have tried to reference the worksheet like
dim wksChart as Excel.Worksheet
set wksChart =...
Hi again,
this is what the vb Editor shows
Diagramm1(Diagramm1)
I have been trying all your suggestions but I either get the Runtime Error 438 or a runtimeError 9 , Index out of range.
I am not sure where I am doing it wrong...
Where can I check what name the actual Chart has?
First time...
Hi,
unfortunatelly I am still getting the Runtime Error 438 with your suggestion of saving the Diagramm1
Object does not support Property or method.. well in my translation from German to English :-)
Somehow my referenz to that object is not working properly...
What am I missing?
Hi arnelgp,
yes it is on a seperate sheet the "Sheetname" is "Diagramm1"
The problem is that I like to insert the diagramm to a bookmark in the Word Template file.
Diagramm1.ChartArea.Copy
.Selection.GoTo what:=-1, Name:="ChartLocation" 'late binding...
Hi guys,
unfortunatelly I am getting an runtime Error 438, Object not supported.
When I try to copy a Chart from an Excel Worksheet.
here is the Code.
"Hole Anwendung"
Function HoleAnwendung(strName As String) As Object
On Error Resume Next
Set HoleAnwendung = GetObject(, strName)...
Hi again,
I have been trying and still not really any luck with getting the data from ADO Connection String.
For testing purpose I did try in Excel instead of Access with all the same as it has been done on the tutorial Video.
As "WiseOwl" Andrew has done it in his Video. Great tutorials by...