Recent content by Squibbles

oo.. how can i make a function that retunrs the number of rows in the CurrentRegion? Cheers, Squibs

Hi, I am trying to define a range in Excell, dynamically. Currently I am using the following: Insert>Name>Define box - sourcedata =OFFSET(Sheetname!$A$1,0,0,COUNTA(Sheetname!$A:$A),COUNTA(Sheetname!$1:$1)) But my main problem is that each week there is new data, in which the size of the...

marvelous, this tek forum is fantastic! Thank you very much, Squibs

Excellent thank you very much. I assume it will work even if x was a string? Many thanks, Squibs

Hi, I am writing a prog. in VBA and i have a vairable (x), and I want to lookup in another table (table_y) to find the relavent group noumber and assign this number to another variable, for later use. Table y has two fields: field 1 - x field 2 - Group No. My SQL knowledge is non-existent...

I am using Access 2002, Just playing with the split function now. Should I read all the text file in, and use the split function. and then stream the relavent columns into a new text file? Or is there a simplar method? Thanks for hints! Squibs

they are comma delimited... Split function? Whats that? Any chance you being able to knock up some sample code please? Cheers, Squibs

Unfortunetly Access will only allow 255 fields. So when specifying manually, i can only choose to skip columns in the first 255 columns, the rest of the columns are simply ignored. I've been toying with the idea of streaming the data into a new text file, keeping the columns I want, and then...

Hi, I am trying to import a textfile into Access (using VBA, TransferText). The file has over 400 columns, but I only want to import a selection of columns. Also the first line has column headers and the second line is blank (and so i do not want to import it). How can I do this using VBA...