Access code to export to Excel worksheet collection

[Sideline]

I have some VBA code that loops through a collection of syntax files of a stats program and creates multiple output objects that I wish to export to excel. I have managed to copy a single pivot table object in the statistical package and paste it into excel but I am stuck on how I can access the worksheet collection of the destination excel worksheet and place the copied stats ouptput object into an associated excel worksheet.

And suggestions would be greatly appreciated.

Thanks!

 

[hermanlaksko]

Hi Sideline
Have been there .... Done that..... AND ... it worked :-D

However its not something that I would go thru on-line, as its a bit complicated and as we all know ... to see is to believe. So let me have your email and I will email you an example.
As it will take some time for me to compile a base with only this in do not expect my base right away and .... its gonna cost you....... a * ;-)

Herman

 

[Sideline]

Herman,
Thanks for the offer. Don't want to appear impatient but I have a pressing deadline as I need to get on a plane to head overseas. Can you giveme a timeline?
Richard

 

[hermanlaksko]

Apx. 1-2 days

 

[Sideline]

Herman,
Back form my jaunt OS with an extended deadline. Is your offer still on the table?
Richard
Richard.Floyd@community.nsw.gov.au

 

[hermanlaksko]

Sure thing matie.

I see that you are working for the gow..... so how about a work-permit ....... just kidding :-D

It should drop thru your door in a day or two.
Dont forget my * now ;-)