2 мар. 2020 г. · I want to open a workbook (name = test.xlsx) which is saved in a specific path (C:\Users\u16086\Desktop\Folder) in my PC with a VBA code.

24 мая 2017 г. · To find out if a workbook is open, you can use a function for that purpose, which takes advantage of the "On Error" statement.

12 янв. 2018 г. · The Open command functions correctly - it opens the "filePath" file like it's supposed to - but wbkHelper ends up pointing to the completely wrong file.

24 мая 2017 г. · If you have a copy of the workbook open (in a different folder) with the same name as the one your VBA is trying to open, it fails silently.

10 мая 2011 г. · Try using ThisWorkbook.Path to make an absolute path. It returns the folder path of the workbook running the macro (excluding the filename).

15 мая 2018 г. · You can just use GetObject to get a reference to the Excel application running it, and then iterate the workbook collection.

13 апр. 2022 г. · The workbook that I am trying to open is on our SharePoint site. When it opens, it's still in read-only mode, even though I have ReadOnly:=False.

20 февр. 2024 г. · If the workbook is opened, Set wb = Workbooks(FilePath) gets the object reference, otherwise open it with Set wb = Workbooks.

28 авг. 2018 г. · I'd recommend looking into Workbook.Open() function and Workbooks collection object, which returns a collection (something like an array) of all the currently ...

7 сент. 2016 г. · I'm having a really hard time opening a workbook in VBA. This line of code gives me a type mismatch. path is a String and I am 100% sure it is valid.