Programming

Using built in "mail recipient" with custom command bar
In the spirit of keeping things simple I am quite happy to use the built-in command "mail recipient" for users to contact me for support or bugs or whatever. The problem is when I build my command bar and add this command I can't figure out how to pass a "To" person (me) and/or a subject line to Outlook when it ... 21 Jul 2008 12:02

Using mail recipient for support queries
Hi all, I am quite happy to use the built command "main reciepient" for users to send in queries and bugs etc. In trying to keep this simple I don't seem to be able to pass a name to outlook for the send to person (me) and/or a subject line. Had a look through various posts but did not see what I needed. Sorry... 21 Jul 2008 09:58

Sorting by only numbers
How to sort ignoring letters, Excel 2003 ny only containing numbers, For example default sorting wanted sorting AA101 AC02 AB99 AB99 AC02 AA101 Thanks George ... 25 Jul 2008 22:45

How to read data from binary file?
Hello Guys! Such a question to you I have a binary file. I need to get from this file data in 100 byte to cell and after I need to create a new binary empty file and unload it received data from the first binary file. Thanks for you time. Regards Valery. ... 21 Jul 2008 12:02

Using INDIRECT
I'm trying to use INDIRECT for the first time. I have successfully used it on its own e.g. =INDIRECT("'file_"&A1&".xls]sheet1'!B2") I'm now trying to use it with VLOOKUP, but Im not too should what the order of syntax was? e.g. =VLOOKUP(C3, INDIRECT("'file_"&A1&".xls]sheet1'!B2:F10"), 3, FALSE) Thanks for... 21 Jul 2008 07:55

Retrieve number from string
Hi I'm gtrying to retrieve a number from a string. The string is a cell value, that can be AAAAAA 12 AAA AA12 12AA 1A2AAA12 AAAA 12 AAAA or any other combination of letters and numbers. I need at function, that rerieves only the numbers. The results of above should be 12 12 12 1212 12 Regards... 21 Jul 2008 16:10

'Search' problem
Hi folks. Does anyone know how to search a sheet for a particular reference (could be anything)... and if that reference does not exist, then... 'do something else'. When you do a 'find' manually, and the thing you're looking for doesn't exist... excel let's you know. But when you try and do this in VB... if the... 21 Jul 2008 06:53

Edit Data by UserForm
Dear Friends. I have a userform and I made the following procedure to get the data in UserForm, its working fine, and I want to put one more button "EDIT" on the userform to edit the selected records. I dont know how to do this. pls help me out for this function. Option Explicit Dim i As Integer Private ... 21 Jul 2008 05:52

background colour.
I have some cells with background colour. I want the background colour change automatically when the value of the cell being updated,but when printing the the sheet,the background colour is disappear. How to do that? The cell position is random. Thank's id advance. Rgds, Shiro. ... 23 Jul 2008 21:32

"Search" Macro problem Help!!!!
Hi everyone, I have this macro that searches for the value in column A in every sheets and return the name of the sheet if the value is found in column C Major problem I am having with this macro is that when it searches it doesn't go for the exact value but everything that includes the search value. i.e. if... 21 Jul 2008 01:47