Search results

Hi, Can anyone please help me in this.

Hi, Please see attached file for code.

Hi, I am getting below mentioned error while running this code. Can anyone please help me in this. Run time error 462 The remote server machine does not exist or is unavailable Bug is appearing at below line. “wrdApp.ActiveDocument.ExportAsFixedFormat OutputFileName” This line is in the...

Hi, Can anyone help me in this please.

Hi, The code at below mentioned link works perfectly with plain text e-mail. https://www.msoutlook.info/question/saving-emails-as-pdf-files However, for e-mail containing screenshot, pictures and tables. Entire content is not exported to PDF. Pictures or screenshots are cropped from right...

Hi @Chihiro sir, it is working great now. Issue was occurring due system issue. Have a nice day ahead. :)

Hi @Deepak sir, issue is resolved. Solution found in below post (of mine :) ) https://chandoo.org/forum/threads/outlook-email-export-to-excel-getting-errror.26972/#post-161291 Thanks. The code at the link suggested by you is working great. Thanks a lot.

Hi @Deepak sir. I am getting error at below line. Could you please help if you get time. Set MyOlNamespace = Application.GetNamespace("MAPI") Object does not support this property method. I have clicked on all the required references.

Hi @Kenneth Hobson sir, thanks a lot for the help. It is working great. 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 @Deepak sir, how are you ! Thanks a lot for the help. Am checking this and will revert with details. Good night. :)

Hi @Chihiro sir, thanks a lot for the help. I tried somewhat similar code. I copied code from Google. But somehow code is opening only XLSM file and skipping 97-2003 workbook. Please give me sometime to check and revert. Have a nice day ahead. :)

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

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

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.

Hi @Chihiro sir, thanks a lot for the help. Analystcave is really good site. Have a nice day ahead. :)

Hi @vletm sir, sorry for late reply. You are correct. Thanks for the help. Have a nice day ahead. :)

Hi @Chihiro sir, you are :awesome: It is working great. Please give me some time to understand your code. There is no Ya and Su. No formula. You are just awesome. Thanks a lot sir. Have a nice day ahead. :) Sir, please correct me if I am wrong, it seems ("Scripting.Dictionary") is really...

Hi @Chihiro sir, thanks a lot for the help. Please give me some time to check. I will revert shortly. :)

Hi @Chihiro sir, thanks for the help. Below combinations are possible in data. Other than this there are no different values. Combination Ya Ac Ya Dc Su Ac Su Dc Please note, I have used same number of characters and spacing in dummy value. So pattern of original data will be same as above.

Hi @vletm sir, thanks for the help. Strangely machine completes the loop within 40 minutes. However while applying formula machine gets hang. And I can not wait for 40 minutes to get the loop complete. But at present I do not know how to make it faster. I am sorry, did not understand No...

Hi @vletm sir, thanks for the help. I am not able to apply formula at one go. My machine gets hanged. Hence I am trying loop. Have a nice day ahead. :)

Hi @Chihiro sir, yes, you are correct. Sorry for making it lengthy for you.

Hi @Chihiro please see below details if you get time. Original formula is as below “=IF(AND(COUNTIFS(B:B,B2,J:J,"Ya*")>0,COUNTIFS(B:B,B2,J:J,"Su*")>0),"Bike","Car")” B = Concat, this is a concat of three values, example = “11W1A1EURNot found” J has values starting with Ya and Su. We can say...

Yes @Chihiro Really sorry for delay. Please give me some time for details. Data is at different machine (different floor) hence it is taking time for me. Thanks a lot for the help. :)