PDA

View Full Version : print files form dialog



coxonitus
04-27-2011, 11:18 AM
hi everybody

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

' 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
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
05-01-2011, 05:52 AM
Í'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