Search results

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...

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...

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

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...

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

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...

Hi Guess I am bombarding the forum with my questions :-) Let us say I have a variable (Tx) that include a large amount of text divided into a no of paragraphs, a paragraph always ends with a return or enter ie Chr 13 Let us say one of those paragraphs starts with the word "Start", how can you...

Hi! I am importing data from a text file, some of the imported data are dares, written in the following format: 12mar2009 The problem is that the data is stored as text and not as date type of data, which makes it difficult to do mathematical procedures on that type of data is there a...

Hi! I wonder if it is possible to upload a MS Word file to MS Access db or at least put a link (like a hyperlink) in the db to the MS Word file, and how can that be done? Regards

Hi I am trying to import text from different parts of several (1000) MS word documents. Most of the text is in Form Fields and is therefore easy to impost However, one part of the text is inserted into a table in the word document, you can see the attached file to see how the table looks like...

Hi A very basic VBA question about IF ... Else ..... End if What i need to do is do the following If "a certain condition is fullfilled" then do this and this and this Else do that and that and that End if However when i write this in VBA editor in MS access, I get an error, it seems...

Hi I am using a VBA in access to transfer a large amount of text in a word file to access The records in my access table are all defined as "text" When i run the code i get this error: Run-time error 2147217887 (80040e21) The field is too small to accept the amount of data you attempted to add...

Hi I am trying to build a VBA modul, two lines with the command (Application.ScreenUpdating) are returning an error: Application.ScreenUpdating = False .. . . Some code here . . Application.ScreenUpdating = True THe error is Compile error, Method or data member not found Anyone has a clue...

Hi alla, I really need help with this I am trying to run the code form this web site to extract text from a word document http://gregmaxey.mvps.org/Extract_Form_Data.htm The problem is that I am getting lost of erros, many seems to be related to missing references 1- I am getting an error when...

Hi I am trying to extract text from a word file, but when running the code, i get an error: Compile error: User-defined type not defined and the following line is highlighted: Dim myDoc As Word.Document I am not sure how to solve this, any ideas? Best regards

Hi using the inStr function returns the position of the first word in a text. So let us say that I am excuting InStr(1, myString, "word"), then I will only get the position of the first word in the text Any idea of what to do if I wanted to find all the positions of the word in the text if the...

Hi I need to write a VBA for searching through the content of an external word file then import the sentence containing a certain word to a table in access Any idea please? Best regards

Hi all I am writing a VBA code, this is th first step of a lrage project WHat I am trying to do is to put all the content of a word file (.doc) into a cell in access using this code: Private Sub Command0_Click() Dim app As Word.Application Dim objDoc As Word.Document Dim sVal...

Hi All! First lots of thanks to this wonderful forum and to anyone who would be able to help me in this difficult task Here it comes: I am now working on my PhD thesis, in one project I have received a CD with about 1000 separate word documents. Each document is about 30 pages long In each of...