Hello, I would like to know how can I do wrap text for all sheet
Page 1 / 1
Hi @ahmed belal ,
Could you give this a try?
Set xlObj = CreateObject("Excel.Application")
xlObj.visible = False
'Filepath goes in here
Set xlFile = xlObj.Workbooks.open(WScript.Arguments.Item(0))
'Section which performs the wordwrapping
For Each wk In xlFile.Sheets
wk.Cells.WrapText = True
Next
xlObj.ActiveSheet.Range("A1").Select
xlFile.Save
xlFile.Close
xlObj.Quit
Kind Regards,
Ashwin A.K
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.