Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Excel Question
From:	Darlene Bost <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 14 Apr 1999 12:19:49 -0400
Content-Type:	text/plain
Parts/Attachments:	text/plain (27 lines)

I received the following VB macro from someone and would like to know how I can
make this available for every workbook I open in Excel.  Can someone tell me how
I should be saving this?

Sub FileName_In_Footer()
'
'Puts full filename and path in left footer
'  Date and Time in Right Footer
'
'
    With ActiveSheet.PageSetup
        .LeftFooter = "&""Arial""&6" & "Bost " & ActiveWorkbook.FullName & "-" &
 ActiveSheet.Name
        .CenterFooter = "Page &P of &N"
        .RightFooter = "&10" & "&D &T"
    End With

End Sub

Thanks!

Darlene

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                    http://nospin.com/pc/pcsoft.html

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG