| Thread | Last Post | Replies |
|
| calling a shared lib from VBA in Excel | 26 Feb 2007 10:00 GMT | 8 |
Hi I'm attempting to call a function in a shared library from a VBA macro in excel. This is a typical c function: extern "C" bool SetBootstraps(int nBootstraps) In VBA I have it declared as:
|
| case sensitivity check for List values | 26 Feb 2007 09:18 GMT | 1 |
i have a list of values something like this.. "Priority"----this is the header. Blocking High
|
| scanner twain | 26 Feb 2007 08:47 GMT | 2 |
my problem is acquire an image from a twain device when the user click on a button located on a sheet. Is there a way to do it, possibly without installing activex ? Thank you.
|
| Printer Paper Source Setup | 26 Feb 2007 08:14 GMT | 1 |
Hi, I've gathered through some searching that there's no simple method in VBA to set the desired printer tray programatically prior to printing a job through a macro, then setting the printer back to it's default tray. I tried building a VB (Visual Studio 2005) app separately ...
|
| exclude from print area | 26 Feb 2007 07:16 GMT | 4 |
I want to print a page but I don't want the cell that has the price in it to print. (But I still want to see it electronically). Anyone know how to exclude a single cell from in the middle of a print area selection?
|
| list separator | 26 Feb 2007 07:00 GMT | 1 |
To all, A question of understanding: We have an application that generates .csv files, the delimiter is determined by the locale of the user by reading their regional
|
| Where can I find Excel 2007 type library | 26 Feb 2007 05:07 GMT | 2 |
I have created an addin for excel application. I use mso9.dll and excel9.olb for automation purpose. I use the function "SaveAs" of "Workbook" object. But it fails in case of Excel 2007 because syntax for this function has been
|
| New Group in Menu | 26 Feb 2007 04:47 GMT | 5 |
What would be the command to add a "Begin Group" (seperator) in a menu? Thank you. Eric
|
| totalling dates | 26 Feb 2007 04:26 GMT | 3 |
How could i count the number of identical dates in a column ? Thanks in advance. Rgds, Msh.
|
| macro to print workbook | 26 Feb 2007 04:17 GMT | 4 |
Can anyone help me with a macro to print a whole workbook?
|
| programming a button | 26 Feb 2007 03:56 GMT | 2 |
I created a macro that will select specific columns on different sheets and sort them, and it works fine. I want to create a command button that will do the same thing, I copied the code from the macro and put into the button and I get an error when it tries to select the columns ...
|
| How to validate that input was entered into Input Box | 26 Feb 2007 03:40 GMT | 6 |
I have 3 input boxes that requests an amount, a Clerk number, and a Text Note:
ActiveCell = InputBox("Amount?")
|
| Looking for DMEDIAN | 26 Feb 2007 03:06 GMT | 8 |
I'm working with an dynamically defined, continous block of cells. The requestor doesn't want to weed out or filter out unwanted records, they fit a criteria. So I will have to use the domain aggregate functions DAVERAGE, DSTDEV etc... However, there is no DMEDIAN. Any
|
| change event; return focus to original textbox | 26 Feb 2007 02:57 GMT | 3 |
I have a user form (i.e. frmGrade) that has a number of text boxes in it (i.e. properties window/name = txtExpDesignA, txtExpDesignB, txtExpDesignC...). The text boxes are set to 0 (i.e. properties winow/ value = 0) and the textboxes can take on a value between 0 and 5. I'm
|
| urgent-looping through data validation list then printing as per each value | 26 Feb 2007 02:18 GMT | 3 |
Hey all, I feel like this is a simple issue but am trying to get my head around using VBA. I need a code that loops thorugh a data validation list and as it
|