I am trying to write a BV program that calls an excel file and graphs the data. I have figured out how to pull in the file but I am having difficulty in programming the part that tells Excel which cells to choose for the chart. I have tried the methods via MSDN but I get messages about incorrect objet class types and other various bugs during compile time. The range of cells I need to graph change with each file and I am trying to automate this by finding the last row of the file to figure the range. I already know what columns to use and I can hard wire that it.
Thanks in advance for any help!
Mike
Thanks in advance for any help!
Mike