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
0
Comments