This is my first attempt at integrating Access and Excel, so please excuse my ignorance. I am trying to use code from Alison Balter's book on Mastering Access to create an instance of Excel and create a graph in Excel. However, I keep getting an error stating "Object variable or With block variable not set". the error occurs on the following line of code:
The entire sub is attached as a text file.
I'm sure it is something simple that I am too dense to see. Any help is greatly appreciated.