Discussion Board for collaboration related to QlikView App Development.
I have a macro that open a excel file to export there graphs.
set XLApp = CreateObject("Excel.Application")
set XLDOC = XLApp.Workbooks.Open ("C:\QV\360.xlsx")
I would like to knwo if possile to verify if the file is already open and not open it again.
this is what is happening now, macro open the file as read only.
I just need that macro will choose this file in case it's already open
This is totally not related to qlikview so you might have more luck searching for an answer elsewhere. Perhaps this page helps: https://support.microsoft.com/en-us/kb/153058
sub test set XLApp = CreateObject("Excel.Application") set XLDOC = XLApp.Workbooks.Open ("C:\Tasks\1.xlsx") IF XLApp.ActiveWorkbook.ReadOnly THEN MSGBOX "READ_ONLY MODE" XLApp.Quit END IF end sub
it's a macro in qlikview that open an excel file
THANKS FOR YOUR HELP