Log Files to Excel Conversion via VBA Macros In Excel

[amitbehere2002]

Hi All,

I need one help about Log File to Excel Conversion via VBA Macro
Following will be the criteria for Creation of Excel via VBA

1. .log Text File to .xls file Conversion
2. Designated Path for .Log and .xls File
3.It will Automatic Append the .log File in Same Excel
4. Excel To be Named as Current Month
5. Delimited with "," Separated
6. After Limit (of Rows) is over for Excel Row New Excel Has to be Created According to Month

Most Important Criteria is that in Log Files folder 1st file is locked with current Session of Tm1 we need to Ignore that file
As I am Learner for VBA Codes in Microsoft Excel
Help is needed for the same.

Thank
Amit

[lotsaram]

So you are basically asking for someone to provide you with fully specd code? In other words for someone to do your job for you? I'm sure there are many of us here with the necessary VBA skills but as this is a VBA question and not a TM1 question you might be better off posting on mr excel, ozgrid or chandoo forums.

[amitbehere2002]

Hi

Thanks a lot for your Auspicious Reply
But I have posted this Question on TM1 Forum as Some of the People May have faced this issue for Log Files and created a code


Thanks
Amit