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



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.