Create Excel Macro with NAV automation

Hi,

I have an excel sheet with dates on the x-axis. I have to build a macro to jump to the current date (TODAY) when excel opens. The current date is alwas in cell CO7 - This is fixed. The excel sheet is created by a batch process. NAV does not open the excel sheet, but the user.

I tried the following - I created this macro in Excel and copied it to NAV. In Excel it worked perfecty.

SetMakro()
XLApplication.RecordMacro('Sub JumptoToday()'+'\'+
' Range("CO7").Select'+'\'+
'End Sub');

Can someone please help me?

Best regards!
Gregor