"saveas" with cell data as file name?

**Eoluke** · 05-21-2013, 03:52 PM

Hello all, I am fairly new to advanced features and could use some help. I would like to automate the "save as " function with a macro. It would need to use a cell reference (any chosen cell) as the file name and save in a specified location and obviously in the xml format. It would be attached to a form button. Is this possible? I am trying to make a "one" click save and close for my employees who are not at all computer literate (not that I am all that good either).

Thanks in advance for the help
Don

**humdingaling** · 05-21-2013, 10:10 PM

just double checking.....XML format? or XLSX?

XML isnt that obvious

**Eoluke** · 05-22-2013, 07:38 AM

Sorry, the standard format unless it needs to be saved in a macro enabled format.

**JasperD** · 05-22-2013, 11:15 AM

Why do you want to bind it to a button?
You could do as follows :

Please Login or Register  to view this content.

Now if the user presses the 'save' button, it saves and closes the workbook with the name in A1 and to the path you set in the macro.
Same happens if the user presses the 'close' button ; it saves and closes the workbook.
They won't get popups asking for savenames and if they should overwrite etc.
Easiest way, no?

Please press the * below if this helps.

**Eoluke** · 05-22-2013, 12:47 PM

Thank you Jasper. I'll give that a try.

Don

**Eoluke** · 05-22-2013, 02:01 PM

Hello Jasper. I must be doing something wrong. I have a excel macro enabled template that I am using. Trying to automate the saveas function. I want to save to a folder C:\Shift Summary. I am trying to reference cell A32 as the saved file name. I tried to use the code you sent. I created a module in VB and copy and pasted. when i look in the workbook, there is no Macro assigned to it and when I close using the "X" it ask if I want to save changes. I chose yes and it closes but not where I want and Not with the new file name. It also leaves the data in the template instead of giving me a clean template after close. Am I doing something wrong?

Thanks again

Don

**humdingaling** · 05-23-2013, 02:17 AM

this code needs to be placed in "THISWORKBOOK" and not module in your spreadsheet

Please Login or Register  to view this content.

**Eoluke** · 05-23-2013, 11:48 AM

Worked great, TY so much

**arlu1201** · 05-23-2013, 12:28 PM

Eoluke,

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.