Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: Excel Column Hidden Determine Check
oXL=ObjectOpen("Excel.Application") oXL.visible = @FALSE oWbks = oXL.WorkBooks oWbks.Open(filename) A=oXL.Columns("A:A").Select ColumnACheck=?????(Check if hidden and return a value) If ColumnACheck== @false (or whatever) HiddenColumn=FileWrite(NewFile,"A") ;This will write "A" to output file with username to be reloaded as saved preferences next time used. endifThanks
If oWS.Range("A1").ColumnWidth=0 ColumnACheck = 1 ;column is hidden Endif
Article ID: W18101
Filename: Check if Column is Hidden.txt
File Created: 2012:03:16:09:24:02
Last Updated: 2012:03:16:09:24:02