will create a new folder in
W:\knowledge\Financial Reports\2003-04
called Week 24 (where myVar = 24)
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
I have come across a bit of a problem as I need to copy a workbook into this folder, but each time I create a new folder it will have a unique name, therefore I thought it would be easier to open the folder with a standard name, copy the workbook into it and then re-name it
mkdir"P:\Spreadsheet\New Folder"
filecopy "P:\Spreadsheet\Time.xls","P:\Project\NewFolder\Time.xls"
Then do the re-naming?
Otherwise How do I direct the copied workbook to the right folder when I have just given it a unique name?
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
did you just paste it as is ??
If not, can you please post the code you are using
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Would you mind posting the solution so that others can benefit ?
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff [blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.