I suppose it's a really simple task, but I tried to search and could't find in help.
I'm in VBA PPT and I want to open a workbook to get data from it, and then close it.
Here's what I have to open the workbook, but the problem is that I don't want to see the message telling me to enable macros and the Excel workbook, I want it to run in background.Code:Set wbExcel = appExcel.Workbooks.Open(path)
I read somewhere about WithWindow:=msoFalse but that didn't work since it's a workbook.




Reply With Quote