Dean,
Thanks for yr prompt reply.
It was a error message with title 'Action Failed', and body showing following info :
Macro Name : Autoexec
Condition : True
Action Name :RunCode
Argument : Cur_Users
A Halt button on the left. When this button is clicked, a 2nd error message is shown 'Execution...
We are trying to migrate our MS Access 2000 applications (mdb) from OS WIN2000 to WIN XP, but encounter the Halt message when running the Autoexec macro. Strange is that this only happen to one of the applications, the rest were OK.
Anyone can help ?
I faced the same problem before. Chart appears on development PC, but not on a user's PC. Later, I found that I hv missed out the file Pg32conv.dll. Hope this help.
I need to launch the Excel application within my program and then hide all the toolbars in Excel so that users cannot do the saving themselves. I manage to hide the Menu bar. And I can disable all toolbars first before Excel is launch, but users can use the mouse rightclick to make the other...
I hv posted a thread before on this, the reply works for Excel ToolBars, but I need also to hide the Excel "Menu Bar" using VB codes (i.e. the File, Edit, Format,....Help) ? My users are only allow to close the Excel application and then return to my program and nothing else. I need...
sdraper,
Thanks for yr prompt reply.
For the Open and BeforeClose events, u are refering to the VB Editor in Excel, am I right?
Anyway, I tried putting the function CBToolbarShow in my VB program, somehow it is working. But this is for toolbar only. How can I hide the Excel Menu Bar in my VB...
I need to develop an application using VB, and within my program call up an existing Excel sheet to allow user to do entry. Afterwhich the control need to pass back from Excel application to my VB program to do authentication and then my program will save the Excel file to another file name...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.