It's been a rough few days! I've read so much that it starting to
blur and run together! <lol.

Anyway, the pressures of the demands at work mean that I must find
easier ways to do things to help ease the load. I stumbled on some
pages on creating custom pulldown menus but found they were VBA-based
ones for the most part (like the menumaker file example with
downloadable file he
http://www.j-walk.com/ss/excel/tips/tip53.htm). I've not had much
success with that because although the example file is there, I just
don't know enough vb to make it work. First off, I don't need
sub-menus and I don't need as many different types of items either -
so right from there, I'm deviating a lot from the example file. I get
error messages right away.

Then I was lucky enough to stumble on to a manual way of making menus
that works like customizing toolbars, something I am extremely
familiar with: http://www.cpearson.com/excel/menus.htm

The recent problems at work mean that I need to constantly be
accessing about 20 files found on different folders on the network. I
have shortcuts to the two major ones in my QL but it's getting really
old, really fast to have to click through shortcuts elsewhere to get
to the rest. It would be easiest if all these files were available in
the menu I created called "MyDocts". I was able to add the pulldown
in a heartbet following the instructions on the above manual method
webpage, but I just can't seem to figure out how to get items onto the
menu! The terminology is confusing to me, a newbie to menu issues,
but I believe I figured out what the meanings are. From that page
above, http://www.cpearson.com/excel/menus.htm :

"The procedure for adding a new tool to a command bar is the same,
except that you should choose Custom Button rather than Custom Menu
Item from the Macros Categories list in the Customize dialog box."

I've tried choosing custom button as it says. But I guess that what I
do next is wrong. Like customizing the toolbar, we usu. just drag the
item. When I try to drag the custom icon to the new "MyDocts" menu,
all I achieve is creating another custom menu, this time with a happy
face! <lol

If I can just get the happy face one to appear as what is available
underneath the "MyDocts" menu, I'd have it made. I could then take it
from there to assign a macro to each entry. At least, that's what I'm
hoping we can do because the other VB way just is so complicated in
comparison for me.

Thanks so much!

Hi StargateFan,

The recent problems at work mean that I need to constantly be
accessing about 20 files found on different folders on the network.


That calls for this fine utility:

ftp://ftp.mcgimpsey.com/excel/workmenu.xla

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

On Fri, 11 Jun 2004 11:39:50 +0200, Jan Karel Pieterse
wrote:

Hi StargateFan,

The recent problems at work mean that I need to constantly be
accessing about 20 files found on different folders on the network.


That calls for this fine utility:

ftp://ftp.mcgimpsey.com/excel/workmenu.xla

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Excel-lent!!!! That works so beautifully.

Thanks so much!

This is such an awesome utility! It will do the job very
well. But I did get runtime errors, both at home and here
at the office. I don't remember if the runtime error was
the same at home for certain, but I think it is and it's
unlikely that 2 different OSs would necessarily call 2
different errors just because of OS, no?

The error is this:

"Run-time error '1004':

Method 'Rows' of object'_Global' failed"

And when the debugger opens, there's little yellow arrow
and this line of coding is highlighted in yellow:

" Set workRange = .Range("A2", .Range("A" &
Rows.Count).End(xlUp))"

Hopefully someone know what the problem might be.

The sheets I've added to the "Work" menu don't show up
though they are there. I know this because when I thought
it's because a book hadn't taken, I tried entering it
again and I got the msg that book was already present.

The only time the menu appears at this point is when I add
a new one. But as soon as I exit XL2K, then it won't work
again properly the next time.

Thanks so much for this! Once someone can recommend a
fix, this will work just perfectly!

:oD

-----Original Message-----
On Fri, 11 Jun 2004 11:39:50 +0200, Jan Karel Pieterse
wrote:

Hi StargateFan,

The recent problems at work mean that I need to
constantly be
accessing about 20 files found on different folders on
the network.


That calls for this fine utility:

ftp://ftp.mcgimpsey.com/excel/workmenu.xla

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Excel-lent!!!! That works so beautifully.

Thanks so much!
.

Set workRange = .Range("A2", .Range("A" & .Rows.Count).End(xlUp))
(extra period in front of the .rows.count

StargateFan wrote:

This is such an awesome utility! It will do the job very
well. But I did get runtime errors, both at home and here
at the office. I don't remember if the runtime error was
the same at home for certain, but I think it is and it's
unlikely that 2 different OSs would necessarily call 2
different errors just because of OS, no?

The error is this:

"Run-time error '1004':

Method 'Rows' of object'_Global' failed"

And when the debugger opens, there's little yellow arrow
and this line of coding is highlighted in yellow:

" Set workRange = .Range("A2", .Range("A" &
Rows.Count).End(xlUp))"

Hopefully someone know what the problem might be.

The sheets I've added to the "Work" menu don't show up
though they are there. I know this because when I thought
it's because a book hadn't taken, I tried entering it
again and I got the msg that book was already present.

The only time the menu appears at this point is when I add
a new one. But as soon as I exit XL2K, then it won't work
again properly the next time.

Thanks so much for this! Once someone can recommend a
fix, this will work just perfectly!

:oD

-----Original Message-----
On Fri, 11 Jun 2004 11:39:50 +0200, Jan Karel Pieterse
wrote:

Hi StargateFan,

The recent problems at work mean that I need to
constantly be
accessing about 20 files found on different folders on
the network.


That calls for this fine utility:

ftp://ftp.mcgimpsey.com/excel/workmenu.xla

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Excel-lent!!!! That works so beautifully.

Thanks so much!
.


--

Dave Peterson

On Fri, 11 Jun 2004 20:18:20 -0500, Dave Peterson
wrote:

Set workRange = .Range("A2", .Range("A" & .Rows.Count).End(xlUp))
(extra period in front of the .rows.count

Excellent! Phew, I was getting worried. Thought I was doing
something wrong. But then after coming home and seeing that I was
getting exactly the same thing here re the runtime error, I knew the
problem had to be in coding. No more error now!

-*-*-*-*-*-*-*

Turns out, though, that there is another glitch. I'm hoping we can
get this last thing fixed. This is a totally awesome function to have
that if this next thing can be fixed, it'll be perfect. At least,
from the looks of things now <g!

What it also doesn't do is keep the references properly. Every time I
start up Excel again, a deleted filename reference re-appears and only
the first item I added this morning appears. But I stumbled upon
something - when I choose the "delete item" from the menu and then
choose "cancel" to close the delete dialogue box, everything shows as
it should. Yet each time when I close Excel, the same thing happens
all over again. It goes back to a third state after re-installing
this add-in this morning - one file of the originals deleted, and the
first one I added in appears.

Yup, I'm about at try #10 and this still is happening. It's like the
"delete item" "cancel" forces the add-in to re-calculate/refresh
somehow because I can hear the hdd revving up each time. Then the
next time I click on the "Work" menu, it's okay and showing all the
references it should.

Sounds like to me, with my very limited knowledge of course, that
there is a "recalculation" or "refresh" code missing in there
somehwere (???).

Thanks so much for the help. I wish I could say I could live with
this glitch, but the unfortunate thing is that I close/start Excel
many times a day at the office and certainly don't keep it open all
the time here at home either. I use Excel only when I need it then
shut down. So it's not like this type of behaviour wouldn't be a
major pain! <g

Cheers!

StargateFan wrote:

This is such an awesome utility! It will do the job very
well. But I did get runtime errors, both at home and here
at the office. I don't remember if the runtime error was
the same at home for certain, but I think it is and it's
unlikely that 2 different OSs would necessarily call 2
different errors just because of OS, no?

The error is this:

"Run-time error '1004':

Method 'Rows' of object'_Global' failed"

And when the debugger opens, there's little yellow arrow
and this line of coding is highlighted in yellow:

" Set workRange = .Range("A2", .Range("A" &
Rows.Count).End(xlUp))"

Hopefully someone know what the problem might be.

The sheets I've added to the "Work" menu don't show up
though they are there. I know this because when I thought
it's because a book hadn't taken, I tried entering it
again and I got the msg that book was already present.

The only time the menu appears at this point is when I add
a new one. But as soon as I exit XL2K, then it won't work
again properly the next time.

Thanks so much for this! Once someone can recommend a
fix, this will work just perfectly!

:oD

-----Original Message-----
On Fri, 11 Jun 2004 11:39:50 +0200, Jan Karel Pieterse
wrote:

Hi StargateFan,

The recent problems at work mean that I need to
constantly be
accessing about 20 files found on different folders on
the network.


That calls for this fine utility:

ftp://ftp.mcgimpsey.com/excel/workmenu.xla

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Excel-lent!!!! That works so beautifully.

Thanks so much!
.