Recent content by Ammarhm

Hi I have 2 columns in 2 spreadsheets, please see the example attached, it explains the concept of what I am trying to do, the real file is much longer, about 1200 rows and 2 columns The data in the first column are not arranged similarly in the two spreadsheets as you can see I need to compare...

Hi all I am having a real problem comparing two columns in excel, I am attaching the excel file with this post Simply. I have 2 lists, List 1 and 2, each no. in the file represents an item The problem is that the item no. are entered as numerical, while in the second one they are entered as...

B thank you for that information It is Word 2003 ie .doc format, and there are 1200 such files in a folder that i need to extract data from Thank you

Hi all I have several word files that include ALOT of text, the text in those files is arranged under different titles. Som of those Word documents include a title "Adverse Events", what I want to do is simply to extract the text after this title (when it is there in the word file) and put it...

Thank you man, that solved the problem

Hi! I am using the VBA function val(string) to convert the numerical content of a string to numbers The problem is that it is rounding the numbers! ex Val ("1.2") returns 1 instead of the wanted 1.2 is there any other command or solution for this to get the numbers without rounding? Best Regards

Watch your language! using words like "fools" is unacceptable and impolite

Hi everyone I guess this issue has already been up for discussion before. Microsoft has done a great job in developing VBA, but the worst thing Microsoft ever done is unfortunately "Windows", the whole thing sucks and is not comrable to the great performance of Mac OS Anyhow, the biggest...

Actually, that is exactly what I am trying to do, error ignoring, I know it is not good programming practice, but I have reached to a stage where I have to do it THanks again

Thank you Would it be possible in stead to add the following code in the beginning of the code: On Error Resume Next Regards

Hi all Just about to start running my project One thing that worries me is "errors", I dont want the script to be intrupted and haulted if an error occure, mostly because of the data input I wonder if there is a way to tell the script to continue to the next step in case an error ocurs? Regards

It would always have "Admission date:" and Dischage date:" However it could contain only one admition and discharge or 20 of each.. Regards

Thank you My string will always be in the format i presented The problem is that the inStr will always return the "first instance" of occurence, how would you loop this code to extract all dates and not only the first? Regards

Hi I have a variable (hosp) containing a text that looks like this: Admission date: 31aug2004 Reason: xxxxxxxxx Discharge date: 16oct2004 xxxxxxxx Admission date: 28oct2004 Reason: xxxxxxxxxxxxx Discharge date: 09nov2004 Discharged xxxxxxxxx Admission date: 09nov2004 Reason: xxxxxx...

I decided to ditch my own solution and go with the solution suggested by John Big Booty for several reasons I think however that code should be modified, in the Mid(Tx, startInt, endInt) one should be giving the number of charachters to be extracted and not the last position of extraction So...