Auto Generate Save As Filename?

KP4U · General User Joined: 06 Sep 2005 Posts: 29

Hello, I'm a shipper/receiver and I fill out all my packing slips with Calc document. Basically I open a document template, fill out the recipients name, address, date and then the products and quantities. Every time I select "Save As" I have to enter the customer name and date. I was wondering if there was a way to auto generate the filename in the Save As dialog based on 1 or 2 cells in the document, like the customer name and/or date for instance. That way I could select "Save As" and hit enter and that would be it.

Any help here much appreciated. Thanks.

squenson · Posted: Fri Mar 09, 2007 12:41 pm Post subject:

KP4U,

I suggest that you have a cell in your spreadsheet that contains the name of the file, based on a combination of customer and date. For example, if the cell D7 contains the customer name, you could create in any empty cell a formula like:
= "C:\Path_Of_My_Files\" & D7 & TEXT(NOW();"yyyymmdd") & ".ods"

Now, just before saving your file, select this cell, press CTRL+C (or right click in the cell and copy), click on File, Save As, and press CTRL+V (or right click in the file name box and paste), then press ENTER button. This way, you do not have to retype all the characters of the name.

You could also create a macro associated with a button that does that, but it will require slightly more time to develop and test, and the additional time saving will be marginal.

Hope this help,
Stephane Quenson.

Villeroy · Posted: Fri Mar 09, 2007 1:06 pm Post subject:

MrBill1028 · Posted: Sun Jan 04, 2009 8:21 am Post subject:

I'm confused as to what the "MyPath " cell is supose to contain? I entered "V10" the cell that I put the hyperlink in in my document but it gets down to the statement "else" and comes back with an errror "variable not defined"? Were do you enter the Variable or what am I missing?
_________________
Rank Amateur Willing To Learn

Villeroy · Posted: Sat Mar 28, 2009 10:45 am Post subject:

MrBill1028 · Posted: Sun Mar 29, 2009 8:33 am Post subject:

John: Thank-you for your response. I finally figured out (after many months) where to create the "MyPath" named Range. I guess if I'd searched for Ooo for Naming Ranges I would have found it soon (da) You are great and I would like to THANK-YOU for all of your help. My project is now complete and is saving alot of time.
_________________
Rank Amateur Willing To Learn

blindvic · Posted: Thu Apr 16, 2009 10:53 pm Post subject:

So, there is no way to set a default name for the newly created document, if i created the document by a macro and i don't want macro in the document?

Villeroy · Posted: Fri Apr 17, 2009 12:20 am Post subject:

blindvic · Posted: Tue Apr 21, 2009 1:21 am Post subject:

I think we must introduce a new parameter when creating a document through a macro - "default_filename" or something like this. But i don't think it will be implemented in next several years taking into consideration how the work is going on.
Sad