Hi
I have a workbook that I want to reopen. I use the following code:
Workbooks.Open ThisWorkbook.FullName
It reopens the workbook, but I get an application-defined or object-defined error when it opens.
I can't figure out why I get this error. Can anyone help me with this problem?
Hi, Duzze5,
could you please explain what you are after (why do you want to reopen the workbook with the code)?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holger
I just want to reopen the workbook without getting any error.
It is because I have a custom ribbon. It can sometimes loose the ribbonID. When it looses the ID, the easiest and most reliable way
to regain it, is to reopen the workbook. As it is right now I get the application-defined or object-defined error when it reopens.
Hi
Duzze5
Hi, Duzze5,
maybe losing the state of the global IRibbonUI ribbon object with the workbook or links provided may help with that problem.
Ciao,
Holger
I used to use that solution, but there is a problem with it, that can make Excel crash. It is not very reliable. There is another way to, where you use an add-in to
handle the RibbonID if it is lost. But the easiest way is two reopen the workbook. An alternative solution, but great and quick
Hi, Duzze5,
then maybe store a short macro in the Personal.xlsb and assign a shortcut to it?
Or pass the path and the name as parameters to this sub.
Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks