Search results

Hi @shili12 thanks a lot for the help. :)

Hi, Can anyone help me in this please.

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

Sub SplitName() Dim TempLr_1 As Long Dim MacroBook As Workbook Dim MapSht As Worksheet Dim TempSht As Worksheet Dim TempLr As Long Dim MyArray() As String, MyString As String, i As Variant, N As Integer Dim TempRng As Range Dim TRng As Range Dim ws As...

Hi @AlanSidman sir, PowerQuery is not allowed that is why not able to use your solution. Hence posting below reply however thanks a lot for the help. Hi @Marc L sir, if I could disturb you again on this. Am using code copied from below URL. It is working good. Importing data and splitting in...

Hi @p45cal sir, thanks a lot for the help. :) I am checking this code and will revert with details.

Hi @Marc L sir, thanks for the help. Have a nice day ahead. :) Hi @p45cal sir, thanks for the help. Have a nice day ahead. :) All headers are in the first row of worksheet. Trying with Match method.

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 @p45cal thanks a lot for the help. :)

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 @AlanSidman thanks a lot for the help. Have a nice day ahead. :)

Hi @Marc L , 110 fields are there, My mistake, apologies.

Hi @Marc L I agree with you, my apologies for not uploading original file. Thanks a lot for all the help. It is not allowed hence I would have uploaded at the first post itself. One doubt I just had is, macro is importing same files without any issue with a different code. Files are getting...

Hi @Marc L , thanks a lot for the help. Sorry to trouble you on this. Code is working perfect for the sample file I have uploaded but importing only first line with real data. This is how my real data looks, please give me 10 minutes to upload a sample text file with this data. This is only one...

Hi @Marc L , thanks for the help, facing some issues with my real data. Please give me some time to check in details. I will post my reply with more details. With this code, macro imports only the first line from the text file. I checked the same updated code with sample data I have provided...

Yes, you are absolutely correct @Marc L , no issues with sample file I have shared. Will go back at my environment and re-check, thanks for the help.

Okay, thanks, will re-check again.

Hi @Marc L thanks for the help. Tried your code. Getting bug at below line as application defined or object defined error. .Value2 = V Checked ? Dir(V) = Sample.txt. coming correctly.

Hi @Marc L , created some dummy data. Could you please check the file if you get time. PS - Original data is in similar manner with thousand of rows.

Hi @Marc L , thanks for the help. Attaching files is not allowed from my environment. Dummy files won't help much. I am trying to do something like below. 1) I have folder with text files 2) I need to import all the text files one by one, delimit the data, give headers to the imported data and...

Hi, I tried running the macro with another file. It is getting completed however only first row of the file is getting imported. Not able to understand issue, can anyone please help me in this. Please see below code for your reference...

Hi, I am using below code to split files however facing issues with the code. Macro creates a new workbook and gest stuck at 'Line Input #FileNum, ResultStr' this line. I tried giving different input files to check but still facing same issue. Can anyone please help me in this...

Hi @p45cal sir, thanks a lot for the help. This is working great. :)

Hi @p45cal sir, thanks a lot for the help. This is a requirement came at me. At present user is exporting data manually in Excel. User split the TXT file manually and then import in Excel. I will check exact usage of data.

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