Still using Excel 2003.
I have a footer macro where the variable "Source" of data is requested in the following code, however in some instances the length of text is quite long, is there a way to word wrap this text.
.RightFooter = "Page &P of &N" & Chr(10) & "&""Arial,Italic""&9Data Source: " & Source
Secondly the macro for the LeftFooter returns the file path and file name (&Z &F) however this returns a drive letter e.g. H:\ where as I want to return the server name e.g. \\ntgcca1\ is this possible.
Thanks in advance.
I have a footer macro where the variable "Source" of data is requested in the following code, however in some instances the length of text is quite long, is there a way to word wrap this text.
.RightFooter = "Page &P of &N" & Chr(10) & "&""Arial,Italic""&9Data Source: " & Source
Secondly the macro for the LeftFooter returns the file path and file name (&Z &F) however this returns a drive letter e.g. H:\ where as I want to return the server name e.g. \\ntgcca1\ is this possible.
Thanks in advance.
