× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Dan,

1) Strange -- Excel2003 uses .xls just fine, oh well, glad you found it.
Yes, Normal.dot is my friend in Word too.

2) Yes, the & is concat in VB. As for the path, check out the following.
I don't know if .FullName is new in 2003 or not. 

ActiveSheet.PageSetup.LeftHeader = ThisWorkbook.FullName

3) You need to digitally sign the macro, then trust things published
with that signature. You should be able to self-sign, no need for a
"real" certificate, but it's been a while since I looked into that. Or,
in 2003 I have an option called "Trust all installed add-ins and
templates", check into that.

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of Dan Bale
Sent: Friday, August 27, 2004 12:59 PM
To: PC Technical Discussion for iSeries Users
Subject: RE: [PCTECH] Two Excel questions

Thanks Walden & Vern!

Only one slight correction in Walden's post: "save this as Book.xlt",
not
.xls.  You can imagine the frustration I was having with that one!

Have customized normal.dot in Word for years, never thought to do it in
Excel!  Now I have all my normal Excel customs (The file's Title in
center
header, &Tab in right header, &File in left footer, Page n of nn in
center
footer, and save timestamp in right footer) in the default template!
Wow,
what a day!

OK, now *really* make my day (not Clint Eastwood style, of course! <g>)
and
show me how to prepend the text "Last Updated: " to the save timestamp
that
gets printed in the footer.  I tried to enter that in the normal
"Customize
Footer" dialog box, but it got replaced by the function when the
spreadsheet
was saved.  I imagine it needs to be done in the function, but can't
really
see how I'd do it.  Oh, wait, I dug & dug through the help and figured
it
out.  '&' is the concatenator, eh?

Now, how about being able to print the path along with the filename?
(Currently, I can only print the filename w/o the path in the left
footer.)
Is that a VBA macro as well?  It doesn't appear to be one of the
BuiltinDocumentProperties.  I've been all over the VBA help on this as
well,
but nothing stands out.

Also, is there a way to keep this macro from triggering the dialog box
that
makes you choose between disabling and enabling macros?  I would like to
keep that behavior *except* I'd like this particular one to be marked
"trusted" somehow so that it doesn't trigger the warning.

I guess that's more than two Excel questions!

Many, many, many thanks!

- Dan

> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx
[mailto:pctech-bounces@xxxxxxxxxxxx]On
> Behalf Of Walden H. Leverich
> Sent: Friday, August 27, 2004 10:12 AM
> To: PC Technical Discussion for iSeries Users
> Subject: RE: [PCTECH] Two Excel questions
>
>
> Dan,
>
> In reverse order:
>
> 2) Hit F2 -- does that do what you need?
>
> 1) I don't know a way to do it in the "Page Setup" part of Excel, but
> that's not to say it can't be done. Bring up the VB Editor in Excel.
Add
> the code below to the WorkBook object. If you want this there by
default
> save this as Book.xls in ...\Application Data\Microsoft\Excel\XLStart.
> The code will reset the RightHeader (use what you want) to be the Last
> Save Time before each print. When you first bring up a new book this
> time will be the time you saved the template, after that it will be
the
> time you saved this book.
>
> Private Sub Workbook_BeforePrint(Cancel As Boolean)
>
> ActiveSheet.PageSetup.RightHeader = BuiltinDocumentProperties("Last
Save
> Time").Value
>
> End Sub
>
> -Walden
>
>
> ------------
> Walden H Leverich III
> President & CEO
> Tech Software
> (516) 627-3800 x11
> WaldenL@xxxxxxxxxxxxxxx
> http://www.TechSoftInc.com
>
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
>
> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
> On Behalf Of Dan Bale
> Sent: Friday, August 27, 2004 9:35 AM
> To: pctech@xxxxxxxxxxxx
> Subject: [PCTECH] Two Excel questions
>
> Excel 2000 (on W2K)  (BTW, can anyone suggest helpful Excel web sites
> that
> have tutorials and useful forums?)
>
> 1) I have a personal habit of printing the date & time on the printed
> output.  In Word, I have always been able to specify the file
date/time,
> which is more meaningful than the current date/time that the document
> was
> printed.  In Excel, I have only been able print the current date/time.
> Does
> anyone know if it's possible to print the file's save date/time in the
> header or footer?
>
> 2) There are two methods that I am aware of to edit a cell.  The first
> is
> when the cursor/focus is in the cell on the sheet.  The second is when
> the
> cursor/focus is up in the Formula Bar.  Since I am not the world's
best
> typist, and I normally go for speed more than accuracy, I often find
> that I
> need to back up in the cell to make a correction.  The default entry
> focus
> is in the cell on the sheet; when I attempt to use any of the <cursor
> arrow>
> keys to maneuver around in the cell, the cell loses focus and focus
> changes
> to an adjacent cell, and then I have to move my hand from the keyboard
> to
> the mouse, move it to the Formula Bar, and click.  This is a huge
> time-waster for me.  Once the focus is in the Formula Bar, I can use
the
> <cursor arrow> keys to maneuver around the cell's contents.
>
> I understand that the design of the <cursor arrow> keys is a huge part
> of
> how one maneuvers around in Excel, but I am such a keyboardist that I
> would
> rather be able to limit the <cursor arrow> keys to maneuver within a
> cell
> and have only the mouse and tab keys to change focus to different
cells.
>
> There's gotta be a way.
>
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.
>
> --
> This is the PC Technical Discussion for iSeries Users (PcTech)
> mailing list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech

--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing
list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.