Hi All,
I have an Excel document that has a series of class modules in it that I'd like to have other workbooks hook into to use? I have tried to save it as a .xlam and then add a reference to it in the calling workbooks, but when I try to write code to access the class it does not seem to be...
In testing the 2007 version of Excel, I'm running into quite a bit of trouble with performance as it relates to executing VBA code. On numerous lines of code that didn't give any trouble in 2003, we're seeing a small timer bar appear with the caption "Cell (Press ESC to Cancel)" -- using the...
Is it possible to assign a range in Excel to a DAO recordset? I have found a means of assinging a range to an ADO recordset, but the searching capabilities of ADO recordsets is not the greatest. I would like to be able to use the FindFirst methods and such that DAO offers. Any help you can...
We have a number of "automations" built into Excel documents using VBA that are used frequently in our business. Recently, a couple of our users have been getting a message box popping up on them when attempting to run the macros. It states "Code execution has been interrupted" as if someone...
Does anyone know of a functionality in Excel or a plug in that would allow Excel to interact with a GUI application's user interface? I'm aware of applications that can interact with the objects on a GUI interface (like IBM Rational Functional Tester), but can't determine if I can get Excel to...
I have several Excel spreadsheets that have code sitting behind them. In some of these spreadsheets, user forms are shown to prompt user's for info that the spreadsheets need. The problem I'm experiencing is that, on rare occasions, when the .show line is executed, not only does the form...
Hi all,
I have created an automation in Excel that interacts with Attachmate and I'm able to send text and commands without issues. However, when I use the GetString method to pull text from the screen, it's coming back as a series of unintelligible symbols. Does anyone know why this would be...
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.