Hey All
I need some help
Aim – Create a Macro, which looks at the text file called “Test” which will be located within the file pathway C:\Temp, and manipulate the data into the format which is on the excel spreadsheet
I am hoping the example i have provided on the excel sheet, can give you a clear indication of the what i am trying to achieve
I am really hoping you guys will be able to help
Looking forward to your help
Regards
D
Last edited by masond3; 12-11-2013 at 11:54 AM. Reason: Spelling Mistakes
I'm finding your attached examples confusing. Desired Results contains data that is not in the text file (the names, for example), and data that doesn't appear to come from consistant locations (Merchant # 878000046887, columns C, E, and F have 4, 2, and 4, but the text file looks like they should have 4, 2, and 1). Also, you haven't given an indication of your VBA experience. Responders will often provide simple code solutions, but in this case, it would probably be fairly extensive. I would suggest you start by recording the opening of the text file with fixed-length columns. It may take a few tries to get it as needed, since you will varying record formats for name, headings, and data. When you get that figured out, develop a routine that will have an outer loop for the merchants and an inner loop for the products. If you're completely lost, or just need some more guidance, let us know.
I'm thinking it might be a lot easier to actually do two fixed-length imports: One for the merchant number/name and one for the product data.
This should get you down the road a ways. Rename your Sheet1 to "Results" (or a name of your choice -- just adjust the Constant in the code accordingly). Then paste the code into a code module and save the workbook as a .xlsm. You can run it to see how it works up to this point, then proceed from there. Let me know if you need any other direction. Blessings, and Merry Christmas!
Please Login or Register to view this content.
Last edited by natefarm; 12-11-2013 at 02:20 PM. Reason: Added the code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks