Search results

Genius! :)

Hi guys, I am trying to list all the values inside "{ .... }" from the string below. http://casadopaodequeijo.com.br/resource/scripts/custom-map-default.js. I have attached a sample workbook with the example below: Link http://casadopaodequeijo.com.br/resource/scripts/custom-map-default.js...

Thank you Nebu :)

Hi Nebu! Thank you for your time. However, I need to do this via vba. I need to concatenate the respective header with the input and then summarize by person.

Hi guys! :) I am trying to: 1) concatenate table headers with there respective data inputs then, 2) summarize inside one cell all the data by person. I've attached a book with an example made manually. Thanks in advance! :)

GENIUS!!!!!!!!!!!!! :D Thank you :)

Hi guys, I have a set of data in column A that goes like this: [A1] Market: Cheetos & Coke | Supermarket X | $ 3.65 [=2.65+1] (Visa) [A2] Lunch: Chicken (200 g) & Salad | Garden Grill | $ 21 (MasterCard) I want to extract the numeric value after the money sign from each string "$". So, what...

Worked like a charm :) Thanks!

Hi Luke, Sorry to bother you, but the code is not capturing all files. Some files are missing. I've attached the list built by the code and the missing files. Rgds

AMAZING :) ITS FLAWLESS!!!!!!! OMG thank you so much.

Hi Luke, Sorry, I'm confused. I've uploaded another file, that I believe is more comprehensive. Thanks :)

Hi Luke, Thank you for answering. Sorry for the wait, I have uploaded the example you asked for. - The files are in the same folder and there are no sub-folders. - The macro should refresh my table adding the hyperlinks to old and new files. - The table doesn't have the folder address, because...

Hello, I am having a hard time trying to figure out how to do this, so any help is welcome! I need a macro to add new files not listed in my table to the end of the list with the date that it was added and delete files listed in the table marked with an "x". Thanks in advance! :)

Very nice, I will look into it! Rgds

holy mama hahahaha, that was SO FAST! Wow. Yea, im definately going to checkout the webbrowser inspector tool. Thank you Marc! hahahaha wow!

Yea I use that one! :)

Genius, worked smoothly! Can I ask you something, what text editor do you use, or would recommend? Rgds

Awesome, it worked perfectly! In case anyone wants to verify specs and limits in excel here's the link below: https://support.office.com/en-ca/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa Thank you Marc and Somendra!

Hahahah I was just researching this right now! I'm gonna run the code and get back to you asap.

Sorry about that Marc. You guys are already helping so much, I didn't want to be too specific. Anyways, the delimeter isn't really necessary, a simple "space" is suffice. Now, the cells being limited in characters is news for me. The max. chars I have for a name is around 24KB.

Please find the sample attached! Ty :)

I would like to run the names in Sheet1 and fetch the comments (concatenat'd) in Sheet2. So, if the name in Sheet1 has no comments in Sheet2, then column B would be blank. Rgds

Hey, I tried modifying your XMLhttp code for: http://www.qual-operadora.net/ and it works. But I don't know to change the part of the code to get the information I need.

YES!!!!!!!!!!!!!!

Hi Marc, First of all, thank you for helping me with this thread and the others!! You're awesome!! When I tried the code with small quantities, the procedure runs fine, but with larger strings I keep getting run-time error '13'. Rgds