Search results for query: *

I was looking at the documentation about lostfocus event and it appears that this only appears to ActiveX type controls. Does anyone know if it is possible to get an event to trigger when a user moves the focus from one cell to another. Thanks

I have a word document which includes a table of values, and what I need to do is run a macro which will take this table of values, create an Excel chart - and publish this chart as a web page automatically. The only problem is that I have no idea where to start - can anyone provide me with any...

I am having trouble understanding why the Excel function IsDate is returning false when I am trying to read a cell which has Date formatting applied to it. Basically the program is sequentially going through a column of status' - when there is an open entry, it then looks at the corresponding...

Can anyone suggest a solution to a problem my boss has just landed on me! We have some system availability charts - which are represented as bar charts. What we would like to do is to provide a facility for someone to click on ONE of the bars, and then cause the detailed chart for that...

Could someone please suggest some code which I could use in order to send an Outlook email message from a C++ Builder program. Thanks Andy

On my spreadsheet, I have included an embedded chart - this object is the one to be used throughout the application, changes to data will be reflected by resetting the source data range on this object. But I need to check that the object exists on the sheet - otherwise I'll have to recreate it...

Can anyone suggest any code which I could add to my Excel based application in order to save the current settings for the users screen resolution - and then during part of the application close down process set the resolution back to what it was before the user entered the application. Many...

Having placed an ActiveX list box control on my Excel worksheet, I am having trouble finding out how I can determine which value was selected by the user. Can anyone provide me with some sample code of how to do this please Many thanks Andy

I am currently working on an Excel based application - which requires the user to obviously open the Excel workbook. Can anyone suggest a place for could resources telling people how to convert their office applications so that they can run via the Web? Thanks Andy

I have placed some code into the auto_activate routine within my spreadsheet, and whilst I know that the code works when I run it manually from the VBA editor - whenever I open the spreadsheet though this code is not being executed. Can anyone suggest to me some reasons why the auto_activate...

I have placed some code into the auto_activate routine within my spreadsheet, and whilst I know that the code works when I run it manually from the VBA editor - whenever I open the spreadsheet though this code is not being executed. Can anyone suggest to me some reasons why the auto_activate...

I have a spreadsheet which as the first column currently contains a date - which is the date of the Sunday of the given week. What I am looking to do is to populate a second field with the date of the Monday of the same week. I know I can do this using the DATE function within Excel, but as...

I have a spreadsheet which as the first column currently contains a date - which is the date of the Sunday of the given week. What I am looking to do is to populate a second field with the date of the Monday of the same week. I know I can do this using the DATE function within Excel, but as...

FOrgive me if this seems a stupid question, but I can't think of how to do this !! I've just been asked to record 5 pieces of information, for 5 different departments on an ongoing weekly basis. How is the best way to organise this in Excel - as I will also have to produce reports as well...

I would like to write a C++ program the purpose of which is to send an email from a shared Outlook mailbox - to a specific list of people (which may change) but the contents of the email will remain static. Could someone suggest how I could do this. Many thanks Andy PS Also how to test it at...

Could someone please answer this VERY simple question for me. What I would like to do is to assign to the contents of a cell, a count of the number of rows which exist within a spreadsheet which have data in them. I thought that I would be able to do this by using the COUNTA function - but it...

I have a program which I developed using the GNU compilers on a Linux system at home - which I expected I would be able to get to run quite readily on the AIX server at work. But not to be. Basically the program takes two parameters, one of which is a filename that is to be renamed and moved...

I need to write a C program which will test to see whether or not a file exists within a given directory or not. I know how to do this in Unix shell script (Korn) but I would appreciate it if someone could tell me how I could do something similar in C? Thanks Andy

We have just placed an order for some high end RS6000s to replace our existing Unix servers - and as part of this process we have decided to look at integrating Network Appliance Filers with these systems to act as the disk storage. These Net App Filers are a NAS device - and will be attached...

I would like to write a C++ program which will go through all the layered software on a client PC and record details of the versions of software installed on this software. I understand that the TRegistry class is around to enable this sort of task to be performed, I am just unsure as to where...