H
Hodge
Hi,
I am having trouble accessing a particular XLSM spreadsheet via OleDB from
vb.Net and FW 2.5.
As the spreadsheet was given to me, I was unable to access the desired
sheets. I was sanitizing the spreadsheet to send to someone and I went to
run document inspector to see if I needed to clean any other information out.
First, the inspector told me that it could not run because I had protected
worksheets. So I unprotected the protected worksheets and re-ran the
inspector. It told me that that I had 1 hidden worksheet. So I let it
remove that.
Anyway, once I had performed the above steps, I was able to access the
desired worksheets.
I also tried saving the original XLSM as an XLSX and got the same results as
witht eh original XLSM file. I was able to access the data by saving the
XLSM as an XLS file.
As a test, I restored my copy and just removed the protection from the
protected worksheets and did not unhide the other worksheet and was still
unable to access the data without getting the error that I got before. I can
only access the data after clicking on Remove All for the Hidden Worksheets.
The problem now is that I was unable to find a worksheet to unhide from the
Format/Hide and Unhide/Unhide sheet as this option was disabled. So I looked
for any VeryHidden sheets via VBA (going through the worksheets collection)
and visually in the project exlporer tree, but found nothing.
Here's the code I used to look into the collection:
Sub ShowSheets()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
MsgBox wks.Name & " - " & wks.Visible
Next wks
End Sub
How can the document inspector see a hidden sheet and I cannot?
Can you tell me whether or not the Remove All command for the hidden
worksheet in the document inspector actually deletes or unhides a worksheet?
Also, can you tell me exactly what should be able to stop me from being able
to access the data? Items such as hidden worksheets/cells, protected
worksheets/cells, etc.
Thanks,
Bobby
I am having trouble accessing a particular XLSM spreadsheet via OleDB from
vb.Net and FW 2.5.
As the spreadsheet was given to me, I was unable to access the desired
sheets. I was sanitizing the spreadsheet to send to someone and I went to
run document inspector to see if I needed to clean any other information out.
First, the inspector told me that it could not run because I had protected
worksheets. So I unprotected the protected worksheets and re-ran the
inspector. It told me that that I had 1 hidden worksheet. So I let it
remove that.
Anyway, once I had performed the above steps, I was able to access the
desired worksheets.
I also tried saving the original XLSM as an XLSX and got the same results as
witht eh original XLSM file. I was able to access the data by saving the
XLSM as an XLS file.
As a test, I restored my copy and just removed the protection from the
protected worksheets and did not unhide the other worksheet and was still
unable to access the data without getting the error that I got before. I can
only access the data after clicking on Remove All for the Hidden Worksheets.
The problem now is that I was unable to find a worksheet to unhide from the
Format/Hide and Unhide/Unhide sheet as this option was disabled. So I looked
for any VeryHidden sheets via VBA (going through the worksheets collection)
and visually in the project exlporer tree, but found nothing.
Here's the code I used to look into the collection:
Sub ShowSheets()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
MsgBox wks.Name & " - " & wks.Visible
Next wks
End Sub
How can the document inspector see a hidden sheet and I cannot?
Can you tell me whether or not the Remove All command for the hidden
worksheet in the document inspector actually deletes or unhides a worksheet?
Also, can you tell me exactly what should be able to stop me from being able
to access the data? Items such as hidden worksheets/cells, protected
worksheets/cells, etc.
Thanks,
Bobby