Search results for query: *

Anyone know the best method to filter the Worksheet_Calculate event such that code is executed only when the cell values of a certain range have changed, i.e. been re-calculated? I noticed that no Target range is passed to this event function; so, I cannot find the range by the same method...

How best can I escape an endless (infinte) series of worksheet_change events? Is there and FAQ, or does anyone have any suggestions? Thanks! Details: I am using the worksheet change event to trigger a calculation when a user types in a value in a certain cell. However, as the last step of...

I have a series of cells that contain calls to a VBA function. This function in turn calls a dll. There are times when I do not want this function to call the dll, but to just want the function to return the present value in the cell. Using the debugger, I've noticed that by the time the...

What is the preferred way to anchor an Excel Chart to a named range or other position in a worksheet. I've got some code that generates a chart and locates it on the worksheet. But some time later when I've added more rows above where the chart is generated, the next time I generate the chart...

I've got an Excel workbook that does some complicated calculations involving VBA and has alot of named ranges, VBA code, and Control objects such as command buttons, comboboxes, etc. All of a sudden none of the worksheets will allow me to insert a ComboBox or any other control. This is greatly...

I've got an Excel workbook that does some complicated calculations involving VBA and has alot of named ranges, VBA code, and Control objects such as command buttons, comboboxes, etc. All of a sudden none of the worksheets will allow me to insert a ComboBox or any other control. This is greatly...

Taking a risk being stupid, I'll ask the following. In Visio, I have a very small user form, only contains a textbox. After the user enters a number they want to press the ENTER key to do some stuff with the number, i.e. run some VBA code that reads textbox.text and processes the number. I've...

I am automating Excel through Visio. In one instance I want a button in Visio to bring a certain Excel worksheet to the front. I've gotten this to work fine as long as Excel is not minimized to the task bar, i.e. it works if Excel is currently displaying as a window. However, the user may have...

I am trying to add a menu item to Visio's menu bar. I want to create it as the document opens and then delete as the document closes. I have successfully created the menu item with the below sub. However when I call this sub from Visio's document_documentOpen routine the menu item is created...

I need to call a VB dll from, of all things, a REXX program. It has been pointed out to me that using the Dependency Walker on my newly made DLL indicates that the functions of interest have not been EXPOSED. It is for certain that I do not see them in the Dependency Walker even though they are...

I wish to call a VB dll from rexx. I've tried rxfuncadd, but seem to be missing something. The error message indicates that the dll was found, but not the function. A friend suggested using the Dependency Walker to see what the VB dll had exposed, and sure enough the function was not exposed...

I have an application capable of creating an XML string representing worksheet data. I would like to load this data into a pre-existing Excel workbook / worksheet. Is there a good way of doing this? Without using VBA? That is easy on the CPU time - no file IO? I could write a VB dll where my...

Can a macro be sent / loaded into Excel? We have an application that sends a string to a client's workbook. I have written a VBA macro for the client's workbook that processes the string and loads the data into a worksheet. The problem is that the client's workbook must have this macro to make...

I am passing alot of data to a VBA routine as a delimited string, then I parse it into an array, and finally enter the data into a worksheet. The string may parse into an array of 1000 to 2000 rows and 100 columns. I realize that I could move the data from the array into the worksheet through...

I having difficulty doing a VBA Group command on 3 Visio Shapes. What I want to do is group the 3 shapes and name the resulting group "tkgroup1". I can successfully group the objects with the below code, but can't get a handle on the group to change its name to "tkgroup1. Help would be...

I'm trying to manipulate some Visio bar charts with VBA. Specifically, I need to change the height of the bars. Does anyone know where I might get started. Any forums that routinely discuss this type of thing? Thanks! -Mike

I'm new to TkTcl and am looking for a Date Picker. If anyone has advice on where I might begin to find one at this website or another, please let me know. TekTips has been a great place for me in the past with VB development. So, I thought I'd try the TkTcl forum. Thanks! Sincerly, Mike Vest

I need to understand the parameters passed to the Excel Sort function when called by VBA. If I use my object viewer and find Sort as a member of Range, I get the following list of parameters. Function Sort([Key1], [Order1 As XlSortOrder = xlAscending], [Key2], [Type], [Order2 As...

When a customer has several workbooks open, one being mine. I would like to force my entire workbook to recalculate without causing the customer's other workbooks to recalculate. Unfortunately, toggling between Excel.Application.Calculation = xlCalculationAutomatic and...

I am using Outlook Redemption to autmatically send emails on a Windows XP machine with Outlook 2002 (Exchange Server). Of course this is being done to avoid the security patch. Via using the examples on their website www.dimastr.com I've been able to do most of what I want, but I have not...