Search results

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

Hi, Can anyone please help me in this.

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

Hi @Kenneth Hobson sir, thanks a lot for the help. I am checking this and will revert with details. Have a nice day ahead. :)

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

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

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

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

Hi @Chihiro sir, thanks a lot for the help. Have a nice day ahead. :)

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

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

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

Hi sir, thanks for sharing. Have a nice day ahead. :)

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

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

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

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. :)

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

Hi @vletm sir, thanks a lot for the help. I am checking this and will revert with details. Have a nice day ahead.

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

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

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

Hi @Khalid NGO thanks a lot for the help. Have a nice day ahead. :)

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

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