Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with a name generated by cell values
Hi,
I'm building a database of customer enquiries. The macro i have writte extracts data from the user input cells and places them in a hidde sheet ready for submission to a central database via the templat wizard. What I'd like to do is, rather than having users on the network savin the file as random names, to have some control over the naming proces so that the customer's name and the date is picked up and turned int the file name. I've got as far as choosing the filename with this formula:- =CONCATENATE(Customer,"_",Date,".xls") which gives me the name. I also will have a standard path that thi tags on to on the network. Please can you tell me how to save the file based on this cell' value? Thanks Analys -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with a name generated by cell values
sPath = "C:\Myfiles\"
thisworkbook.SaveAs sPath & _ thisworkbook.worksheets("Sheet3").Range("A1").Valu e -- Regards, Tom Ogilvy "analyst " wrote in message ... Hi, I'm building a database of customer enquiries. The macro i have written extracts data from the user input cells and places them in a hidden sheet ready for submission to a central database via the template wizard. What I'd like to do is, rather than having users on the network saving the file as random names, to have some control over the naming process so that the customer's name and the date is picked up and turned into the file name. I've got as far as choosing the filename with this formula:- =CONCATENATE(Customer,"_",Date,".xls") which gives me the name. I also will have a standard path that this tags on to on the network. Please can you tell me how to save the file based on this cell's value? Thanks Analyst --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with a name generated by cell values
hi,
tested Sub Macro3() Dim doda As Range Set doda = Range("E6") Range("E6").FormulaR1C1 = "test_Delete_later" Workbooks.Add ActiveWorkbook.SaveAs Filename:="H:\CodeStuff\" & _ doda & ".xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub -----Original Message----- Hi, I'm building a database of customer enquiries. The macro i have written extracts data from the user input cells and places them in a hidden sheet ready for submission to a central database via the template wizard. What I'd like to do is, rather than having users on the network saving the file as random names, to have some control over the naming process so that the customer's name and the date is picked up and turned into the file name. I've got as far as choosing the filename with this formula:- =CONCATENATE(Customer,"_",Date,".xls") which gives me the name. I also will have a standard path that this tags on to on the network. Please can you tell me how to save the file based on this cell's value? Thanks Analyst --- Message posted from http://www.ExcelForum.com/ . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with a name generated by cell values
I was looking for the exact same info today as well.
Works perfectly. Thank -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with a name generated by cell values
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file with a name generated by cell values
Just one more thing - is there a line of code which can be inserted int
that macro that will prompt the template to send the data to th database or update the existing record -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Obtaining the minimum of values which have been generated by a for | New Users to Excel | |||
Sorting values generated by a formula... | Excel Discussion (Misc queries) | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
accumulating values generated daily | Excel Worksheet Functions | |||
Saving a file(new) using the multiple cell contents as a file name | Excel Programming |