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

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

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 I need help for editing and existing e-mail saved on a drive. Please see below details for your reference. User have saved an e-mail at his drive. We have an Excel macro. Path of this email is saved in a cell in the macro. Macro needs to open the e-mail on the base of path mentioned in the...

Hi Experts, I have an e-mail. This e-mail body has a screenshot pasted. This screenshot is copied from an Excel worksheet. There are around 3-4 columns and 3-4 rows copied from the excel worksheet and pasted as screenshot in an e-mail. Column and row number may vary. My task is, get the...

Hi, I have two excel files. First is parent file, second is child file. Both files have same structure. Same number of worksheets. Child file is replica of parent file. Only difference is parent file has all the records whereas child file has few records. In each worksheet there is one unique...

Hi, This is a post about PowerPoint file. Was not able to find appropriate forum category to post hence posting it. Apologies for violating forum rules. I have this PPT file with me. Prepared by someone else. Not authorized to upload here. There are around 25 slides in this file. Total file...

Hi, I am using below code to find headers in the worksheet. There are more than 10 worksheets in the file that is why am using below Function and Sub to find headers in the worksheet. In one of the worksheet, there are more than 150 headers to be searched, in this scenario code is taking time...

Hi, Am using below code to browse files. I am not able to provide 'Title' option while browsing. Can anyone please help me to provide 'title' option in below code. Sub brws1() Dim rw As Integer Dim cl As Integer Dim Flocation As Variant rw = 6 cl = 3 Flocation...

Hi, I am trying to split imported text in Excel. Am using below code to perform the task. This code runs fine till number of rows are around 3,000. Post 3,000 rows of data, macro gets stuck. Number of columns are 110. How do I resolve this issue. Can anyone please help me in this. Sub...

Hi, I have a TXT file. This file has more than 1 million rows of data. I need to import this file in Excel. For every 50,000 rows of data, macro should create a new worksheet and import the entire data accordingly. How do I do this. Can anyone please help me in this.

Hi, Please see attached file for more details. Kindly note, I have edited column names, references, values for sample purpose. Range A1 to C33 is input. Range E1 to G66 is output. Highlighted cells in yellow is output. In the main file, there will not be two different ranges. I need to work...

Hi, I am required to find text from PPT and fetch the values in Excel. Could you please help me with some related threads. For example, slide one has a a text 'FindMe' I need to find this text from PPT, once found need to extract entire line of the text representing 'FindMe' So it might be...

Hi, I am trying to use code from below URL. Extracting all text from a powerpoint file in VBA - Stack Overflow When trying to run this code, am getting bug as 'Class not registered' at Set p = ActivePresentation this line. Can anyone please help me in this. Sub GetAllText() Dim s As...

Hi, I have a macro with me. Not developed by me. There is a variable defined in this macro. Dim MyString as string. This is not defined at the start of the Sub. There are various code lines written before this declaration and various lines post this line too. If I try to run this code, I get...

Hi, Am using below code to load image in UserForm. File path is correct. File formant and name is also correct. However when I try to run this code I get bug saying Invalid Picture at BOLD line. How di I resolve this. Can anyone please help me in this. >>> use code - tags <<< Sub...

Hi, Please see attached file for reference. Column A is Date records. Column F is the result. Dates in column A might be duplicate too. For example 29-07-2021 can be present 3 times in the data. We need to check last date from the records (usually last row only). In our example, last date from...

Hi, Please see attached file for your reference. Column A is my input. Column F is my output. Value in cell A2 = 20210728. This is not date, if I apply '=YEAR(A2)' it will give me #NUM! However I need to convert this value in a DATE format, to get this I use nested formula in VBA. Please cell...

Hi, Please see attached file for your reference. Column A is the key word to be searched. Column D is the Text to be searched from. I am trying to write a macro for below requirement. Column D will have different text values. Each cell will have different text. This text can be multi line or...

Hi, Please see attached file for reference. At row number 2 is how actual data will look. At row number 15 is the result I am trying to get. Please note, I am trying to get the result row number 2 itself. This attached file is just for reference. Original file will be like this. Table one...

Hi, I am trying write a macro which will extract CSV files from e-mail attachment. 1) User will save e-mail(s) in a folder 2) User will select this folder using browsing button provided in macro 3) Macro will extract all the attachments from all the e-mails in the same folder I am not able to...