This is about excel vba 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…
Space formatting
Hello, I am trying to format the spacing for my references list so that each entry is single-spaced but it is double-spaced between entries. Eunice
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
When will Microsoft fix the Mac Office CreateObject problem
When you try to use Mac Word VBA to automate Excel, there is a problem because when you use Dim xapp As Object Set xapp = CreateObject(-Excel.Application-) *NB, I had to use a - instead of a double quotation mark because your web interface…