Search results

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

Hi - now that we're in the new year the code I've used to change the format is now defaulting the year to 2009 even though the range of dates to choose from goes back to 2008. I've tried different settings in the code but nothing seems to work - any ideas? Cheers

Hi - that piece of code has done the trick. I was using a combo box purely because it's more obvious than a validation list that there is a drop down box - and the end user of the report isn't someone that would either know that there is a drop down list or remember after I've told them that...

Hi - the list of dates is already in the standard date format. When you click on the drop down button the list is also displayed in the correct format - it's only the date that is in the actual box that is not as I want it. I've attached a screen shot. Cheers

Hi, I have a combo box where it is linked to a list of dates so that these can be chosen. However it displays the date in the Julian format rather than dd/mm/yyyy that I want. The source list is in this format and I can't work out how to change the format in the combo box - can someone point...

Okey dokey. The MGMT will just have to have their reports without the bells & whistles! Cheers