Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print non-XL file
XL 2K
How would I tell Windows to print a non-Excel file (say, "c:\test\test.tif") from within a macro? Thanks, Tim C |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print non-XL file
I found the code below at MSKB article 238245.
http://support.microsoft.com/default...45&Product=vba I changed "open" to "print" and it works as required. Thanks, Tim C Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation _ As String, ByVal lpFile As String, ByVal lpParameters _ As String, ByVal lpDirectory As String, ByVal nShowCmd _ As Long) As Long Declare Function apiFindWindow Lib "User32" Alias "FindWindowA" _ (ByVal lpclassname As Any, ByVal lpCaption As Any) As Long Global Const SW_SHOWNORMAL = 1 Sub ShellExecuteExample() Dim hwnd Dim StartDoc hwnd = apiFindWindow("OPUSAPP", "0") StartDoc = ShellExecute(hwnd, "open", "C:\My Documents\Book1.xls", "", _ "C:\", SW_SHOWNORMAL) End Sub "Tim C" wrote in message ... XL 2K How would I tell Windows to print a non-Excel file (say, "c:\test\test.tif") from within a macro? Thanks, Tim C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my excel is converting all my print jobs to print to file why? | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
Can view file in print preview, but not print layout.... | Excel Discussion (Misc queries) | |||
print and print preview not active in file drop down | Excel Discussion (Misc queries) | |||
How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) |