Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have various report extracted from different applications in .txt format. I would like to transfer the same report from .txt format to excel.......the report in .txt is generated on regular basis. The report in .txt format contains many unwanted fileds. Can we write a macro to export the data from .txt to excel so that the fileds required can only be exported to excel. Please help.... Cheers, Mandeep |
#2
![]() |
|||
|
|||
![]()
The simplest way is to record the process of opening a .txt file with the
wizard as a macro. You will have an option for each column to omit it. Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Hi, I have various report extracted from different applications in .txt format. I would like to transfer the same report from .txt format to excel.......the report in .txt is generated on regular basis. The report in .txt format contains many unwanted fileds. Can we write a macro to export the data from .txt to excel so that the fileds required can only be exported to excel. Please help.... Cheers, Mandeep |
#3
![]() |
|||
|
|||
![]()
Thanks Stefi.
But this does not solve my query completely. I think the suggestion given by you can only be done for verticle colomns but in .txt file after a page breck (new page) all the headings (title rows) are repeated so I want that the title rows should not be repeated after exporting in excel. The .txt document has some where around 100+ pages so the heading rows is repeated 100+ times which i don't want. Hope i am able to clear my doubt....... Cheers, Mandeep "Stefi" wrote: The simplest way is to record the process of opening a .txt file with the wizard as a macro. You will have an option for each column to omit it. Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Hi, I have various report extracted from different applications in .txt format. I would like to transfer the same report from .txt format to excel.......the report in .txt is generated on regular basis. The report in .txt format contains many unwanted fileds. Can we write a macro to export the data from .txt to excel so that the fileds required can only be exported to excel. Please help.... Cheers, Mandeep |
#4
![]() |
|||
|
|||
![]()
I'm afraid in this case you have to find a criterium to identify title rows
(e.g. they always begin with certain character(s) or contain certain string, etc.) and this criterium certainly does not apply to your normal data rows. Create a macro which recognizes and delete title rows, and place it in Sub Workbook_Open() Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Thanks Stefi. But this does not solve my query completely. I think the suggestion given by you can only be done for verticle colomns but in .txt file after a page breck (new page) all the headings (title rows) are repeated so I want that the title rows should not be repeated after exporting in excel. The .txt document has some where around 100+ pages so the heading rows is repeated 100+ times which i don't want. Hope i am able to clear my doubt....... Cheers, Mandeep "Stefi" wrote: The simplest way is to record the process of opening a .txt file with the wizard as a macro. You will have an option for each column to omit it. Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Hi, I have various report extracted from different applications in .txt format. I would like to transfer the same report from .txt format to excel.......the report in .txt is generated on regular basis. The report in .txt format contains many unwanted fileds. Can we write a macro to export the data from .txt to excel so that the fileds required can only be exported to excel. Please help.... Cheers, Mandeep |
#5
![]() |
|||
|
|||
![]()
Thanks for the reply.
But Stefi.....I don't how to use criterium to identify the title rows and write MACRO's for that. I just know to how to record macro and not to write a macro. If you could write a macro for me as an example so that I can copy that and make necessary adjustment as required in actual case. If you do require any other info. do let me know. Cheers, Manseep "Stefi" wrote: I'm afraid in this case you have to find a criterium to identify title rows (e.g. they always begin with certain character(s) or contain certain string, etc.) and this criterium certainly does not apply to your normal data rows. Create a macro which recognizes and delete title rows, and place it in Sub Workbook_Open() Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Thanks Stefi. But this does not solve my query completely. I think the suggestion given by you can only be done for verticle colomns but in .txt file after a page breck (new page) all the headings (title rows) are repeated so I want that the title rows should not be repeated after exporting in excel. The .txt document has some where around 100+ pages so the heading rows is repeated 100+ times which i don't want. Hope i am able to clear my doubt....... Cheers, Mandeep "Stefi" wrote: The simplest way is to record the process of opening a .txt file with the wizard as a macro. You will have an option for each column to omit it. Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Hi, I have various report extracted from different applications in .txt format. I would like to transfer the same report from .txt format to excel.......the report in .txt is generated on regular basis. The report in .txt format contains many unwanted fileds. Can we write a macro to export the data from .txt to excel so that the fileds required can only be exported to excel. Please help.... Cheers, Mandeep |
#6
![]() |
|||
|
|||
![]()
Copy here a title row and two or three data rows!
Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Thanks for the reply. But Stefi.....I don't how to use criterium to identify the title rows and write MACRO's for that. I just know to how to record macro and not to write a macro. If you could write a macro for me as an example so that I can copy that and make necessary adjustment as required in actual case. If you do require any other info. do let me know. Cheers, Manseep "Stefi" wrote: I'm afraid in this case you have to find a criterium to identify title rows (e.g. they always begin with certain character(s) or contain certain string, etc.) and this criterium certainly does not apply to your normal data rows. Create a macro which recognizes and delete title rows, and place it in Sub Workbook_Open() Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Thanks Stefi. But this does not solve my query completely. I think the suggestion given by you can only be done for verticle colomns but in .txt file after a page breck (new page) all the headings (title rows) are repeated so I want that the title rows should not be repeated after exporting in excel. The .txt document has some where around 100+ pages so the heading rows is repeated 100+ times which i don't want. Hope i am able to clear my doubt....... Cheers, Mandeep "Stefi" wrote: The simplest way is to record the process of opening a .txt file with the wizard as a macro. You will have an option for each column to omit it. Regards, Stefi €˛Mandeep Dhami€¯ ezt Ć*rta: Hi, I have various report extracted from different applications in .txt format. I would like to transfer the same report from .txt format to excel.......the report in .txt is generated on regular basis. The report in .txt format contains many unwanted fileds. Can we write a macro to export the data from .txt to excel so that the fileds required can only be exported to excel. Please help.... Cheers, Mandeep |
#7
![]() |
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you import data from one Excel document to another? | Excel Discussion (Misc queries) | |||
Import NMEA data to excel? | Excel Discussion (Misc queries) | |||
Import data from web to excel | Excel Discussion (Misc queries) | |||
How do I import MS Project data into Excel? | Excel Discussion (Misc queries) | |||
How do I import data from a SECURED website into Excel? | Excel Discussion (Misc queries) |