Recent content by silentwolf

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 =...

Unfortunatelly same issue I can't seam to get the reference right. I will keep trying.. Thanks anyway for your help!

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...

Thanks guys for the reply. I will try your suggestions..

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)...

Thanks for the link I will look into it! I will try ;) Cheers..

Hmm ok.. Not sure where the issue is.. but I will keep trying.. Thanks anyway for assitance !

No not external a Network Drive "Server"

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...