excel programming question

[bclt]

Hi,

A print an excel sheet and then i want to delete it. How will i know when the printing is over?

'print excel sheet
file.delete("c:\sheet1.xls")

If i write as above an error occurs because the sheet1 is still in use (being printed). So:

While not (sheet1.HasFinishedPrinting)
' nothing here as code, just looping
wend
file.delete("c:\sheet1.xls")



Tnx

 

[chrissie1]

perhaps you should be better of asking this in the vba forum. Perhaps you already did.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[bclt]

vba?
The app i am creating is in VB.NET2003 .

 

[chrissie1]

Arent you using an escell object then? if you are then you need vba to solve it. Or you could use VBA to solve it. Since you are working with the excell namespace witch is what vba uses. And therefore exactly the same thing.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[bclt]

Agree, but why that forum isn't correct for my post?

 

[chrissie1]

show me the code you have for printing the sheet.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[ThatRickGuy]

If you are using a macro/vba script, then the VBA forum would be the correct place.

If you are using a COM excell object, then this would be the place.

I'm not sure about excell but on the Word doc COM object there is a .PrintOut method that takes a boolean parameter that indicates if it should print synchronously, or asynchronously. (True means wait until printing is complete to move on, false means move on immediately.)

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[chrissie1]

ah yes, some people still use com. How stupid.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[ThatRickGuy]

The question now becomes, is it stupid to use COM, or stupid to assume that no one uses COM? ;P

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[chrissie1]

Ah, yes. How stupid.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[bclt]

Sorry for posting late. I (the stupid) am using COM component... Microsoft.Intercop.Excel.dll

I am Doing: ExcelApp.Sheets.PrintOut() 'in vb 2005
excelapp.quit

 

[ThatRickGuy]

As I said in my first post:

ExcelApp.Sheets.PrintOut(True)
excelapp.quit

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.