Search results

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.

Are u looking vba code to check upon each email sending from outlook and what will the file types to check.

Or, This would be far better.. =IF(SUBTOTAL(3,$A$6:$A$26)<>COUNTA($A$6:$A$26), INDEX($A$6:$D$26,MATCH(SUBTOTAL(105,$A$6:$A$26),$A$6:$A$26,0),4),"")

Check this... =INDEX($A$6:$D$26,MATCH(SUBTOTAL(105,$A$6:$A$26),$A$6:$A$26,0),4)

A Native approach. TextBox1.Value = Format(1 + Application.EoMonth(Date, -1), "mmm dd yyyy")

Can we have a sample file.

Hi, Below line is checking that email will not send to any email duplicate email in said range on each loop. If WorksheetFunction.CountIf(Range("C8:C" & cell.Row), cell) = 1 Then What you want in case of multiple existence... Send email to all if duplicate - then just remove that line and...