Recent content by DrJimmy

Hi, I'm trying to find a way of doing a vlookup (or other formula) that will return the format of a matching cell rather than the value. Any ideas? Cheers

Hi, I'm wanting to use the MS slider control to change values in a formula - is there an easy way of linking a cell in excel to the control to get this? Cheers

Hi, Does anybody know of a way to set up Excel (and Word) so that whenever you open a new document it automatically sets up a footer with the path name on? I can get it to do this in Excel when you start up excel by saving the correct .xlt in the program folder however I can't get it to do...

No worries - thanks anyway!

Already checked it. The particular add in is working fine as I have it set up - I just can't change anything on it as the Add-In tab won't appear. I've also tried unloading it, quiting excel, restarting, re-loading then quiting and re-starting and it's still not playing fair!

Hi, I'm trying to manage some external links I have through to a Dimensions Access database (our accounting software). Normally I would manage this via the Add-Ins tab but it's disappeared! I've followed some online help that suggested it would automatically appear when a not standard excel...

Hi, I'm trying to use the INDIRECT function on a summary worksheet to refer to values on other worksheets that are named after the months of the year. I have to have the year in as well as the month as the summary sheet covers 5 years. I can get the formula to work no problems in the data...

Hi, Not strictly an access question but hoping someone with VBA skills can help out. I've hundreds of emails, from the same person, all with attachments. Is there a VBA script I can run that will look at these emails and download the attachment to a specified area on my drive - without me...

That's done the trick. I tried it before and for some reason it didn't bring back the expected result. Oh well....! Cheers

Doesn't seem to give me the number I'd expect. When I apply it to a cell ref where the contents are 24.12 it says 16 is the answer. I'd expect eithe 4 or 5? Cheers

Hi, Does anyone know of a quick way of counting the number of digits within a given cell ref? Cheers

Hi, I've just upgraded to 2007 and I also use Access Accounts (Not MS Access) with the Access Office Integration (AOI) version 3.02. I have added the Add In so I can link to the Access Db and draw info through via an ODBC. Whilst the initial links are working it won't allow me to create any...

Hi, I get this every few years can keep forgetting how to get out of it but I have a spreadsheet where the one cell remains highlighted and is locked to that cell, so even if I select another cell it stays locked to it - any ideas? Cheers

I've kinda sorted it. In the properties of the combo box I've changed Style from "0 - fmStyleDropDownCombo" to "2 - fmStyleDropDownList". This then changes the date format in the linked cell to an integer. To get round this I've used the following code: Private Sub ComboBox1_Change()...

Hi -this has changed things however not to what I'm after. This has changed the format of the original list and has updated the list in the combo box - however it still reverts to 2009. If I remove the original piece of coding that changed the format to mmm-yy for the combo box then it displays...