• 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

    Getting bug on 'T_Sht.AutoFilterMode = False' line

    Hi @vletm sir, thanks for the help. This module is part of the macro I have written. This module is called by another module. I have tested it on both the locations using same files. But one location does not face any issue, and another location faces this issue sometimes. Not able to...
  2. ThrottleWorks

    Getting bug on 'T_Sht.AutoFilterMode = False' line

    Hi, Can anyone please help me in this.
  3. ThrottleWorks

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

    Hi @AlanSidman sir, thanks a lot for the help. Download not allowed here. Will try from home. Have a nice day ahead. :)
  4. ThrottleWorks

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

    Hi @Kenneth Hobson sir, thanks a lot for the help. I am checking this and will revert with details. Have a nice day ahead. :)
  5. 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...
  6. 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...
  7. ThrottleWorks

    Using VBA With Python

    Hi @areed1192 sir, thanks a lot for sharing. :)
  8. ThrottleWorks

    Wishing a very happy birthday and Eid Mubarak Khalid NGO

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

    exception has been thrown by the target of an invocation

    Hi @Chihiro sir, thanks a lot for the help. Have a nice day ahead. :)
  10. 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.
  11. 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...
  12. ThrottleWorks

    Congratulations @vletm for his 4,000 + helps :)

    Congratulations @vletm sir for your 5,000 + helps to the forum !
  13. ThrottleWorks

    Exciting April update: PowerBI

    Hi sir, thanks for sharing. Have a nice day ahead. :)
  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 @Chihiro sir, thanks a lot for the help. Sorry for late reply. The idea is to pick latest for the day for a particular subject from the selected outlook folder. And export it as PDF. We have an input box in the macro. User will type values for subject line in input box. We have folder...
  16. ThrottleWorks

    How to run code in background

    Hi @Chihiro sir, thanks a lot for the help. Have a nice day ahead. PS – Majority of the time of my code is consumed with below two lines. ‘objMail.SaveAs strWordDocument, olDoc’ ‘objWordDocument.ExportAsFixedFormat OutputFileName:=MyPDFFile, ExportFormat:=wdExportFormatPDF’ Code line no 221...
  17. ThrottleWorks

    How to run code in background

    Hi @vletm sir, thanks a lot for the help. No, I will Google 'DoEvents' and will post here if I required further help. Have a nice day ahead. :)
  18. 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...
  19. ThrottleWorks

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

    Hi @vletm sir, thanks a lot for the help. I am checking this and will revert with details. Have a nice day ahead.
  20. 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...
  21. ThrottleWorks

    Get filenames from a folder

    Hi @shrivallabha thanks a lot for the help. Have a nice day ahead. :)
  22. ThrottleWorks

    Reply to all for a particular e-mail

    Hi, It is done now. Thanks. Used, set OMAIL = OMAIL.ReplyAll
  23. ThrottleWorks

    Get filenames from a folder

    Hi @Khalid NGO thanks a lot for the help. Have a nice day ahead. :)
  24. 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...
  25. ThrottleWorks

    Get filenames from a folder

    Hi @AlanSidman Sir, thanks lot for the help. This is very useful. Have a nice day ahead. :)
Top