Format Time in VBA not working correctly

[Oxil]

Hello everyone,

I have a problem which is i want to make a makro where i click and it saves a file with the date, Time and in this case a line (production).
The date and the line when it saves it is correct, but the time stays in the format text! And i tried and tried and i still cant manage to bring it to format in time... I will leave here the code, if anyone can help me i would aprreciate a lot!

Please Login or Register  to view this content.

I should say that at R5 i have the funtion =JETZT which is =NOW, and as i said it saves everything fine but the time. here is how it is saving : 34-26.05.2015-42150,5572501157

43 is the line
26.05.2015 is the date
42150,5572501157 and this is my problem...

Ah and by some reason it says compatibility mode?

Thanks in advance for the help!

[Norie]

JETZT doesn't mean anything in VBA, so it will be seen as an undeclared variable with no value.

If you just want Filename3 to be the value from R5 formatted as time try this.

Please Login or Register  to view this content.

If that's not what you want can you explain further?

[Oxil]

Thanks for the quick answer! I tried as you said but i got an error 1004?? Something about "The file could not be accessed"

Please Login or Register  to view this content.

But i get this yellow:

Please Login or Register  to view this content.

To explain better, now its 14:00 so i would like when i press the button that the file would save like 37-26.05.2015-14:00, beeing the 37 the line number, then the date and then the time. And the time should allways be diferent as the date!

Thanks in advance!

[Norie]

37-26.05.2015-14:00 isn't a valid filename due to the : in the time.

[Oxil]

Then no problem it can be 14_00 or 14.00..

[Oxil]

Sorry not to say in the other reply, but if you know any other makro that can do what i need im completely fine with that!

Thanks in advance!

[Norie]

Just replace the : with a suitable character.

Please Login or Register  to view this content.

[Oxil]

Thank You very Much, It worked like a charm!

Thanks again!