Some question about Excel .....

[MaximCh]

1.I have a book with two sheets. How can i copy from cell e.g. A1 at sheet1 all value to cell A1 at sheet2, if the last has any value copy to A2 and so on while the maros found free cell?
2.How can i create a folder which name contain the day. E.g: today it's d:~Aa_08.09.2002. tomorrow it'll be d:~Aa_09.09.2002. ?

And the last question.
3. How can I create new, or *save as* (it'll be better for me) from existing file which name i write to cell?
E.g. i enter to cell A1 the number "123456" then push the button, and the program automaticaly open file 1.xls and save it as 123456.xls ?

 

[MaximCh]

if somebody know how to solve my problem, pls help me ..

 

[rikrak]

Hi Maxim.

Question 3: take a look at a previous post http://www.mrexcel.com/board/viewtopic.php?topic=20968&forum=2

 

[rikrak]

Question 2:

Enter in cell A1 formula "today()"
Add VB code:
Sub makeFolder()
MkDir "Aa_" & [A1]
End Sub

 

[MaximCh]

Hi Rikrak !
Thank you a lot!
The one problem is solved. D'u know an answers on last two questions?

 

[MaximCh]

Questio2:
It's work if value in cell isn't a formula ...

 

[rikrak]

On 2002-09-08 12:38, MaximCh wrote:
Questio2:
It's work if value in cell isn't a formula ...

What do you mean?
You have to enter "=today()" and will show you today's date

 

[MaximCh]

ye, but when i enter VB code the progam return a mistake .... at MkDir "Aa_" & [A1]

 

[rikrak]

On 2002-09-08 12:49, MaximCh wrote:
ye, but when i enter VB code the progam return a mistake .... at MkDir "Aa_" & [A1]

Did the error appeared the first time you ran it?
Did you check if the folder was created by searching your disk on "Aa_"

When you run the macro more then once you will get an error and the code has to be changed to:
Sub test()
On Error GoTo folderAlreadyExist
MkDir "Aa_" & Range("A1").Value
folderAlreadyExist:
End Sub

 

[MaximCh]

I check all, but with formula in the cell it doesn't work If i enter simple value, such as 08/09/02 into cell A1 and run this macros all will be work ... Can i add this function (today()) into the code, without linking to the cell ?