Is there anyway to see a history of print jobs for a particular document and
what date they were printed?
Is there anyway to see a history of print jobs for a particular document and
what date they were printed?
Create a sheet named "PrintLog",
then insert following code in ThisWorkbook.
HTH
--
AP
'----------------------------------------------------------------------------------------
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Worksheets("PrintLog")
.Cells(Rows.Count, "A").End(xlUp).items(2).Value = Now
End With
End Sub
'----------------------------------------------------------------------------------------
"History of print jobs" <History of print [email protected]> a
écrit dans le message de news:
[email protected]...
> Is there anyway to see a history of print jobs for a particular document
> and
> what date they were printed?
I apologize. Could you be a bit more specific? The document of interest is
in excel format. I really appreciate your help.
"Ardus Petus" wrote:
> Create a sheet named "PrintLog",
> then insert following code in ThisWorkbook.
>
> HTH
> --
> AP
>
>
> '----------------------------------------------------------------------------------------
> Private Sub Workbook_BeforePrint(Cancel As Boolean)
> With Worksheets("PrintLog")
> .Cells(Rows.Count, "A").End(xlUp).items(2).Value = Now
> End With
> End Sub
>
> '----------------------------------------------------------------------------------------
> "History of print jobs" <History of print [email protected]> a
> écrit dans le message de news:
> [email protected]...
> > Is there anyway to see a history of print jobs for a particular document
> > and
> > what date they were printed?
>
>
>
In your workbook:
>insert>Worksheet
right-click on new tab, select rename
enter PrintLog as new sheet name
Right-click on Excel icon on top left cornet of you workbook window
select View code
In the newly opened window, paste the code I sent you.
Get back to excel and test the new macro (print your workbook)
HTH
--
AP
"History of print jobs" <[email protected]> a
écrit dans le message de news:
[email protected]...
>I apologize. Could you be a bit more specific? The document of interest
>is
> in excel format. I really appreciate your help.
>
> "Ardus Petus" wrote:
>
>> Create a sheet named "PrintLog",
>> then insert following code in ThisWorkbook.
>>
>> HTH
>> --
>> AP
>>
>>
>> '----------------------------------------------------------------------------------------
>> Private Sub Workbook_BeforePrint(Cancel As Boolean)
>> With Worksheets("PrintLog")
>> .Cells(Rows.Count, "A").End(xlUp).items(2).Value = Now
>> End With
>> End Sub
>>
>> '----------------------------------------------------------------------------------------
>> "History of print jobs" <History of print [email protected]>
>> a
>> écrit dans le message de news:
>> [email protected]...
>> > Is there anyway to see a history of print jobs for a particular
>> > document
>> > and
>> > what date they were printed?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks