Thread: Excel sheet analyzer/generator

Hi

I need a tool, that can analyse existing Excel Sheet, and generate
Visual Basic 6.0 / VBA code, which in turn generate this sheet from scratch
(add new blank sheet, apply all changes).

I'm interested in column/row sizes, cell colors, borders, cell values,
and formulas. I don't need support for VBA.

Does anybody know such tool?

Sub NoToolsRequired()
ActiveSheet.Copy
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Tomasz Klim"
<tklim-ms@komputronik.pl>
wrote in message
Hi
I need a tool, that can analyse existing Excel Sheet, and generate
Visual Basic 6.0 / VBA code, which in turn generate this sheet from scratch
(add new blank sheet, apply all changes).
I'm interested in column/row sizes, cell colors, borders, cell values,
and formulas. I don't need support for VBA.
Does anybody know such tool?

Unfortunately, this is not enough, because I have a very big and complicated
sheet with some tables, and want to scan these tables, generate their
code-version, and then rewrite it to make possible generating similar
tables, but based on user's input.


Uzytkownik "Jim Cone" <jim.coneXXX@rcn.comXXX> napisal w wiadomosci
news:Ob%23$znMjGHA.3496@TK2MSFTNGP04.phx.gbl...
> Sub NoToolsRequired()
> ActiveSheet.Copy
> End Sub
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "Tomasz Klim"
> <tklim-ms@komputronik.pl>
> wrote in message
> Hi
> I need a tool, that can analyse existing Excel Sheet, and generate
> Visual Basic 6.0 / VBA code, which in turn generate this sheet from
> scratch
> (add new blank sheet, apply all changes).
> I'm interested in column/row sizes, cell colors, borders, cell values,
> and formulas. I don't need support for VBA.
> Does anybody know such tool?
>
>

That task description sounds like what some of us do for a living.
Remove xxx from my email address.
--
Jim Cone
San Francisco, USA
jim.coneXXX@rcn.comXXX
http://www.realezsites.com/bus/primitivesoftware


"Tomasz Klim"
<tklim-ms@komputronik.pl>
wrote in message
Unfortunately, this is not enough, because I have a very big and complicated
sheet with some tables, and want to scan these tables, generate their
code-version, and then rewrite it to make possible generating similar
tables, but based on user's input.


Uzytkownik "Jim Cone"
<jim.coneXXX@rcn.comXXX>
napisal w wiadomosci
> Sub NoToolsRequired()
> ActiveSheet.Copy
> End Sub
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "Tomasz Klim"
> <tklim-ms@komputronik.pl>
> wrote in message
> Hi
> I need a tool, that can analyse existing Excel Sheet, and generate
> Visual Basic 6.0 / VBA code, which in turn generate this sheet from
> scratch
> (add new blank sheet, apply all changes).
> I'm interested in column/row sizes, cell colors, borders, cell values,
> and formulas. I don't need support for VBA.
> Does anybody know such tool?
>
>