Search results

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!!! :)

Hi all, I am web scraping and I found this code which open IE on memory and extracts the information I need. However, I keep getting this message: "Run time error 429: ActiveX component can't create object". I tried changing the "Set IE = New InternetExplorer" to "Set IE =...

Hey, thanks for the help. I managed through the loop with querytables. Best rgds!! :)

I found Yep, I now understood! :) I've attached a wbk with the list of urls from page 1 to 41. Could you help, i'm not sure how to loop with querytable.

Update: Website 2. I solved by copying the entire html body, then pasting it on excel. Now, Website 1. is a bit difficult. Could you clarify the part where you have to change URL until there is no DIV. I know there isn't any stores after pagina=41...

Hi Marc, Thank you for the reply! Sorry for the lack of attention. I'll double check next time. I can't edit the thread, could you modify it if please? These are the correct links: 1. http://www.reidomate.com.br/lojas.php 2. http://www.franscafe2.com.br/lojas/ This is what I need...

Hello fellas! :) I am trying to extract all store locations from these two websites: 1. http://www.reidomate.com.br/lojas.php 2. http://www.franscafe2.com.br/lojas/ Store locations in website 1 are displayed as various tables and in website 2 as a map. I tried using excel's web query and...

Hi all, Normally, I organize my files through excel. I list and describe them, sometimes I need to rename a few and sometimes I want to get the files inside subfolders. Can anyone help modify the code below to add these new features with a msgbox yes/no; 1) include subfolders, 2) rename files...

Thank you very much Hui :)

Hi fellas :) How are u? Let's cut to the chase. I am doing a map research to find the count of stores that are close to each other, inside a 3 km radius. I have a solution but it's long and takes a lot of space. So if anyone can come up with a different more convenient solution, I would...

Thank you very much :)