If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Save file with cell name
Hi
In cell A1 i have =cell"filename"A1 giving me the I want to run macro that will save new file with data in A1 Example. tab named wc0701. new file saved as wc0701 Any idea's regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200601/1 |
#2
|
|||
|
|||
Save file with cell name
You could just drop the formula in A1 and use the worksheet name itself.
with activesheet .parent.saveas filename:="C:\" & .name & ".xls", ...rest of options end with "Brian Thompson via OfficeKB.com" wrote: Hi In cell A1 i have =cell"filename"A1 giving me the I want to run macro that will save new file with data in A1 Example. tab named wc0701. new file saved as wc0701 Any idea's regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200601/1 -- Dave Peterson |
#3
|
|||
|
|||
Save file with cell name
Hi Dave
Sorry not understand The workbook is saved as "name" each week one tab will be formatted and then saved as the "tab name" of in my case as cell A1 owing to the formula in A1 I,m not fully ofay with VBA, however, can edit the existing macro with the correct lines Hope this makes sence brian Dave Peterson wrote: You could just drop the formula in A1 and use the worksheet name itself. with activesheet .parent.saveas filename:="C:\" & .name & ".xls", ...rest of options end with Hi In cell A1 i have =cell"filename"A1 giving me the [quoted text clipped - 5 lines] regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200601/1 |
#4
|
|||
|
|||
Save file with cell name
with activesheet
.parent.saveas filename:="C:\" & .name & ".xls", ...rest of options end with The dots in front of .parent and .name refer to the object in the previous with statement. In this case, they refer to the active sheet. So this says to use the activesheet and save the parent (the workbook that contains that activesheet) to the C:\ folder as the name of that active sheet (.name still refers to the activesheet). If you tried this and got your file saved as "NAME", then I'd bet you didn't copy|paste correctly (or changed somet stuff after). The formula: =cell("Filename",a1) returns the name of the worksheet that holds the formula. But that name can be obtained directly from the worksheet name itself. "Brian Thompson via OfficeKB.com" wrote: Hi Dave Sorry not understand The workbook is saved as "name" each week one tab will be formatted and then saved as the "tab name" of in my case as cell A1 owing to the formula in A1 I,m not fully ofay with VBA, however, can edit the existing macro with the correct lines Hope this makes sence brian Dave Peterson wrote: You could just drop the formula in A1 and use the worksheet name itself. with activesheet .parent.saveas filename:="C:\" & .name & ".xls", ...rest of options end with Hi In cell A1 i have =cell"filename"A1 giving me the [quoted text clipped - 5 lines] regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200601/1 -- Dave Peterson |
#5
|
|||
|
|||
Save file with cell name
Hi
I am not sure, hope this explains Workbook saved as Yard Summary 52 shhets in workbook, one for each week Weekly i update one sheet and copy sheet, then paste special to new sheet , format, and "save as "new sheet as per the tab name Incidentaly, I do have the cell A1 in each sheet =Cell("filename",A1) giving the tab name in the sheet Q. Is macro for the "save as" section possible? regards Dave Peterson wrote: with activesheet .parent.saveas filename:="C:\" & .name & ".xls", ...rest of options end with The dots in front of .parent and .name refer to the object in the previous with statement. In this case, they refer to the active sheet. So this says to use the activesheet and save the parent (the workbook that contains that activesheet) to the C:\ folder as the name of that active sheet (.name still refers to the activesheet). If you tried this and got your file saved as "NAME", then I'd bet you didn't copy|paste correctly (or changed somet stuff after). The formula: =cell("Filename",a1) returns the name of the worksheet that holds the formula. But that name can be obtained directly from the worksheet name itself. Hi Dave Sorry not understand [quoted text clipped - 19 lines] regards -- Message posted via http://www.officekb.com |
#6
|
|||
|
|||
Save file with cell name
I would have thought that last suggestion would have done it for you.
"Brian Thompson via OfficeKB.com" wrote: Hi I am not sure, hope this explains Workbook saved as Yard Summary 52 shhets in workbook, one for each week Weekly i update one sheet and copy sheet, then paste special to new sheet , format, and "save as "new sheet as per the tab name Incidentaly, I do have the cell A1 in each sheet =Cell("filename",A1) giving the tab name in the sheet Q. Is macro for the "save as" section possible? regards Dave Peterson wrote: with activesheet .parent.saveas filename:="C:\" & .name & ".xls", ...rest of options end with The dots in front of .parent and .name refer to the object in the previous with statement. In this case, they refer to the active sheet. So this says to use the activesheet and save the parent (the workbook that contains that activesheet) to the C:\ folder as the name of that active sheet (.name still refers to the activesheet). If you tried this and got your file saved as "NAME", then I'd bet you didn't copy|paste correctly (or changed somet stuff after). The formula: =cell("Filename",a1) returns the name of the worksheet that holds the formula. But that name can be obtained directly from the worksheet name itself. Hi Dave Sorry not understand [quoted text clipped - 19 lines] regards -- Message posted via http://www.officekb.com -- Dave Peterson |
#7
|
|||
|
|||
Save file with cell name
not knowledgable enough with command line
got error with below ..parent.saveas filename:=c:/&.week1&".xls rian Thompson wrote: Hi I am not sure, hope this explains Workbook saved as Yard Summary 52 shhets in workbook, one for each week Weekly i update one sheet and copy sheet, then paste special to new sheet , format, and "save as "new sheet as per the tab name Incidentaly, I do have the cell A1 in each sheet =Cell("filename",A1) giving the tab name in the sheet Q. Is macro for the "save as" section possible? regards with activesheet .parent.saveas filename:="C:\" & .name & ".xls", ...rest of options [quoted text clipped - 21 lines] regards -- Message posted via http://www.officekb.com |
#8
|
|||
|
|||
Save file with cell name
What's week1?
Maybe: ..parent.saveas filename:="c:\" & week1 &".xls or ..parent.saveas filename:="c:\week1.xls" What happened to using the name of the worksheet? "Brian Thompson via OfficeKB.com" wrote: not knowledgable enough with command line got error with below .parent.saveas filename:=c:/&.week1&".xls rian Thompson wrote: Hi I am not sure, hope this explains Workbook saved as Yard Summary 52 shhets in workbook, one for each week Weekly i update one sheet and copy sheet, then paste special to new sheet , format, and "save as "new sheet as per the tab name Incidentaly, I do have the cell A1 in each sheet =Cell("filename",A1) giving the tab name in the sheet Q. Is macro for the "save as" section possible? regards with activesheet .parent.saveas filename:="C:\" & .name & ".xls", ...rest of options [quoted text clipped - 21 lines] regards -- Message posted via http://www.officekb.com -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If I buy Microsoft office, will I be able to open my old files on | laurelek | General Discussions | 3 | February 13th, 2009 02:56 PM |
how do i make the music file linked to the presentation for email. | CT Cameron | Powerpoint | 15 | January 8th, 2006 04:17 AM |
Weird File Open/Save As Behavior | [email protected] | General Discussion | 0 | December 9th, 2005 02:26 AM |
Multi-User vs Client/Server | GeorgieGirl | General Discussion | 3 | June 8th, 2005 11:42 PM |
Automatically save file based on cell value | Craig | General Discussion | 0 | February 27th, 2005 10:01 PM |