Search results

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 @vletm sir, sorry missed your questions yesterday. I missed the comments in your screenshot. My mistake. I thought you are asking, how am getting result. A9 and A10 do not have any comments. However A8 has comment. Value is B2C3 for A8:A10. That is why A9 and A10 will have comment from A8...

Hi @vletm sorry for late reply. Both the systems are at different locations. Hence delay in reply. It is working with three loops, one goes in serial order, one goes in reverse order and last is for blank records. Will try to post the code. Take care, stay safe. :)

Hi @vletm sir, thanks for the help. I am trying to write condition for the scenario at cell A2. Rest am all done with. Will try to post my code here. However I have written a loop for this and trying to find more efficient way to do it. Have a nice day ahead. :)

Reference file.

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 @p45cal sir, I tried editing second code of yours, it is working great, thanks a lot. Have a nice day ahead.

Hi @p45cal sir, thanks for the help. Am going through your code and will revert if I need more help. Have a nice day ahead. :)

Hi @Debaser sir, thanks a lot for the help, am going through the code once again.

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 @Debaser sir, thanks a lot for the help. You are correct. I am trying this in Excel only. Could you please help me in this if you get time. Have a nice day ahead.

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 @Debaser sir, thanks for the help. You are correct. Code does not use Option Explicit (I do it by default in my own macros). Going back to code and checking position of variables again. Have a nice day ahead. :) Hi @Debaser sir, "code uses the variable in the lines that precede the Dim line...

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

@Ranjushah wishing you all the very best. :)

Hi @jolivanes sir, it is actually my bad. Code is working perfectly outside remote. I need to check why it is not working in remote. Thanks a lot for the help. Have a nice day ahead. :)

Hi @jolivanes sir, one problem at my end. When I run your code at my own system it works perfect. However on my office system (remote environment) this code does not work. It gives me an error saying invalid picture. I tried same code in new workbook but same issue. Path captured by code is...

Hi @jolivanes sir, thanks a lot for the help. Sorry for not uploading sample workbook. I am checking your code and will revert with details. Have a nice day ahead. :)

Hi @vletm sir, thanks for the help. No, it is not working manually either. Have a nice day ahead. :)

Hi, Can anyone please help me this. I tried various times but somehow it is not working for me. Just to help you understand in a better way. I am trying to do something like below. User selects a name from the UserForm List Based on the selection, next UserForm should show image linked to that...

Hi @Marc L sir and @vletm it looks like something is wrong with file or image format. I tried inserting image manually using Image box from Developer's tab (Ribbon option) but got the same pop-up as Invalid Picture. Thanks a lot for the help. Have a nice weekend. :) Will revert with more...

Hi @Marc L sir thanks a lot for the help. Picture changed, file type changed, same issue, do not know what is happening, re-trying. Have a nice day ahead. :)

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 @shrivallabha sir, tried your code too, somehow am missing one record. Did not get time to check yet. However no issues sir, at present I am using my code with FIND function. Thanks a lot for the help. Have a nice day ahead. :)