Search results

Hi, Hope you are doing good. May I request experts here to share their views about ChatGPT or similar platforms in context with VBA developers. I started using ChatGPT around three months ago. I found it very useful for coding, agree we need to edit the code but most of my questions at least...

Hi, One important update from my side. It is possible that macro was not tested from sending emails with different users. What I meant is, person A creates email, saves in draft, person B from his system tries to send email. This was never tested before, when it was tested, it was found that it...

Hi @Marc L thanks a lot for the help. My confusion, this was working good till few days ago. Stopped working all of a sudden.

Hi, This is an existing macro. I have not developed this macro. This macro created email drafts and save it in draft folder Drafts are saved in group mailbox, multiple people have access to this group mailbox If am the user, I run the macro, macro creates drafts, I send them manually, no issue...

Thanks @pecoflyer for the help. I was thinking that upgrade might be the solution but was not sure about it. Your guidance helped me, now I can proceed accordingly. :)

Hi @pecoflyer thanks for the help. Mine is in About Excel, it is showing Version 1908 (Build 11929.21008 Click-To-Run). Windows 10 enterprises. Have a nice day ahead. :)

Hi, Hope everyone is doing fine. I need help for CHOOSECOLS formula. I have received one file, this file has 'CHOOSECOLS' formula in it. However, when I open the file, the formula is reflecting as =_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(FX!$A$2:$T$50,FX!$N$2:$N$50<0,""),1,4,5,8,10,11,12,14,16)...

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

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

Hi @Debaser thanks a lot for the help. Below code is working good for me. Do not know why, my previous code was not copying related modules hence I got confused. Have a nice day ahead. :) Public Sub CopySelectedSheets() ActiveSheet.Copy After:=Sheets(Sheets.Count) ActiveSheet.name = "Foo" End Sub

Hi, I have a worksheet. In range E11:E30 I have validation as Yes, No. User need to select each cell as either Yes or No. User should not simply copy paste values in these cells. How can I prevent this. Motive is user should select Yes or No in each cell based on their understanding. Protected...

Hi, I have a macro workbook. There are normal modules written in this book and some are written for cell change event. Cell change event codes are written in the particular worksheet and these are running fine. Issue is, I need to create multiple copies of this worksheet as per the user...

Hi, One of the user is facing below issue while running the macro. Other users from same team are able to run this macro. I was not able check the actual macro, this was only verbally communicated. Excel is showing below message on ribbon when macro is opened. SECURITY RISK Microsoft has blocked...

Thanks for the help @AlanSidman , have a nice weekend. :)

Hi Experts, I need your help. Please help me if you get time. I have a worksheet. This worksheet has n number of pivots. I want to extract base data of each pivot table in a new worksheet. Just like how we do manually, we select last cell of pivot table and double click on it to see base data...

Hi @Debaser , actually this part was taking more time than the entire solution hence I dropped the idea for time being. I have exact e-mail signature copied from Outlook to Excel as picture with another code, not able to post that picture in my existing e-mail editing sub. Will re-try once I get...

Hi @Debaser , you may consider this issue as solved. Thanks a lot for you help. :)

Hi @Debaser , thanks for the help. There is one image in e-mail signature. Have a nice day ahead. :)

Please see below code, this is working for me apart from the sign. I am trying to copy the sign picture created by Ron's working code and paste in e-mail body. I am trying to edit below code for the same. Sub OpenEmailWithRange() Call DefineWorksheets Dim olApp As Object Dim olNS...

Okay, how do resolve it, could you please help if you get time. Thanks. Ron's another code works with new e-mail but not able work with the code you have suggested. And with Ron's working code, am not able to get the sign which is saved as a picture in the e-mail body. Ron's code, which created...

Above code skips below check. If Dir(SigString) <> "" Then Signature = GetBoiler(SigString) Else Signature = "" End If If I try to go directly to Signature = GetBoiler(SigString) line then I get bug at Function GetBoiler(ByVal sFile As String) As String 'Dick...

I agree with you @Debaser , thanks for the help, I tried example from his sites, however somehow I am not able to do it. Please see below code if you get time. Sub OpenEmailWithRange() Call DefineWorksheets Dim olApp As Object Dim olNS As Object Dim olMail As Object Dim...

Hi @Debaser , thanks for the help. Please see below if you get time. 1) One e-mail is saved on a hard drive 2) Macro does browsing and selects e-mail 3) Macro opens e-mail based on path populated in the cell 4) Macro edit this e-mail, add few text line, below these paste an excel range 5) Does...

Hi Experts, Can anyone help me in above please. Have a nice week ahead. :)

Hi, Am using below code. Only issue is with the default outlook e-mail signature. Macro not able to populate default e-mail signature. Can anyone please help me in this. Sub OpenEmailWithRange() Call DefineWorksheets Dim OlApp As Object Dim olNS As Object Dim olMail As Object...