Hi,
Not working for me but I am using below code
library (RDCOMClient)
library(readxl)
xlApp <- COMCreate("Excel.Application")
xlWbk_path <- Sys.glob("C:\\Users\\....\\.....\\...\\*.xlsm", dirmark = FALSE)
xlWbk <- xlApp$Workbooks()$Open(xlWbk_path[1])
xlApp[['Visible']] <- TRUE
xlApp$Run("Extract")
now after xlApp$Run("Extract") it opens up window to save output file to local machine, this part I want to mange from R of saving file.
