Search results for query: *

Thanks for replying MajP. That's a great idea using a variant. I'll update my code accordingly. Cheers!

Okay, I managed to solve this one using some similar concepts in other threads. If anyone is interested, I've listed my solution below. The problem was that the query I was using to pull the "input" data for my vba function was making reference to a table where there were some null values in...

Wonder if anyone is able to help please (I have scanned through some threads but cannot find a solution). I have a simple query (using Access 2010) where I've used a vba function to use a date field in the query and return a period value (integer). When I try to enter something like >1 in the...

N1GHTEYES Apologies for lack of detail. I've subsequently found out that I was actually after something called TreeMaps not heat maps. These are available as an addin into Excel and do exactly what I wanted. I will certainly take on board your advice next time I ask for assistance. Cheers.

Does anyone know how to create heat maps in excel? The kind I'm looking at are like those shown in the following link: http://www.digitallook.com/cgi-bin/dlmedia/investing/visual_tools/market_maps?&username=&ac= I want to be able to change the size and colour of the boxes

Thanks anotherhiggins...that advice was spot on and it worked a treat. Apologies again, I will endeavour to try to be more specific and accurate in the future. Your help was much appreciated.

Also, I tried changing the "FormulaR1C1" after the "activecell." to just "Formula" when I identified the mistake but it had no effect.

...simply blank. The line of code I am currently trying to use is as follows: ActiveCell.FormulaR1C1 = "=IF(AND($D38>=E$4,$D38<=E$5),((ROUNDDOWN(E$15*networkdays(E$4,$D38, BankHolsArray),0)-ROUNDDOWN(E$15*(networkdays(E$4,$D38,BankHolsArray)-1)...

Hi Thanks for responding. No, there are no quotes in the formula itself, only around the string expression. eg., "=IF(a>b,1,0)" Also, when I attempt to record a macro it falls over and doesn't work. A colleague informed me that the string size was infact restricted to 255...

Hi I'm having problems copying a string variable to a cell formula in excel. The string is over 300 characters long and if I type this directly into a worksheet cell it works fine (i.e., the logic is correct as far as the formula goes). The string is simply a long IF statement. However, when...

Thanks for responding guys. The initial reason why I wanted to do this was because I wanted to output only a subset of the 3-D array to a worksheet. I was looking for a short-cut to something other than looping through (almost a bit like the resize command where you can output a 2-D array in...

Does anyone know how to move data from a 3-dimensional array into a 2-dimensional array using VBA in Excel? I'd like to select one dimension and hold it constant and then simply transfer data relating to the other 2 dimensions across into a new 2-D array. Eg., Array1(Colour,Size,Cost) and...

If you right click on the status bar at the bottom of excel you can use the count, sum, min functions etc... Does anyone know how to customise this so that you can have other excel functions such as StDev? I have searched high and low and cannot find any information on being able to customise...

Hi. Has anyone noticed how MS Solver in Excel 2003 produces different optimised results compared to the one in Excel 2000? Does anyone know what the key changes to the Solver add-in have been between the two versions? I've tried looking on the net but struggling to find any useful...

Hi I am experiencing problems with releasing a reference to access from memory. Basically I open up access from excel using vba code (dao), do some querying and then close the access application using the .quit and set = nothing commands. However, an instance of access remains in memory (as...

Can anyone help with my problem. Basically I have a straight forward query in MS Access which makes use of a simple VBA function to performance a series of calculations. This query works perfectly fine in Access. I have been trying to pull results of this query into MS Excel using the Get...

Thanks for your help. I might give that a go when I get more time. I actually resolved the problem by defining the date as long date and that sorted the problem out. Perhaps it has something to do with Access 97 and date conventions. Who knows..... but many thanks for responding! Dee

Hi all, I am using Excel VBA to create a query in Access but am having problems with the date field which is a required input in Excel via a InputBox statement. Is there a way to set the format of the inputbox data entered by the user within an SQL statement in Excel VBA? Basically I want to...

Thanks for responding &quot;psudeke&quot;. I get the following error msg.... &quot;The command line you used to start Microsoft Access contains an option that Microsoft Access doesn't recognise. Exit and restart Microsoft Access using a valid command-line prompt&quot;. Any ideas..?

Can anybody help? I am trying to launch an access database using the shell function in excel VBA. Unfortunately the pathname has spaces in it therefore I am experiencing problems. Can anyone suggest what I need to do to the following code in order to make it work? : Dim RetVal As Variant...