Document Analyzer v1.13.1 Update

[rwunderlich]

An bugfix to Document Analyzer 1.13 is now available on my download page:

http://robwunderlich.com/downloads/

This update fixes a mispelling in the macro introduced in V1.13.

Sorry for the inconvienence. If you have DocumentAnalyzer V1.13, I encourage you to replace it with the V1.13.1 version immeadiately.

-Rob

[pgalvezt]

Thank you Rob. One Question can you explain this please?

RequestEdx

Thanks!

[rwunderlich]

If you are asking about the RequestEdx on my downloads page, this is a VBScript used to trigger an EDX (external trigger) task on QV9 & QV10.

-Rob

[pgalvezt]

Perfect!

Great page congratulations!

Thanks Again

[#5]

Hi Rob,

I'm trying this tool.

But is there any ways we can get the info of hidden objects?

For example, i have many sheets on hidden by default.

Thanks,

nick

[rwunderlich]

Hi Nick,

DocumentAnalyzer should process and report on hidden objects just fine. If it's not working for you, can you upload an example where it's not?

-Rob

[#7]

Hi Rob,

I was looking the at the macro. and the following should cover the hidden sheet?

But it still wont detect my hidden sheet.

If sheetObj.GetProperties.Show.Always = False Then
                        Call writeExpression(sheetObj,sheetObj.Getproperties.Show.Expression.v)
End If

I'm doing something like below in the condition. could this be the cause?

=Sign(Index(GetFieldSelections($TAB_NAME, ',', $(VS_MAXTAB)), 'Receviable')) and V_HOME='REC'
 or
 Sign(Index(GetFieldSelections($PROCESS_NAME, ',', $(VS_MAXTAB)), 'Payable')) and V_HOME='PAY'

So, to bypass this error. i went to the document > security properties, to display all hidden sheets.

then, i load again. and i got an "out of memory" issue. when it's at...

LOAD 
          ExpressionKey,
          trim(subfield(x, '$(delimChar)')) as TempFieldName

This dashboard that i'm loading is around 450MB, and quite heavy on data as we have material number, invoice number and supplier number.

Thanks for your help.

[rwunderlich]

Hi Nick,

Two issues here.

1) I see there is a problem with hidden sheets. Hidden sheets are not getting processed. I don't see a quick solution except for unhiding everything as you have done.

2) The out of memory error is a known problem with documents with many objects. Someone recently provided me with an example doc where this fails but I have not resolved it. I'll post an update when I do.

-Rob

[#9]

Hi Rob,

Thanks for the info.

Awaiting your fix.

Nick

[rwunderlich]

Hi Nick,

I've uploaded a new version, 1.14, to

http://robwunderlich.com/downloads/

This update fixes the "out of object memory" error for very large documents. You will still need to unhide the sheets though.

-Rob