Hi Shawn,
> have you considered using ADO instead?
User has Excel, and in fact was quoting how great it was at printing,
when asking me to provide grid printing.
I provide formatting during the automation, so that it looks much like
my lovely SGrid-2 configuration.
> Show us how you clean up when you close a document.
I'm not cleaning up.
It was not an oversight, but rather uncertainty as to the impact of
setting objects to nothing, whilst user is viewing the data in Excel.
I had to 'invent' it, and get it to the user quickly, so I dared not
risk having code that might effect the running Excel.
The source of my sample may not like me posting it to the public, so
I'll find a link on your web site to send the zipped project.
Unless the answer is as simple as -
"Don't worry Rob, you can close and set to nothing, every reference
that you had, and Excel will keep on running for the user".
If there is mild uncertainty regarding the versions of Excel that
users may be using it, should I use early or late binding ?
Thanks,
Rob
--- In [email protected], "Shawn K. Hall" <[EMAIL PROTECTED]> wrote:
> Hi Rob,
>
> > Then I will ask a question regarding the only thing the Sgrid
> > doesn't do - print. (It does everything else, and I swear I
> > can hear it whistling Dixie)
>
> Hehehehehehe
>
>
> > I am using automation of Excel, to export the grid's layout
> > and content(data)...
>
> Did you know that wrapping excel to provide the same functionality
> is a violation of the VB terms of use? What a load, eh?
>
>
> > The user is very happy (but I notice it is leaving traces
> > (instances ?) of Excel in memory.
>
> Are you closing all objects and .quit'ing the app object?
>
> Show us how you clean up when you close a document.
>
> Oh, and if you don't use the native excel range and other objects -
> but just need a way to manipulate the data - have you considered
> using ADO instead? No excel object, and Excel doesn't even have to
> be installed.
>
> Regards,
>
> Shawn K. Hall
> http://12PointDesign.com/
> http://ReliableAnswers.com/
>
> '// ========================================================
> The direct use of force is such a poor solution to any
> problem, it is generally employed only by small
> children and large nations.
> -- David Friedman
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
