Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Urban Salvaged Hardwood Slabs, Milled In-House from Rare Trees. Shop Unique Walnut Stock.

OT/ Excel questions...

Posts

OT/ Excel questions...

#1

OT/ Excel questions...

Ralph Turney

>Hey all,

I'm try to do something here at work and the first place I thought of to ask a technical question, was on WoodCentral...go figure.

Anyway, here's what I'm trying to accomplish. First of all, what I do is I design playgrounds and the equipment (big play structures you see at schools and in city parks) in them, maybe as many as 10 a day. So over the past few years I've got thousands of files in a wide range of prices and sizes. I'm attempting to make it easier for the sales force here to find drawings that I've done in the past in defined price ranges. That way we don't have to re-invent the wheel every day.

My plan is to use Excel to have columns of set price ranges, since most of the time a customer has a certain budget and we, of course, want to us all of it. :-) So the salesman would first look at the column within his price range and then be able to see a thumbnail of the particular project to see if it is the type of structure the customer is interested in.

Here's the nub of it. I know how to link to the PowerPoint file, but they can be big and that takes time to bring them up, so is there a quick (simple) way to display, or even link, to just a thumbnail of the PP file in an Excel row???

TIA

Ralph


img

Re: OT/ Excel questions...

#2

Re: OT/ Excel questions...

Frank C.

>An even better solution to your problem would be an Access database. This would be a simple database and would give you much greater flexibility.

Re: OT/ Excel questions...

#3

Re: OT/ Excel questions...

Ralph Turney

>Yeah, I know that, but we have access to Excel and not Access. Looks like I'll have to settle with a hyper links to the PP files. Thanks!

Re: OT/ Excel questions...

#4

Re: OT/ Excel questions...

Curly Smith

>Is there any reason that you can't use one of the many programs that create thumbnails from ppt files? Your drawings should be static, but if you do change something then simply overwrite the old thumbnail.

But, if you need dynamic linking, this article tells you what you need to know

Microsoft Office Thumbnails in SharePoint