Driver to drive?

[krw]

On Tue, 7 Apr 2009 16:21:59 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

I taught a couple of CS courses at the local college (asked the Dean
once if I taught all the courses did I get the degree - MAIT) and
several at work, in the '80s. Putting together a course teaches a
lot. Standing up and teaching and (answering the questions) really
drives the subject home. After teaching for three hours I was pooped!

I'm teaching one theory and two tinbending classes next semester where the
three campuses are about 150 miles apart. One on Monday, one on Tuesday,
and one on Wednesday. I can do three hours of lecture without too much
problem, but the Monday class is half lecture, half lab and the other two
are all lab. Now LAB is what really poops you out.

I found the opposite. I could teach labs all day long. To me that

was more or less like working the same time in the lab. Time flies...

The college courses were all taught at night after work, so the three
hours on top of eight didn't help. When I taught internal classes it
was usually during work hours, so the hours weren't longer. The
internal courses were more fun; a much better class of student.

 

[Archimedes' Lever]

On Tue, 7 Apr 2009 14:08:54 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

Not quite. The original macro was given to me in this thread when I made a
fairly detailed description of what I was trying to do.

The original macro and the current macro are identical except for the

cell called.

 

[Archimedes' Lever]

On Tue, 7 Apr 2009 14:08:54 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

I don't believe that I said that I did. I did comment that unless you hit
the "print the entire workbook" button in the standard Excel print menu that
you have to do the job one page at a time, which is a royal pain in the time
fanny.

No, you do not. I already said that you can highlight MULTIPLE
worksheets at the time you select printing, and those sheets will ALL
print. So if you can use the macro to highlight sheets before printing,
you're set. Also, if you can have it HIDE the non-needed sheets, you will
get the same print result. That is all you need to do to make it a
single print job, which I am working on.

You could even make it so that each sheet gets tested the same way you
do when you fill F52, removing the need for that cell completely.

The trick here is to either have the macro highlight sheets that pass
the test or hide sheets that do not. That way the printout gets done
right, and in a single compilation print job.

 

[Archimedes' Lever]

On Tue, 7 Apr 2009 14:08:54 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

There is a way to modify the macro to highlight 'changed sheets' that
have specific data in F52, then run a standard print call which would
print those highlighted sheets all at once, instead of stepping through
each sheet, then printing it, it would step through each sheet,
highlighting it's tab, then calling the print job at the end.

Can you elucidate that for me a bit? What might the mod look like?

The current sheet is always "highlighted" at the bottom where the
sheet's tab is. You can highlight more than one at once, even though
only one is visible. A subsequent print prints ALL highlighted sheets.

All we would have to do is step through the F52 test on each sheet, and
instead of printing it, highlight it (the sheet tab), and after stepping
through the entire sheet, perform the print operation.

That way it only makes one compiled printout that only needs one pdf.

 

[Archimedes' Lever]

On Tue, 07 Apr 2009 17:57:02 -0500, krw <krw@att.bizzzzzzzzzzz> wrote:

On Tue, 07 Apr 2009 11:18:31 -0700, Archimedes' Lever
OneBigLever@InfiniteSeries.Org> wrote:

On Tue, 7 Apr 2009 10:03:51 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:


Teaching is the ultimate educator. Having to explain something to
another makes it sink into your own skull.

To this day I can teach Calculus and Circuit Analysis, sans book, all
I need is an outline, so I don't forget a topic ;-)



I really didn't know how to fly until I started teaching it. That's sort of
scary.

Jim


I have always contended that I could without any training.

Wings either.

Baba Ram Das -- Be Here Now

Be Now Here

Here Be Now

Now Be Here

Here Now Be

Be Here Now

Now Here Be

I guess all it would take would be about 2000 mcg a day.

 

[JosephKK]

On Sun, 5 Apr 2009 09:04:51 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

Can you post the code?

Cheers


Sure, here you go:

Sub selprint()
Dim i As Integer
Dim currentsheet As Worksheet

For i = 1 To ActiveWorkbook.Worksheets.Count
Set currentsheet = ActiveWorkbook.Worksheets(i)
Worksheets(i).Activate
'Skip empty sheets and hidden sheets
If Application.CountA(currentsheet.Cells) <> 0 And currentsheet.Visible
Then
'change the hard-coded cell here if not F52
If (Not IsNull(Range("F52"))) And (Range("F52").Value <> 0) Then
'un-comment the next line when debugging completed
' ActiveSheet.PrintOut
'add comment at start of next line when debugging completed
ActiveSheet.PrintPreview
End If
End If
Next i
End Sub


Jim

Not sure, but try an lparen "(" just after "if" and an rparen ")" just
before "then" if you would.

If you want an excel NG please setup your newsreader to _also_ point
directly at

news.microsoft.com

and pick up one there. It is read by many MS support staffers, MVPS,
and other experts.

 

[Archimedes' Lever]

On Wed, 08 Apr 2009 21:18:48 -0700, "JosephKK"<quiettechblue@yahoo.com>
wrote:

On Sun, 5 Apr 2009 09:04:51 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:


Can you post the code?

Cheers


Sure, here you go:

Sub selprint()
Dim i As Integer
Dim currentsheet As Worksheet

For i = 1 To ActiveWorkbook.Worksheets.Count
Set currentsheet = ActiveWorkbook.Worksheets(i)
Worksheets(i).Activate
'Skip empty sheets and hidden sheets
If Application.CountA(currentsheet.Cells) <> 0 And currentsheet.Visible
Then
'change the hard-coded cell here if not F52
If (Not IsNull(Range("F52"))) And (Range("F52").Value <> 0) Then
'un-comment the next line when debugging completed
' ActiveSheet.PrintOut
'add comment at start of next line when debugging completed
ActiveSheet.PrintPreview
End If
End If
Next i
End Sub


Jim


Not sure, but try an lparen "(" just after "if" and an rparen ")" just
before "then" if you would.

If you want an excel NG please setup your newsreader to _also_ point
directly at

news.microsoft.com

and pick up one there. It is read by many MS support staffers, MVPS,
and other experts.

Except that several posts have been made there already, of which none
have been answered.

 

[legg]

On Wed, 08 Apr 2009 22:31:02 -0700, Archimedes' Lever
<OneBigLever@InfiniteSeries.Org> wrote:

On Wed, 08 Apr 2009 21:18:48 -0700, "JosephKK"<quiettechblue@yahoo.com
wrote:

On Sun, 5 Apr 2009 09:04:51 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

snip

If you want an excel NG please setup your newsreader to _also_ point
directly at

news.microsoft.com

and pick up one there. It is read by many MS support staffers, MVPS,
and other experts.


Except that several posts have been made there already, of which none
have been answered.

I've seen nothing about this thread on microsoft.public.excel. Always
very active.

RL

 

[RST Engineering (jw)]

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my way
through it to understand a little bit more than when I started. Here is the
whole code and I'll annotate it with '* to indicate that it is MY annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle

I've seen nothing about this thread on microsoft.public.excel. Always
very active.

RL

 

[Jim Thompson]

On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my way
through it to understand a little bit more than when I started. Here is the
whole code and I'll annotate it with '* to indicate that it is MY annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Jim, Could you E-mail me a copy? Thanks!

...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona 85048 Skype: Contacts Only | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

I love to cook with wine Sometimes I even put it in the food

 

[Archimedes' Lever]

On Thu, 09 Apr 2009 09:51:21 -0400, legg <legg@nospam.magma.ca> wrote:

On Wed, 08 Apr 2009 22:31:02 -0700, Archimedes' Lever
OneBigLever@InfiniteSeries.Org> wrote:

On Wed, 08 Apr 2009 21:18:48 -0700, "JosephKK"<quiettechblue@yahoo.com
wrote:

On Sun, 5 Apr 2009 09:04:51 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

snip

If you want an excel NG please setup your newsreader to _also_ point
directly at

news.microsoft.com

and pick up one there. It is read by many MS support staffers, MVPS,
and other experts.


Except that several posts have been made there already, of which none
have been answered.

I've seen nothing about this thread

It has NOTHING to do with 'this thread', idiot. There have been NEW
posts made there by both me and Jim.

on microsoft.public.excel. Always
very active.

You're an idiot. That is the WRONG group, and posts made there about
programming not only do not get answered, but they get forwarded to the
programming group.

You need to learn a bit more about this BEFORE you go assuming no one
else knows anything about Usenet. You should ALSO try reading the entire
thread, dipshit, because the suggestion you made, thinking you were
helping out, has ALREADY been made by me in the thread... EARLY in the
thread. Jim posted there the very next day because he DOES read the
thread that you so casually, in Usenet retarded newbie fashion, decided
to NOT read the entire thread.

RL

I made posts there about it even before Jim did. My posts, nor his
were ever answered.

They seem to only want to answer question that involve vlookups and
extracting sub text segments from a cell's contents.

I posted in m.p.excel.worksheet.functions AND m.p.excel.programming,
which are the RIGHT places to post about this issue..

I don't give a fat flying fuck what you say "you have seen" or "have
not seen". I have watched several posts that get answered quickly,
including posted queries I have made in the past. This particular VB
problem, however, is NOT being addressed by ANY of the dopes there.

I already solved it, and posted the fixed sheet.

 

[Archimedes' Lever]

On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just like
I want it to, although it wasn't the way I was thinking about it to start
with.

Yes, it is kind of a kludge. I would liked to have made it print AFTER
running the hide routine, then return the workbook to all unhidden.

Then the save state would not be an issue.

I'd sort of like to take the code line by line and see if I can work my way
through it to understand a little bit more than when I started. Here is the
whole code and I'll annotate it with '* to indicate that it is MY annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Oops... no code got pasted in.

 

[Archimedes' Lever]

On Thu, 09 Apr 2009 10:14:01 -0700, Jim Thompson
<To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote:

On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my way
through it to understand a little bit more than when I started. Here is the
whole code and I'll annotate it with '* to indicate that it is MY annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Jim, Could you E-mail me a copy? Thanks!

...Jim Thompson

READ what he said. It is posted up in a.b.s.e, idiot.

 

[Archimedes' Lever]

On Thu, 09 Apr 2009 10:14:01 -0700, Jim Thompson
<To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote:

On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my way
through it to understand a little bit more than when I started. Here is the
whole code and I'll annotate it with '* to indicate that it is MY annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Jim, Could you E-mail me a copy? Thanks!

...Jim Thompson

Yeah, Jim... Let the Excel master have a look at it.

You know... the guy that ignored this thread for several days, because
it held no interest for him.

Bwuahahahahaha!

 

[RST Engineering (jw)]

--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle


"Jim Thompson" <To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote in
message news:l6bst49n1b7ufkfpgo1mmkl6pnmemrvlj0@4ax.com...

On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just
like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my
way
through it to understand a little bit more than when I started. Here is
the
whole code and I'll annotate it with '* to indicate that it is MY
annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Jim, Could you E-mail me a copy? Thanks!

Just the code or the annotation too? Either one you wish. I'll be back
home Sunday.


Jim

...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona 85048 Skype: Contacts Only | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

I love to cook with wine Sometimes I even put it in the food

 

[Jim Thompson]

On Thu, 9 Apr 2009 15:31:10 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

"Jim Thompson" <To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote in
message news:l6bst49n1b7ufkfpgo1mmkl6pnmemrvlj0@4ax.com...
On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just
like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my
way
through it to understand a little bit more than when I started. Here is
the
whole code and I'll annotate it with '* to indicate that it is MY
annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Jim, Could you E-mail me a copy? Thanks!

Just the code or the annotation too? Either one you wish. I'll be back
home Sunday.


Jim

With the annotation. I'm just now learning to use Excel's more
advanced features myself... trying my hand at behavioral modeling of
systems... after years of trivial use ;-)

...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona 85048 Skype: Contacts Only | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

I love to cook with wine Sometimes I even put it in the food

 

[Archimedes' Lever]

On Thu, 09 Apr 2009 15:43:03 -0700, Jim Thompson
<To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote:

With the annotation. I'm just now learning to use Excel's more
advanced features myself... trying my hand at behavioral modeling of
systems... after years of trivial use ;-)

...Jim Thompson

http://www.mininova.org/search/excel/2

Smith charts... everything.

Better get the new, modern AWESOME Office 2007 package though.

Or wait and see if there is a 2k8 release. They ARE worth it, since
they have made HUGE strides in it since the 2003 release.

 

[legg]

On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my way
through it to understand a little bit more than when I started. Here is the
whole code and I'll annotate it with '* to indicate that it is MY annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Ouch, 300,000 new headers to wade through.

RL

 

[Archimedes' Lever]

On Fri, 10 Apr 2009 00:42:02 -0400, legg <legg@nospam.magma.ca> wrote:

On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my way
through it to understand a little bit more than when I started. Here is the
whole code and I'll annotate it with '* to indicate that it is MY annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Ouch, 300,000 new headers to wade through.

RL

Only need to sort by date and look at (search through)the top 200 or so.

Jeez. does every computer user in the world need their hand held OVER
and OVER again to understand basic maneuvers on a PC?

I ALWAYS view my news headers by date. I NEVER nest the articles
except WHILE I am reading a post in one, and want to look at the whole
thread.

When I pull ALL headers in a group I have not been in for a while or a
new group I have added, I either SAMPLE SOME of the headers or grab them
all, and DELETEall before a certain date.

 

[T]

In article <g7ust4l3pk18n6inj0gl744gbcp6j83dng@4ax.com>, To-Email-Use-
The-Envelope-Icon@My-Web-Site.com says...

On Thu, 9 Apr 2009 15:31:10 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

"Jim Thompson" <To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote in
message news:l6bst49n1b7ufkfpgo1mmkl6pnmemrvlj0@4ax.com...
On Thu, 9 Apr 2009 08:32:07 -0700, "RST Engineering \(jw\)"
jim@rstengineering.com> wrote:

I posted to microsoft.public.excel.programming and
microsoft.public.excel.worksheet.functions without getting a single
response. However, Archimedes posted me code yesterday that works just
like
I want it to, although it wasn't the way I was thinking about it to start
with.

I'd sort of like to take the code line by line and see if I can work my
way
through it to understand a little bit more than when I started. Here is
the
whole code and I'll annotate it with '* to indicate that it is MY
annotation
and not the author's. I'll do that over in the newsgroup
microsoft.public.excel.programming. Thanks to all for the help.

Jim, Could you E-mail me a copy? Thanks!

Just the code or the annotation too? Either one you wish. I'll be back
home Sunday.


Jim

With the annotation. I'm just now learning to use Excel's more
advanced features myself... trying my hand at behavioral modeling of
systems... after years of trivial use ;-)

...Jim Thompson

The power of all Microsoft Office applications is their VBA interface.
It essentially is Visual BASIC, pretty easy. They did throw a slight
curve ball going from 2000 to 2007 but the references are now ! instead
of . noted.