hi
I have a folder with a lot of notepad files. I need to extract certain info from each file for example as per attached notepad file opened in excel
see sheet 2
company name is the heading and below it I want to copy the company name etc.
Is it possible to this with a macro ?
Hi,
if text files, it's possible, just read VBA inner help of Open, Input # and Line Input # statements …
Hello platesigns,
Is the Notepad file on sheet 8f30f76f-e047-489a-9e6f-43f0ade?
If so then your text file is actually the page source for an HTML file. Is this format the same for all files in the folder?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello platesigns,
The attached workbook has the macro code shown below installed. There is a button on "Sheet1" to run the macro.
The macro assumes the text files are in the same folder as the workbook. If the files are not in this folder, change the macro variable Folderpath (in blue font) to where your files are saved.
Module1 Macro Code
Please Login or Register to view this content.
hi
yes the notepad file I imported into sheet 8f30f76f-e047-489a-9e6f-43f0ade
but the problem is some files have less lines then others and some have more so it complicates it for me if I search by line no.
Hello platesigns,
The attached workbook will open all text files in the same folder that the workbook is saved in. This will occur when the workbook opens or you manually click the button on "Sheet1".
You can change the folder location in the macro CopyFileData in Module1. If your worksheet name is not "Sheet1" then you will need to change this match your sheet's name.
How this works is each text file is read and converted into an HTML file. The elements of the HTML file are scanned and the data is collected. The collected data is the output to the next empty row of the worksheet.
Here are the macros...
ThisWorkbook Module
Moudle1 MacrosPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks