Hello, Im am tryinig to open a form (wich resides in an excel file) using a vb script located in the desktop, here is the code:
It can open the file, but itīs unable to open the form, displaying a message wich says that there is a missing object call UserForm4 (UserForm4 is the name of the form in excel file), the error code is 800A01A08
Please Login or Register to view this content.
Last edited by Anitaelo88; 07-31-2015 at 10:27 PM. Reason: Wrong format
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi -
In your workbook, create a module like this
in your userform4 query_closePlease Login or Register to view this content.
save your excel filePlease Login or Register to view this content.
and in VBS
Please Login or Register to view this content.
event
Thank you very much, it works perfectly.
Hi -
You're welcome.
Please have time to read how to close your thread
Click a little star at the left bottom of my post if you're satisfied with the solution.Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.
event
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks