print files form dialog

[coxonitus]

hi everybody

I'm using this code to save xlsm files in a folder.

[vba]' Opslaan_Als Macro
Dim SheetName As String
SheetName = InputBox(Prompt:="new filename:", _
Title:="name")
If SheetName = "" Then GoTo End
ActiveWorkbook.SaveAs "C:\Documents and Settings\xx\xx\2011\" & SheetName & ".xlsm"
ActiveWorkbook.Close
Exit Sub
End:
MsgBox "false not valid!", vbCritical, "Error"
End Sub[/vba]
Is it possible when I want to print a file that exists in that folder, we can call it and then print??

The print will be called from a dashboard.

anybody?

[keebellah]

Í'm sure it's possible, I'll have to see if I find some code a used some time ago and edit it for non-opened workbooks