Outputting my mouldings to Excel ?

Software related questions, and
suggestions for new features or improvements.
Post Reply
User avatar
Bagpuss
Posts: 846
Joined: Wed 18 Jun, 2008 12:59 pm
Location: Upminster, ESSEX, UK
Organisation: Adam The Picture Framer
Interests: TBA
Contact:

Outputting my mouldings to Excel ?

Post by Bagpuss »

I've never done this before and I'm not too sure I can now, all I want to do is get a list of all my Mouldings, about 250 or so into Excel, can anyone give me some pointers ? I couldn't see anything in the Help file.
thanks in advance,
Adam/Bagpuss
My real name is Adam Laver aka "Adam The Picture Framer", just in case you were unsure ; )
User avatar
JohnMcafee
Posts: 1145
Joined: Sun 10 Oct, 2010 9:58 am
Location: Belfast
Organisation: Scenes
Interests: Picture Framing
Putting the world to rights
Location: Belfast
Contact:

Re: Outputting my mouldings to Excel ?

Post by JohnMcafee »

I think that this is an Excel question rather than an EstLite one.

EstLite automatically consolidates all of your suppliers' lists internally, though you must turn this feature on (Options/Mouldings/Moulding Tables Used/All Suppliers).
"A little learning is a dangerous thing"

(Also known as John, the current forum administrator)
User avatar
Bagpuss
Posts: 846
Joined: Wed 18 Jun, 2008 12:59 pm
Location: Upminster, ESSEX, UK
Organisation: Adam The Picture Framer
Interests: TBA
Contact:

Re: Outputting my mouldings to Excel ?

Post by Bagpuss »

JohnMcafee wrote:I think that this is an Excel question rather than an EstLite one.

EstLite automatically consolidates all of your suppliers' lists internally, though you must turn this feature on (Options/Mouldings/Moulding Tables Used/All Suppliers).
Actually, Excel would be great but I'd make do with a printed off list from EstLite on a few sheets of A4, I can't even work out how to do that :sweating: My mouldings are kept in one of these big sea containers a mile away, I want a list of my mouldings to take over there to check stock.
thanks,
Adam
My real name is Adam Laver aka "Adam The Picture Framer", just in case you were unsure ; )
User avatar
JohnMcafee
Posts: 1145
Joined: Sun 10 Oct, 2010 9:58 am
Location: Belfast
Organisation: Scenes
Interests: Picture Framing
Putting the world to rights
Location: Belfast
Contact:

Re: Outputting my mouldings to Excel ?

Post by JohnMcafee »

Why the quote, Adam?

Have you tried clicking on "Print List" in the Stocked Moulding screen?
"A little learning is a dangerous thing"

(Also known as John, the current forum administrator)
User avatar
Bagpuss
Posts: 846
Joined: Wed 18 Jun, 2008 12:59 pm
Location: Upminster, ESSEX, UK
Organisation: Adam The Picture Framer
Interests: TBA
Contact:

Re: Outputting my mouldings to Excel ?

Post by Bagpuss »

thanks John
My real name is Adam Laver aka "Adam The Picture Framer", just in case you were unsure ; )
User avatar
Steve N
Posts: 2992
Joined: Sat 21 Jul, 2007 2:32 pm
Location: Somewhere Staple Hill Bristol
Organisation: Frontier Picture Frames ltd
Interests: Walking our retired Greyhound,art, falling asleep on sofa in front of the telly
Location: Now in Bristol
Contact:

Re: Outputting my mouldings to Excel ?

Post by Steve N »

Hi Adam
On your computer, go to My Computer -- Local Disk -- Progam Files -- open Est file -- open EstData file --then open Mouldings file, you then see your mouldings files as Excel files, these will open in Excel, then you can print them off
What I have done, I have kept these files on an external hard disk as my master files, I work on these files, like adding more mouldings, after you have saved these files as csv files, you just drag them over EstLit interface on the screen, you are then asked if you want to add that file, click OK , and they are added and your mouldings are updated.

Hope this helps

Steve
Steve CEO GCF (020)
Believed in Time Travel since 2035

Proud to sell Ready Made Frames
http://www.frontierpictureframes.com
http://www.designerpicturemounts.com/
User avatar
Bagpuss
Posts: 846
Joined: Wed 18 Jun, 2008 12:59 pm
Location: Upminster, ESSEX, UK
Organisation: Adam The Picture Framer
Interests: TBA
Contact:

Re: Outputting my mouldings to Excel ?

Post by Bagpuss »

This is exactly what I wanted Steve, thanks ever so much. :clap:
My real name is Adam Laver aka "Adam The Picture Framer", just in case you were unsure ; )
Post Reply