Search results

Awesome bosco. This SEQUENCE looks interesting, Well, I am not working with excel these days so less known to new functions.

Hi, I think you should to look at (7) Numeric data find out through excel | Chandoo.org Excel Forums - Become Awesome in Excel This is for extracting number and solutions are great. Very interesting solutions by Sajan, Lori, Narayan....

Let's see if this workes, Put in B4 and drag right/down, It's dynamic so you have to update the row 3 correctly. If u have latest xl then that also can be by formula only. =IFERROR(INDEX(Sheet1!$A:$T,MATCH($A4,INDEX(Sheet1!$A:$T,,MATCH(B$3,Sheet1!$4:$4,0)-1),0),MATCH(B$3,Sheet1!$4:$4,0)),"")

Try with adding files as hidden attachment too.

This can be , Hope any one will take care of that of not I will glad to help if get free hand for that.

Hey, I am not much looking bro excel since a long and into web development. Making two sheets will be a good idea. Pls try with ref thread and let me know if still issue, I will try.

Hey! I am not working on VBA as of now, Kindly start a new thread.

New talk of the spreadsheet lovers and vlookup bluffers... Here's XLOOKUP https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376

Hey! VBA easily possible in XL 2007 while opening password is good stuff but still not power proof for who wish to crack it.

Mr faster : Advance Filter

I am afraid that we can login to amazon without the credentials. This doesn't seems possible with VBA itself.

No idea and it will not that easy as well due to both are two different vendors. You must happy with IE when dealing with VBA and web automation.

Hi, Pls check. Option Explicit #If VBA7 Then Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems #Else Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 'For 32 Bit Systems #End If Sub GSTLogin() Dim url As...

May i reason for the GST website login from VBA, There are plenty of software which offers filling directly from the software via API call and scrapping the said website is illegal as well. There's also captcha, so you can't login in the same way.

This website can't be accessed outside of indian territory .

Still, the issue or resolved.

You are looking a solution for Google sheet or excel? You are looking to just extract the first block of text from the long text.

I assume it should send the email. pls check and confirm.

Pls share a sample....

Hi, You should be very clear to query to get the answers... I found that there is a mismatch in your highlighted written details which was confusing. Pls be careful for explanation to get the target answer. The more clear query is - chances are very high to get answers!!! Pls check the...

Or import the attached files in outlook.

So, The code given here didn't work for u? I have updated the code as well... In ThisOutlookSession... Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim strCheck As String Cancel = True On Error GoTo xEnd strCheck = CheckAttachmentPassword(Item) If...

Didn't encounter such issue... Will you pls share a sample email, This might be issue of mht encoding.. (If privately then inbox : imdkbj at outlook dot com)

https://www.msoutlook.info/question/saving-emails-as-pdf-files Let us know us for more.