Function Error in Excel When Running Macro using Qlikview
Hi,
I'm currently have SR3 on my system. I am running a macro using the VBS Edit Module. My code is as follows:
Sub GetInfo
dim ObjName
dim ObjCaption
set XLApp = CreateObject("Excel.Application") ' Define Object
XLApp.Visible = True 'Visible set as true
set XLDoc = XLApp.Workbooks.Open("\\iodine\Treasury\Sup\Trx\Share\PrimeBroker\Prime Broker Live\Accounting\P&L\Overnight\P&L_Overnight.xls") 'Open new workbook
xlApp.Run "GetSMARTInfo"
set XLApp = nothing
set XLDoc = nothing
End Sub
In the GetSMART info macro in excel, I am referencing a excel's WorkDay formula to calculate the date I want to run the file for. The problem is that when Qlikview opens up the excel file, it does not recognize this formula and in the cell (the cell has a #value in it) and the macro cannot run any further. However if I open up the excel file myself the formula calculates date correctly.
