Search results for query: *

Thanks very much Rob

Thanks for your responses, I must be being really thick. When I try and paste some of the sample code you've provided into my worksheet I can't get it to run at all - the macro name doesn't appear in the list of available macros within the worksheet, can someone suggest what I am doing wrong...

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...

Mike/Tom Sussed it. although I thought that the date values had been entered as dates, with appropriate date formatting applied - it looks as though they were entered as just text. Many, many thanks for your help on this Cheers Andy

Tom I am still unable to get the code to run successfully - so I don't know why this should work for you and not for me. The problem occurs on the 7th row of the sheet - so I don't understand what is going on. Mike, I shall email you a copy of the workbook as requested - this is starting to...

does anyone know of a way to determine what data type the contents of a cell are? The fact that I cannot get a simple program to be able to implement the DateValue function on a cell leads me to think there is something very strange about the formatting of the cells within my spreadsheets Thanks

Tom Thanks for the suggestion, but this isn't quite correct in terms of the program at the top of this posting. What happens is that there are two header rows for the spreadsheet, so basically the first iteration round the loop should start from row 3. The loop end is constrained as I count...

acron Tried that as well - still get a type mismatch. Am I missing something really simple here - as this is another code segment I've tried in order to get the basics of assigning the contents of a cell to a conditional test, using the datevalue as you suggested. Dim andy As String...

Mike I've tried that and I still end up getting a type mismatch when I make actiondate of variable type Date rather than variant - any other ideas would be appreciated! Cheers Andy

Tom Here's the code as it stands just now - as I said I've made sure that the column format is set to Date - so I am not sure why it is going wrong. Well I do know, I just don't know how I can assign a variable I declare to be of type Date to be assigned the contents of a cell which is also of...

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...

Yeah well an Abbey New Boy as well, so got to show some extra commitment don't you!!! Thanks alot

Thanks alot, my email address is andrew.knott@abbeynational.co.uk Cheers

Hasit At the moment I don't have a chart to use - just if you could show me an example of how this could be done for any chart I can then implement it for the chart we require. I would be most appreciative of your efforts Thanks Andy

Hasit I would be very greatful - the application is being delivered via Excel at this stage. Cheers Andy

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...

Thanks ratman - all I need now is some code to set the resolution!