Recent content by exc4libur

Perfect!!! Thank you very much Sir!! :)

Hi guys :) I am studying for the gmat and I have put together a question bank to study for later. I need to place all questions from the data table into a single column and in between each question I need to insert 10 or more blank rows so I will have plenty of space to workout out each...

Thank you very much Chihiro!!!!!!!!!!!!!! :-)!!!!!!!!!!!!!!!!!!!!

Hi Chihiro, Thank you for responding. Do you know a way I could break the string by a number of characters to columns, for instance 3 characters example: String: iText = "aaafffzzz" Results: Column A = "aaa" Column B = "fff" Column C = "zzz" This is the part I am having difficulty with!!! :(

Hello all :) I want to break a text string of 80,000 by 32,767 characters which would split it by 3 (Round[80k/33k]) columns. But I can't seem to split the string correctly. This is where i got so far, but its wrong. Any help would be appreciated, thank you :) If Len(Text) > 32767 Then...

Ah sorry for the B1 value, I attached a sample text without it. But Yey, thank you for your time I got it!!!! :) Sub GetValuesInBetweenFiles() Dim FileName As String, NextRow As Long, c As Long Dim MyFile As String, Text As String, TextLine As String, beginStr As String, endStr As...

Hi marc :) I think I have part of the solution. I need a little help though. I'm missing: 1. Loop through "text" files in the folder; 2. Remove """ quotes from text files; (tried searching with quotation marks but didn't work) 3. Get the values in between the first and last string; a. First...

Shrivallabha, I've ran into some trouble. Some of the text files are very large and I only need to pull a couple of things from them. I was using the MultiReplace routine to make the files smaller so that I could import each file into one single cell on the worksheet (obeying the character...

Very nice, thank you so much! :) rgds

Uh, I was thinking of adding new wkb or wksheet and paste the entire content "after" (the replace) in a cell. I would love to have before as well, but for some txt the content is bigger than cell capacity (32kb).

Hi shrivallabha, could you add one more thing? I wanted to report/list all the files that where looped and the entire text content beside it. Is it possible? Thank you.

Thank you all very much :) They both work spectacularly! Also, thanks for the quick help!!! Rgds

Hi guys! :) How are we all? Well i hope. Quick summary: I am going through all ("*.txt") files in a folder and finding and replacing values from an excel list. I need to modify the code below so that I can do multiple find and replace. The values to search for are in column "A" and the values...

Yep :) thanks for the attention and tips!!! :) rgds

Solved. I had turned off Internet Explorer 11 in windows features!!! :)