RE: [PCTECH] Two Excel questions

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

replies inline...

> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx / Walden H. Leverich
> Sent: Friday, August 27, 2004 1:19 PM
>
> 1) Strange -- Excel2003 uses .xls just fine, oh well, glad you found it.
> Yes, Normal.dot is my friend in Word too.

Well, it *does* work, but it isn't a template.  As an .xls, you'd always
have to do a Save As, change to your folder, etc.  I didn't really want to
have to remember to always explicitly do a Save As when I created a new
file.  As an .xlt, when I create a new file and go to save, it forces you to
the Save As dialog box and defaults to the folder set up in the Options.

> 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

Yep.  Works in Excel 2000 as well!  This is great stuff, even if it is
pretty well hidden.

> 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.

OK, will look for that one.

> Or, in 2003 I have an option called "Trust all installed add-ins
> and templates", check into that.

I have that option and it is checked.  Still getting the warning, though.
Also, I am unable to specify individual "trusted sources", even when the
"Trust all" box is unchecked.  Doesn't "Trust all" make you vulnerable?  How
is that any different than setting the security level to Low?  (My security
level is set to Medium. The dialog shows "No virus scanner installed" when,
in fact, I have Symantec Corporate Edition AV client installed, and all the
realtime protections are enabled; are there special scanners for Excel
macros?)

Thanks again!
Dan