how to print preview a file in excel using VB 6

any help is greatly appreciated

thanks in advance.


I would go to Excel and start recording a macro, do the command you wish to do and that will give you basic command you need. Then translate into your version of VB.

I don't know preview command so can't give you exact command, but hope this helps.