• 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. ThrottleWorks

    Thanks a lot shrivallabha for 2,000 + helps to the Forum !

    Thanks a lot @shrivallabha for your 2,000 + helps to the Forum ! Stay safe, take care.
  2. ThrottleWorks

    Take care, stay safe

    Hi, Hope everyone on our forum is doing good. Take care, stay safe. :)
  3. ThrottleWorks

    Wishing a very happy birthday to Chirayu

    Wishing a very happy birthday to @chirayu ! Have a wonderful year ahead ! :) Your PDF books on Excel were really good.
  4. ThrottleWorks

    Wishing a very happy birthday to NARAYANK991 sir !

    Wishing a very happy birthday to @NARAYANK991 sir ! Have a wonderful year ahead. :)
  5. ThrottleWorks

    Congratulations Marc L sir for his 5,000 + helps

    Congratulations @Marc L sir for his 5,000 + helps to Forum ! Thanks you. :)
  6. ThrottleWorks

    Many many thanks to Khalid NGO for his 2,000+ helps to Forum !

    Many many thanks to @Khalid NGO for his 2,000+ helps to Forum ! :)
  7. ThrottleWorks

    Many many thanks to vletm for his 6,000+ helps to Forum !

    Many many thanks to @vletm sir for his 6,000+ helps to Forum ! :)
  8. ThrottleWorks

    What is PtrSafe keyword

    Hi, I have no idea about PtrSafe keyword. Just did Google about this a while ago. I am trying to know if use of PtrSafe has advantage or disadvantage in the coding. Also, is PtrSafe required for 64 but machine. Or are there any constraints or mandates to use or not to use PtrSafe while using...
  9. ThrottleWorks

    Getting bug on 'T_Sht.AutoFilterMode = False' line

    Hi, I am running below code. This code is run on two different locations. On one location code runs fine. However at another location macros face bug at 'T_Sht.AutoFilterMode = False' line. Also this bug is not permanent, sometimes macro will face bug and sometime macro will not face any issue...
  10. ThrottleWorks

    MS Access Query - How to use WHERE clause in Excel VBA

    Hi, This is a MS Access Query. My apologies if this is not allowed. I want to use where clause in query from Excel VBA. I am not able to do it, I tried various options from Google but could not succeed. I want to select data WHERE Name = 'ThrottleWorks'. I can do it in MS Access but not able...
  11. ThrottleWorks

    Wishing a very happy birthday and Eid Mubarak Khalid NGO

    Wishing a very happy birthday and Eid Mubarak to @Khalid NGO ! :)
  12. ThrottleWorks

    exception has been thrown by the target of an invocation

    Hi, We are getting below pop-up while running a macro for one of the user. Can anyone please help me understanding this.
  13. ThrottleWorks

    Acitve X component can’t create object

    Hi, I am facing an issue while creating an e-mail item from Excel VBA. This particular code is working fine at my system. However facing issues at user’s desk while trying to create e-mail. I have copied the code for creating e-mails for Ron De Bruin’s site. And this code is working fine for...
  14. ThrottleWorks

    Wishing a very happy birthday to Smallman sir !

    Wishing a very happy birthday to Smallman sir ! Have a wonderful year ahead. :)
  15. ThrottleWorks

    How to run code in background

    Hi, I am running a macro from Excel. This macro involves working with Excel, Word, PDF and Outlook. In short, my macro is exporting e-mails to PDF. Please see below link for your reference. https://chandoo.org/forum/threads/how-to-save-e-mail-as-pdf-with-excel-vba.40703/ Macro takes time to...
  16. ThrottleWorks

    How do we filter date and time values such as ‘1/15/2019 4:08:48 PM’ from a range

    Hi, How do we filter date and time values such as ‘1/15/2019 4:08:48 PM’ from a range. I have a range, in this range we have a column for dates. And I have stored date be filtered in a cell, let us say, cell A1. And range to filter the dates is B1:B50. How do I filter value from cell A1 in...
  17. ThrottleWorks

    Reply to all for a particular e-mail

    Hi, I am using below mentioned to code to get latest e-mail. I am able to get latest e-mail but not able to do a ‘reply to all’ for the particular e-mail. I am able to ‘Display’ it. How do I do ‘Reply to all’ for the particular e-mail in the loop. Please note, rest of the code is working...
  18. ThrottleWorks

    Get filenames from a folder

    Hi, I am using below mentioned code to get filenames from a folder. However, I am facing a bug at ‘With Application.FileSearch’ line. The code is copied from ‘https://www.automateexcel.com/vba/list-all-files/’. Can anyone please help me in this...
  19. ThrottleWorks

    Not able to add “CustomDocumentProperties.Add Name’ in word document with Excel VBA

    Hi, I am using below mentioned code to add “CustomDocumentProperties.Add Name”. My code is skipping “objWordApp.ActiveDocument.CustomDocumentProperties.Add Name:="YourName", LinkToContent:=False, Value:="thename", _ Type:=msoPropertyTypeString” line. As soon as code hits this line, macro...
  20. ThrottleWorks

    How to get nearest deadline

    Hi, Please see attached file for details. Thanks. Can anyone please help me in this.
  21. ThrottleWorks

    How to save e-mail as PDF with excel VBA

    Hi, I need to export e-mail as PDF and save. User has shared Outlook. In one of the shared account he will have one particular folder. This folder might have n number of e-mails, let us say 500. From this 500, I need to export each e-mail as PDF and save. One more condition is, if the subject...
  22. ThrottleWorks

    How to export each worksheet from a excel file to PDF

    Hi, I have one excel file. This file may have n number of worksheets. For example, 50. Out of these there will be 4 pre-defined worksheets. I need to exclude these 4 worksheets and export remaining 46 worksheets as PDF files. So I will have 46 different PDF files saved from one file. Let us...
  23. ThrottleWorks

    How to open each file from a folder

    Hi, I have a folder. This folder will have excel file with different extensions. XLS, XLSM or XLSB. Files can be of any excel extension. How do I open each file from the folder. Can anyone please help me in this.
  24. ThrottleWorks

    CountIfs for more than 70,000 rows

    Hi, I am trying below mentioned formula in a worksheet. Last row of the worksheet in 70,000 +. I tried applying this formula at one go with usual method. For example, Range(“A2:A” & TempLr) .FormulaR1C1 =...
  25. ThrottleWorks

    Facing issue while opening or saving excel file with macro.

    Hi, I am facing issue while opening or saving excel file with macro. I am using below line to open excel file in my code. “Workbooks.Open (MapSht.Range("A13").Value)” Once macro tries to execute this line, I get pop-up with below message. Downloadig (message header) Downloading: file path and...
Top