I recorded a macro to print a section of my sheet that lies outside of the normal print range. The name of the file will change when it is used. The problem I see is that in the macro below, it refers to the current file name. How can I get this to work no matter what the file name changes to?
Thank you for your help - and May the Code Be With You.
SteveC
Sub PRINTTIMESbuttonAtTimesList()
..... Selection.PrintOut From:=1, To:=1, Copies:=1, Collate:=True
..... Application.Run _
..... "'LOG Template.xls'!VIEWTIMES_and_TopOfTimes_Buttons"
End Sub
This message was edited by SteveC on 2002-10-05 05:07
Thank you for your help - and May the Code Be With You.
SteveC
Sub PRINTTIMESbuttonAtTimesList()
..... Selection.PrintOut From:=1, To:=1, Copies:=1, Collate:=True
..... Application.Run _
..... "'LOG Template.xls'!VIEWTIMES_and_TopOfTimes_Buttons"
End Sub
This message was edited by SteveC on 2002-10-05 05:07