Search results for query: *

hi! Would it it be possible to examine my code and comment some errors that as a newcomer I missed? The code should extract from sheet1 the rows that have a certain value on column 6. First I have to extract the value of reference, which is the max value on this column. Problem is that it is...

hi I want to extract som data of a sheet and save it as a new excel file. I don t know the methods to call in vba for that would be very kind to give me a hint' thanks

hi, i dlike to format an excel column that has numbers but in text format to number format. Then i want to extract the max value in this column and put it in an integer variable. All that from VBA. The problem is that i don t know how to embed these functions in the vba syntax. Here is pseudo...

Hi! I just need to do : I have a sheet column with numbers formatted as text. I need to format them as numbers and put the max value into an Integer variable on my vba code. I don t know the vba syntax to use these functions... help..

Hi, i would like to import data from a spreadsheet to an Access table that is created then. The trick is that the data in excel must be formatted(it is originally contained in a single cell in each row and in text; this data should be thus formatted from one cell into several field data, for...

Hi I want to compare two excel sheets. I have to find each row in the first one that is not in the second one and extract it to a third sheet. The comparison is done just on one cell of the rows, some kinfd of id. I have the following code, but i get an error that is not defined by VBA. I don t...