Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kreuz

  1. kreuz

    populate excel from vb

    First enable "Microsoft Excel 9.0 Object Library" and "Excel ctl Type Library" in Project -> Referances Here is some very simple code that will allow you to open an excel application, set and read cell values and close the application. Put it in a module and try calling the...
  2. kreuz

    Drawing on a graph (scatter plot)

    Hi Skip and Rob, I thought I let you know how I made out. For fun, I tried both methods, seperate series and a single series. On the separate series method, there is a limit to the number of series you can add which I found to be 255. The single series method worked fine. Thanks for the...
  3. kreuz

    Drawing on a graph (scatter plot)

    Thanks for the ideas Skip and Rob!! Ill give it a shot! Thanks again
  4. kreuz

    Drawing on a graph (scatter plot)

    Hi Skip, I am plotting the electrical contacts of an IC that are interconnected in adjacent pairs. I have the XY location of each of 1800 contacts which I graphed using a scatter plot. I now want to show the interconnections between the adjacent pairs. I want to write a macro to draw the...
  5. kreuz

    Drawing on a graph (scatter plot)

    In excel, I have graphed my data using a scatter plot. I now want to write a macro to draw lines between certain data points on the graph. Here is my problem. How do I relate the graph’s coordinate system and my data? I believe the ActiveChart.Shapes.AddLine command uses twips for...

Part and Inventory Search

Back
Top