shackbully
New Member
- Joined
- Oct 24, 2004
- Messages
- 7
it will open the file, but then it will stop, it will step through fine. all i want it to do is open this file, print it, then close the file. it sounds so simple.
i'm thinking of getting a large wrench from the shop. i'm just not getting the hang of visual basic, any suggested reading or training?
thanks
lucien
' Keyboard Shortcut: Ctrl+Shift+I
'
Workbooks.Open Filename:="C:\p2_daily\Forms\logshets\p2_2hrlogsheet.xls"
Range("A1:DX40").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$DX$40"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWindow.Close SaveChanges = False
End Sub
i'm thinking of getting a large wrench from the shop. i'm just not getting the hang of visual basic, any suggested reading or training?
thanks
lucien
' Keyboard Shortcut: Ctrl+Shift+I
'
Workbooks.Open Filename:="C:\p2_daily\Forms\logshets\p2_2hrlogsheet.xls"
Range("A1:DX40").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$DX$40"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWindow.Close SaveChanges = False
End Sub