• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Deepak

    Vba Code to Export outlook emails of current date for a folder to excel

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

    Interesting/Useful _VBA/Excel links over the internet

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

    How to create/generate a licence code for my excel file.

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

    Interesting/Useful _VBA/Excel links over the internet

    Mr faster : Advance Filter
  5. Deepak

    Hey, Share me the link, if will help if i can

    Hey, Share me the link, if will help if i can
  6. Deepak

    Batch download hyperlinks from amazon website

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

    Excel VBA Website Login

    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.
  8. Deepak

    Excel VBA Website Login

    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...
  9. Deepak

    Excel VBA Website Login

    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.
  10. Deepak

    Excel VBA Website Login

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

    Userform Login for Multiple Level User - Customized Spreadsheet

    Still, the issue or resolved.
  12. Deepak

    Text parser. Need help to find out a more elegant formula

    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.
  13. Deepak

    VBA Code to Detect Non Password Protected Attachment

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

    Raw data convert to Particular Format

    Pls share a sample....
  15. Deepak

    Raw data convert to Particular Format

    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...
  16. Deepak

    VBA Code to Detect Non Password Protected Attachment

    Or import the attached files in outlook.
  17. Deepak

    VBA Code to Detect Non Password Protected Attachment

    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...
  18. Deepak

    How to save e-mail as PDF with excel VBA

    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)
  19. Deepak

    How to save e-mail as PDF with excel VBA

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

    VBA Code to Detect Non Password Protected Attachment

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

    NEED HELP "FILTER" OPTION

    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),"")
  22. Deepak

    NEED HELP "FILTER" OPTION

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

    How to Get only first Date of a month in Text box .

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

    Identify Back Date Entry / Deals - Volume Report

    Can we have a sample file.
  25. Deepak

    Email issue on duplicate email address

    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...
Top