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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.