Search results for query: *

Obvious - got all caught up in the VBA and overlooked what's already in Excel. Many thanks.

I have the following code to extract the contents of a query in Access to Excel, which works fine. However I now need to query the data based on a variable that will be contained in the Excel file. I can't put the criteria into the access query, because several different templates need to run...

That worked treat. Cheers to everyone for the help. (And I'll try harder in declaring may variable's in future!) diddon

Thanks to both... I've tried the code above and it works fine (as you knew!), but only when I use the active cell content of bob. When I try to apply it to a cell in the list I'm using, it breaks down again. The error message is that it cannot find the macro R0001. (I've double checked the...

Thanks to both... I've tried the code above and it works fine (as you knew!), but only when I use the active cell content of bob. When I try to apply it to a cell in the list I'm using, it breaks down again. The error message is that it cannot find the macro R0001. (I've double checked the...

Hello I am trying to call a macro from another, but the macro name will variable. I have a macro that runs down a list of report codes (eg R0001), each of which has a macro of the same name. I've successfully managed to step down the list and reference the codes in a MsgBox, but cannot get it...