1
$\begingroup$
NETBlock[
    InstallNET[];
    excel=GetActiveCOMObject["Excel.Application"];
    excel@ActiveWorkbook@SaveAs["blahblah.xlsb"]
];

How do i pass the fileformat parameter to the netlink object SaveAs as done below in the VBA command.

ActiveWorkbook.SaveAs "blahblah.xlsb", fileformat:=50
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.