printing excel sheet

M

May

Dim xls As Excel.Workbook
Set xls = GetObject("c:\abc.xls")
xls.Parent.Visible = True
xls.Windows(1).Visible = True
xls.Application.ActiveWindow.SelectedSheets.PrintOut
copies:=1, Collate:=True
Set xls = Nothing

May
MCP in Access and SQL Server
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
Export Report with Graph to Excel error 2495 1
Shift Collate sheet 1-20 when printing entire workbook? 0
The Remote Server Machine Does Not Exist or is Not Available 2
Export Subform to Excel and open 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Print A For (docm), Send Email Attachment And Close For Without Saving 2

Top