Excel VBA Object Required ERROR

Question

I have two lines of code that seems extremely easy, but excel keeps giving me this Compile error telling me that object is required?

So basically I want to get the current time, and replace the spaces with underscores so I can use this string as the name of my log fime.

Dim name As String

'EXCEL GIVE ME compile error: object required
name = Replace(FormatDateTime(Now, DateFormat.LONGTIME), " ", "_")

What's wrong?!!

souldzin · Accepted Answer · 2013-02-04 15:56:59Z

1

Replacing DateFormat.LONGTIME to 'vbLongTime' works for me.

name = Replace(FormatDateTime(Now, vbLongTime), " ", "_")

answered Feb 4, 2013 at 15:56

souldzin

1,48613 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vogel612 · Accepted Answer · 2013-02-04 16:05:06Z

1

You need to invoke Now as it is not a variable but a procedure

var now = str(Now());
name = Replace(FormatDateTime(now, DateFormat.LONGTIME), " ", "_")

should fix it

answered Feb 4, 2013 at 15:53

Vogel612

5,6555 gold badges53 silver badges79 bronze badges

Your suggestion throws the same error as initial Q. See the answer of @SoulDZIN - it works.