Calling Excel File Save As Dialog
On Thu, 13 Jul 2006 17:41:01 -0700, JMB
wrote:
I think your issue is due to using late binding for xlApp. The program can't
make sense of the constant xldialogsaveas because there is no reference set
up to Excel. I had a similar issue w/Word - which was resolved and explained
by Peo Sjoblom (for which I am still grateful). As Tom posted, you must use
the numerical value of that constant. Or, set up a reference to Excel under
Tools/References and use early binding.
Thanks.
|