Recent content by silentwolf

  1. S

    Reffering to Excel Chart from Access

    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!
  2. S

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

    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?
  10. S

    Reffering to Excel Chart from Access

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

    Reffering to Excel Chart from Access

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

    ADOConnection Problem with displaying Data

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

    ADOConnection Problem with displaying Data

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

    ADOConnection Problem with displaying Data

    No not external a Network Drive "Server"
  15. S

    ADOConnection Problem with displaying Data

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