Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ecel:create a file name from data in worksheet
I wish to extract data from several workbooks that are created every day.
The daily workbooks have a common eliment in their file names Eg. On the 1st of june the file names would be :- ABC 010607 def 010607 on the 2nd of june the file names would be:- ABC 020607 def 020607 I wish to create ao spread sheet that I cancreate the file name:- ABC+"010607" def+"010607" The next day I would just have to update the +"******" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ecel:create a file name from data in worksheet
this should give you some ideas...........
dim sFileName as string dim sPath as string dim dDate as date dim sDate as string sFileName = "ABC" sPath = "Z:\Susan\My Documents\DANC Rehab 2005\" '<---- change to your path set dDate = format( xxxxx, "ddmmyy") ' xxxx = wherever the date is set in the workbook ' you could just set a hidden cell with =today() ' and reference that Workbooks.SaveAs Filename:=sPath & sFileName & dDate & ".xls" untested - might have minor bugs to be worked out. hope it helps! susan On Jun 3, 2:48 pm, carter30 wrote: I wish to extract data from several workbooks that are created every day. The daily workbooks have a common eliment in their file names Eg. On the 1st of june the file names would be :- ABC 010607 def 010607 on the 2nd of june the file names would be:- ABC 020607 def 020607 I wish to create ao spread sheet that I cancreate the file name:- ABC+"010607" def+"010607" The next day I would just have to update the +"******" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
create 50 copies of a worksheet in the same file | Excel Worksheet Functions | |||
How do I create a new worksheet for a subset of data | Excel Discussion (Misc queries) | |||
how do i create and save a new file or worksheet autmatically ever | Excel Discussion (Misc queries) |