Function Error in Excel When Running Macro using Qlikview

Wed, 07 Jul 2010 15:13:41 GMT

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.

topic Function Error in Excel When Running Macro using Qlikview in QlikView

Function Error in Excel When Running Macro using Qlikview