str

Hello all, I have a complex inventory workbook with a function to search that will populate boxes in a GUI if anything is found and increment to the next record. It was working fine and then I have been making changes for a newer version of Excel and new parameters. Not sure why it is not...

I need to convert these CSV files to TXT, I succeeded with below code. However need help with two things: 1) This code should be applied to all CVS files in given path. Because It gave result on only given number. 2) I want on TXT top line as: LEDES98BI V2[] instead of LEDES98BI...

Hi anyone your help will be appreciated Though adopted the code from below link for converting form figures to words It seems there is error some how not able to get it right http://excel-macro.tutorialhorizon.com/vba-excel-convert-numbers-rupees-into-text/ when i type in Textboxfigure.text =...

What I need, is a macro that can look in Column D and add “/” and “R” to the existing 7 character text string. Cell (2D) has what the end result should be for all cells in column D, once the macro runs. <tbody> Dealer Description Matched 235/65R16 2757018 2256016...

For some reason this code does not populate the text from the column and I am trying to create a loop where if the row has the same email address then it will populate one email instead sending out multiple emails for the same entity. Option Explicit Sub SendcomplexEmailHTML() 'early...

Hi Xcel gurus, I have a workbook which connecting to Mysql and getting data (In Pivot) no issues. Plan is to distribute this Workbook to my team so that they can able to see LIVE updates by Mysql. Issue : while testing, I have given this workbook to one of my team mate, and he is unable to...

I have a big problem where im trying to look for similarities and I just built a working code however its way to slow :/ I thought maybe the Similarity function I call was the bottleneck but just writing a simple "1" to each of these cells also took quite awhile Sub FindSimilarity() Dim lr As...

Hi guys Ive used all the stuff ive learned over the last 6 months to create this code which basically search for duplicates. Sub DuplicateSearch() Dim lr, i, j, k, m As Long Dim str As String, str2 As String Dim vData, vResult As Variant Dim vSearch, vOdd, vOdd2 As Variant Dim sheet As...

Hi Im working on pulling some information from a web page , unfortunately it was not so straightforward as it usually is. But I found a solution to get it to be correctly displayed in excel. here is my working code. i = 3 On Error Resume Next str =...

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...

Hi, I've been getting myself tied up in knots trying to do this with several loops but there must be a better way. Cells A1 TO A100 contain a single word Cells B2 to 200 contain a sentence I am trying to find out if any word in Column A exists in the any sentence in Column B if True mark...