Issue:Column header display.
Please help me to fix this at the earliest!!
I am not so familiar with macro and converting a text file to excel using macro. In the text, i can see 152 columns but after converting it to excel, it is showing only 55 (0-55) columns. Header columns are displaying in the 10th line. I want all the 152 columns in the excel. Kindly let me know how to resolve this issue.
You have done a GREAT job by putting together all this wonderful training material on Excel Macros! It will be tremendously useful to the learners.
Thanks for sharing this valuable resource.
can u plz help me to write a macro for:
take a random value less than 100 and add 67.86 to it. in the next row add 67.86 to the above result. this process goes on till A5500 cell.
Hi, after every 10 min. when we click over any link then links are open in another page which is not releted to macro and Office skil.please do the nedfull.
QC Defect All Columns
Also please help to provide the code to extract all defect columns without specifying column name. If possible Pls provide with the feature that VBA add User Labels in the first row of excel.
Thanks a lot, the soln works for me.
I am facing one more issue....VBA extracts HTML in 'Description' and 'Comment' fields. Kindly advise if there is any way to extract Text in these fields as well.