50 replies to this topic

[ross549]

Getting my hands on a copy is not the problem. Getting it installed onto our network is the problem. We'd also have to make sure the person in charge of this data could maintain it after I transfer, and he is in California.

In short, Visio is not authorized on our network, so I could not put it onto a computer.

I wish it was possible.

Adam

[Temmu]

sigh.
well... how is your project coming along?
did you give any thought to the 2 pages of 11 x 17 idea?

rsvp

[ross549]

I played around with it today. I was able to group the whole mess and scale it.

I started going to the billion or so text blocks that i have to change font size in. I think I got maybe 1/20 the way through before stopping. I think I spent almost two hours on it today.

Adam

[Tushman]

I started going to the billion or so text blocks that i have to change font size in. I think I got maybe 1/20 the way through before stopping. I think I spent almost two hours on it today.

Adam

Why didn't you tell me you have such a large number of text boxes?  Reducing the font (en masse) for all those text boxes can be achieved easily with VBA.  The issue is how tiny the fonts needs to be shrunk.  The VBA macro cannot make some some text boxes 1 size and another group of boxes another unless there is some distinguishing feature/aspect.  However writing up a VBA to make ALL of them a specific size is easy enough to do.  Post back if you need such help.  I can have something ready for you by the end of Friday or Saturday.

I would need the following:
1. version of word you're using
2. font name used in those text boxes.
3. the size you need them changed to.

Edited by Tushman, 27 January 2012 - 03:22 AM.

[ross549]

The text labels are a variety of sizes. I am shrinking them down to a size that works for its particular location.

[Temmu]

that. is. awful.
may your coffee cup always be full, and your forehead only strike your gel wrist rest.

[ross549]

Yep. It sure is awful. This should have never been made in MS Word. It is making my life (at least the time I work on it) painful.

Tushman, thanks for the offer to help with the script. I wish I could take you up on your offer, but the job simply has too many variables.

Adam

[Urmas]

It is making my life (at least the time I work on it) painful.

You need LOTS of coffee... and a project mug:

[LilBambi]

You need LOTS of coffee... and a project mug:

[Temmu]

excel.

maybe start from scratch in excel.
i do a lot of illustrated work in that.

ps
lol at the mug!

Edited by Temmu, 31 January 2012 - 04:37 PM.

[ross549]

I think trying to do this in excel would be equivalent to shooting a nail into my skull.

Adam

[Temmu]

oh, sorry. ... just a thot.

[ross549]

[Temmu]

so, how did this nightmare end, or did it??

[Temmu]

bump

[ross549]

This project has been on the back burner for some time. I have had other things come up at work that I needed to take care of. This was a "good if we can" kind of thing.

Adam

[Corrine]

I've seen those "good if we can" projects that all of a sudden the boss wants to know why in the heck it isn't finished yet.

[ross549]

I know what you mean.  

Fortunately, the boss is generally not aware that this project is even possible.

Adam

[LilBambi]

Hopefully you don't have work buddies here!

[ross549]

I doubt it.

[Temmu]

yes, ross549, i've got piles of those that thankfully have slid off into oblivion!

[ross549]

Tushman, on 18 January 2012 - 05:06 PM, said:

Update to my previous post.  If you're using Word 2007/2010, the following steps will work.

With your document open, click on the Home tab.  On the far right, you'll the Editing group.



This will activate the 'select' mode within Word.  The ojective here is to "grab" as many of those objects as you can. So starting at the very top left corner (preferably somewhere within your margin area) or a blank area within your document, left click and drag your mouse cursor diagonally to the bottom corner opposite end.

Holy crap, that worked like a champ to select a whole reigon of objects!

This project is rearing its ugly head again, and I am doing something a bit different. However, that "select objects" is a lifesaver!

Once I get to moving my big diagram to the smaller page size, I will report on how quickly I can get it done.

Adam

[Temmu]

wow - and all this time has gone by...
that's the way it usually works out...
but at least you're steaming ahead and not adrift anymore...

[ross549]

Right. I have already saved several days worth of man-hours on this project already, and considering my ridiculous deadline (Friday), I am pushing ahead as quickly as possible, and should be able to finish on time.

Adam

[Temmu]

friday? who needs sleep?