This is about excel vba question

Question

Hi sir,
I always use Getobject to get workbook data, but if the Excel file have password, how can I do?
example : test.xlsm password is "123"

folderPath = Application.ActiveWorkbook.Path
myPath = folderPath & "/test.xlsm"
Set wka = GetObject(myPath)

how to edit this???

thank you for your help.

Answer 1

Excel development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

--please don't forget to Accept as answer if the reply is helpful--