Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to print without opening the document....
I'm trying to print excel files witout having to open the document. I have a
master file that I make changes to, which changes all the other files. I then want to print all the other files all at the same time without having to go into them and open them up. Any sugguestions??????? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to print without opening the document....
Hi
AFAIK not possible witout opening them -- Regards Frank Kabel Frankfurt, Germany "Tim needs help" <Tim needs schrieb im Newsbeitrag ... I'm trying to print excel files witout having to open the document. I have a master file that I make changes to, which changes all the other files. I then want to print all the other files all at the same time without having to go into them and open them up. Any sugguestions??????? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to print without opening the document....
With a macro you can open and print them
Try this one for all Excel files in the folder C:\Data Sub TestFile1() Dim i As Long Dim WB As Workbook Application.ScreenUpdating = False With Application.FileSearch .NewSearch .LookIn = "C:\Data" .SearchSubFolders = False .FileType = msoFileTypeExcelWorkbooks If .Execute() 0 Then For i = 1 To .FoundFiles.Count Set WB = Workbooks.Open(.FoundFiles(i)) WB.PrintOut WB.Close False Next i End If End With Application.ScreenUpdating = True End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Frank Kabel" wrote in message ... Hi AFAIK not possible witout opening them -- Regards Frank Kabel Frankfurt, Germany "Tim needs help" <Tim needs schrieb im Newsbeitrag ... I'm trying to print excel files witout having to open the document. I have a master file that I make changes to, which changes all the other files. I then want to print all the other files all at the same time without having to go into them and open them up. Any sugguestions??????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a document | New Users to Excel | |||
Document Properties sent to print when print with office applicati | Excel Discussion (Misc queries) | |||
how do i rotate a document or print small document on envelope | New Users to Excel | |||
how can I delete the print box that pops up to show document print | Excel Discussion (Misc queries) | |||
Two copies of same document appear when opening a document | Excel Discussion (Misc queries) |