Print EXCEL code

  • Thread starter Thread starter Deana
  • Start date Start date
D

Deana

I am trying to patent a model in EXCEL. As you may not
know or care, you need to totally describe the model's
creation so that, after the period expires, anyone can re-
create it. In any event, when patenting software models,
it is recommended that the patent application have a hard
copy list of all "source code". Since this model is in
EXCEL, I need a way to print all the formulas in each
cell.

Perhaps, it was in LOTUS and a decade ago, but I thought
there used to be a command such as "print cell contents"
that did this. But I can find nothing like that in my
current EXCEL.

I know I can use options to display formulas on the screen
and somehow print things out that way, but many of the
eqautions are hundreds of characters long, so that I will
only be able to print one column at a time and, even then,
the font may be so small that it is almost unreadable,
unless I do wrap around formatting, etc. This will get
extremely messy.

Can someone tell me if there is a way to print out my
worksheet's equivalent "source code"? Kindly reply
directly to my e-mail address, also.

Thanks so much!
Deana
 
I did ask that people reply to my e-mail address "also",
not instead. Nevertheless, I am sorry for the faux pas
and am happy to just use the newsgroup only. Thanks.

Though I am great at wrting complex algebraic formulas,
there is so much I don't know about the many
fucntionalities of EXCEL. It is probably just my own
confusion with semantics but I am not clear on your
answer. I am not trying to steal the underlying code of
EXCEL, of course, just trying to provide a listing of all
the formulas I put into empty worksheets in my model.
Perhaps, I should not have used the phrase "source code".
It was my simplistic understanding that, in more advanced
computer codes, this phrase describes what makes the
programmed algorithms work.

I have the following questions in regard to your answer of

"your only choices really are to deal with printing the
formulas..."

I am trying to deal with it, but am hoping that EXCEL has
some functionality that will help me do so. Are you an
expert on this kind of thing and, if so, are you saying
that this cannot be done via some sort of EXCEL commands
or options?

Is my recollection of some sort of "print cell contents"
command, possibly from old LOTUS days, a fairy tale?

Sorry and thanks again,
Deana
 
You indicated you are familiar with the option of displaying the formulas
instead of the results. You say you don't want to do that because you can't
show very many of them due to the size of many of your formulas. This is,
however, what Excel gives you to view the formulas. What exactly do you want
to see? I don't think anybody other than Microsoft cares if you see the
source code, but even if you saw it, what would you do with it? That would
be in a programming language and you would have to decompile Excel to see
it. I don't think this is what you are asking for, but just tell us an
example, what you would like to see.
Richard

I did ask that people reply to my e-mail address "also",
not instead. Nevertheless, I am sorry for the faux pas
and am happy to just use the newsgroup only. Thanks.

Though I am great at wrting complex algebraic formulas,
there is so much I don't know about the many
fucntionalities of EXCEL. It is probably just my own
confusion with semantics but I am not clear on your
answer. I am not trying to steal the underlying code of
EXCEL, of course, just trying to provide a listing of all
the formulas I put into empty worksheets in my model.
Perhaps, I should not have used the phrase "source code".
It was my simplistic understanding that, in more advanced
computer codes, this phrase describes what makes the
programmed algorithms work.

I have the following questions in regard to your answer of

"your only choices really are to deal with printing the
formulas..."

I am trying to deal with it, but am hoping that EXCEL has
some functionality that will help me do so. Are you an
expert on this kind of thing and, if so, are you saying
that this cannot be done via some sort of EXCEL commands
or options?

Is my recollection of some sort of "print cell contents"
command, possibly from old LOTUS days, a fairy tale?

Sorry and thanks again,
Deana
 
This looks like it may solve your issue.

http://j-walk.com/ss/excel/tips/tip37.htm

Though, it seems odd that you know you have something new and unique when
you are clearly not familiar with some of the more widely referenced/used XL
sites and admit you have a limited knowledge of XL.

PC
 
Wow, this looks great! I hope it will work with newer
versions of EXCEL, e.g., Office 2000. I also hope I can
remember how to paste in a macro - think I do. Will it do
all worksheets autoamtically, or do you need to go to the
target worksheet, one at a time, and do it that way? Let
me see what I can figure out!

Much thanks to all,
Dean
-----Original Message-----
Deana,

I have some code on my web site that will print formulas to Word.
See
http://www.cpearson.com/excel/excelM.htm#PrintFormulas for
 
This looks good, too! I assume it is pretty much the same
as Chip's, except that it prints to another worksheet,
rather than to WORD. I would also like to print a listing
of all cell formats (left align, bold font, etc), too.

Does anybody know how to do that?

By the way, to those that are asking, my model is a highly
specialized financial analysis model and is definitely
unique (I've changed it every day for the last 3 months)
although the jury is still out as to whether it will be
considered valuable by anyone other than me! In my
opinion, one needs to know only a tiny fraction of EXCEL's
many capabilities to program a ton of sophsiticated
algebra in it and even set it up so that it is user
friendly.

Thanks again all,
Deana
 
Chip,

Can you tell me what commands I must issue to satisfy this
instruction below on your web site? I don't see anything
called "references" beneath tools:

" Make sure that you have enabled references to Word
objects, from the Tools->References menu. "

I assume this command is to be issued in EXCEL, not WORD.
Do you have a simialr macro that lists cell formatting?

Thanks,
Deana
-----Original Message-----
Deana,

I have some code on my web site that will print formulas to Word.
See
http://www.cpearson.com/excel/excelM.htm#PrintFormulas for
 
Back
Top