How to find the code?

[Cooperdam]

I am looking at an Excel spreadsheet that I have to web enable - but I don't see any source or codes. How does this spreadsheet get the data etc.

Where do I find this out?

 

[fumei]

That is not much information to work with.

How do you know that there is any code in the first place?

Have to actually looked in the VBE (Visual Basic Editor) for any code? Because, if there IS code, that is where you see it.

Gerry

 

[PHV]

How does this spreadsheet get the data
Perhaps a QueryTable ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Perhaps a QueryTable ?

To determine if there are any...

dim ws as worksheet, qt as querytable
for each ws in worksheets
  for each qt in ws.querytables
    debug.print ws.name, qt.name, qt.resultrange.address, qt.connection
  next
next

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Cooperdam]

Thank you it turns out that the app is written in Crystal reports and it creates the Excel.