Excel

#21

Macros can be signed locally and for free if they're not moving
around. Now, ask me how to do that and I'll have to charge ya.

If you're sending sheets around an office though, this isn't
practical. For many reasons, neither is going around an end-user's
office and setting everyone's security to Low.

T

"Kevin Powick" <nospam (AT) spamless (DOT) com> wrote:

Quote:

Dave Mitchell wrote:

that warning message that comes up when you
open Excel stating that "This file contains macros.... Do you wish to
continue", the only way I know of to get rid of that message is to
set your security level to low in Excel (Tools ==> Macros ==
Security...)

Or digitally sign your VBA macro. You'll need a certificate from a
provider such as VeriSign.

http://www.verisign.com/products-ser...s/code-signing
/digital-ids-code-signing/index.html

We're required to do this to meet some of customer's security standards.

#22

Larry, it sounds like you're looking for "formatting", not "Excel".
Here is another situation where the focused question seems to be
leading us toward good solutions, but the wrong solution for the real
problem.

I'm not really sure what problem you're really trying to solve
anymore. If you like the HTML solution with Excel, this has been
documented here before. Essentially:
- Draw up a nice Excel sheet.
- Save as HTML
- Use that file as a template, do string manipulation with D3 to add
data, etc
- Save a new HTML document.
- Open with Excel to see your beautiful data.

Or try the same operation with XML. I understand Office 12 has
extended XML capabilities but I have yet to look into what they are.

My best,
T

"Homer L. Hazel" <hNoOmerlhANTI (AT) SPAMcox (DOT) net> wrote:

Quote:

Brian,

Thanks again. That looks like an excellent resource to have
available.

Larry

"Brian Speirs" <bss59REMOVE_THIS (AT) paradise (DOT) net.nz> wrote in message
news:4371789d (AT) clear (DOT) net.nz...
Shading is fine. Use bgcolor=xxxxx in a tr or td definition.

Excel offers a lot MS specific formatting options. You can find details
at:

http://msdn.microsoft.com/library/de...ml/ofxml2k.asp

or search 'ofhtml9' at microsoft.com

Cheers,

Brian

Homer L. Hazel wrote:
Brian,

I don't know why I didn't think of HTML sooner. I was fixated on Excel.

I've written programs to create HTML versions of Sales Orders and
Purchase Orders for clients. Don't know why I didn't think of it for
this application.

The output in Excel is essentially in a table so I can certainly modify
the program that creates the output to put the HTML around it such
that it looks all right. Some of the cells have to have grey and light
blue shading, so that will definitely mean a test in Excel.

Thanks for the excellent suggestion.

Larry Hazel

--
************************************************** *
Brian Speirs
h: (04) 479 9032 c: (021) 265 5906
e: bss59REMOVETHIS (AT) paradise (DOT) net.nz

#23

The way I understood it, he just wants to set this up on one computer (the
server). If it costs him to digitally sign a macro, and it's only on the
one computer, then setting security to low shouldn't be too much of a
hassle.

Dave

"Tony Gravagno" <g6q3x9lu53001 (AT) sneakemail (DOT) com.invalid> wrote

Quote:

Macros can be signed locally and for free if they're not moving
around. Now, ask me how to do that and I'll have to charge ya.

If you're sending sheets around an office though, this isn't
practical. For many reasons, neither is going around an end-user's
office and setting everyone's security to Low.

T

"Kevin Powick" <nospam (AT) spamless (DOT) com> wrote:

Dave Mitchell wrote:

that warning message that comes up when you
open Excel stating that "This file contains macros.... Do you wish to
continue", the only way I know of to get rid of that message is to
set your security level to low in Excel (Tools ==> Macros ==
Security...)

Or digitally sign your VBA macro. You'll need a certificate from a
provider such as VeriSign.

http://www.verisign.com/products-ser...s/code-signing
/digital-ids-code-signing/index.html

We're required to do this to meet some of customer's security standards.

#24

Tony,

I know about selfsign.exe.

Larry

"Tony Gravagno" <g6q3x9lu53001 (AT) sneakemail (DOT) com.invalid> wrote

Quote:

Macros can be signed locally and for free if they're not moving
around. Now, ask me how to do that and I'll have to charge ya.

If you're sending sheets around an office though, this isn't
practical. For many reasons, neither is going around an end-user's
office and setting everyone's security to Low.

T

"Kevin Powick" <nospam (AT) spamless (DOT) com> wrote:

Dave Mitchell wrote:

that warning message that comes up when you
open Excel stating that "This file contains macros.... Do you wish to
continue", the only way I know of to get rid of that message is to
set your security level to low in Excel (Tools ==> Macros ==
Security...)

Or digitally sign your VBA macro. You'll need a certificate from a
provider such as VeriSign.

http://www.verisign.com/products-ser...s/code-signing
/digital-ids-code-signing/index.html

We're required to do this to meet some of customer's security standards.

#25

Dave,

Yeah it's supposed to be run on the D3 server, but after playing with
starting Excel, I've decided that I'm too scared to start Excel directly.

I'm going to spend some time playing with the VBS sample I got to see
if that will do it without starting Excel.

If that doesn't work, I'll probably have to modify the program to
incorporate
HTML code.

Thanks to everyone for their assistance.

Larry Hazel

"Dave Mitchell" <mitch500 (AT) sympatico (DOT) ca> wrote

Quote:

The way I understood it, he just wants to set this up on one computer (the
server). If it costs him to digitally sign a macro, and it's only on the
one computer, then setting security to low shouldn't be too much of a
hassle.

Dave

"Tony Gravagno" <g6q3x9lu53001 (AT) sneakemail (DOT) com.invalid> wrote in message
news:9om7n1lr714p0a1mhba37csbfni5f0odfl (AT) 4ax (DOT) com...
Macros can be signed locally and for free if they're not moving
around. Now, ask me how to do that and I'll have to charge ya.

If you're sending sheets around an office though, this isn't
practical. For many reasons, neither is going around an end-user's
office and setting everyone's security to Low.

T

"Kevin Powick" <nospam (AT) spamless (DOT) com> wrote:

Dave Mitchell wrote:

that warning message that comes up when you
open Excel stating that "This file contains macros.... Do you wish to
continue", the only way I know of to get rid of that message is to
set your security level to low in Excel (Tools ==> Macros ==
Security...)

Or digitally sign your VBA macro. You'll need a certificate from a
provider such as VeriSign.

http://www.verisign.com/products-ser...s/code-signing
/digital-ids-code-signing/index.html

We're required to do this to meet some of customer's security standards.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Excel

comp.databases.pick comp.databases.pick

Re: Excel - 11-10-2005 , 05:46 PM

Re: Excel - 11-10-2005 , 05:46 PM

Re: Excel - 11-10-2005 , 06:42 PM

Re: Excel - 11-10-2005 , 08:25 PM

Re: Excel - 11-10-2005 , 08:27 PM