is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate original
worksheet

In the VBIDE you can export the code module (FileExport). This can then be
imported into any other workbook.

But if you mean code attached to the worksheet, this won't work as importing
fails, but you can move the code to a module and use simple single calls to
the macros from the worksheets.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sali" wrote in message
...
is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate original
worksheet

i don't want to export *code*, i want to export worksheet *content* as a
code equivalent.
so, when that peace of code been run, the original worksheet is going to be
rebuilt.

it is something like having "macro record" button on all the time.



"Bob Phillips" wrote in message
...
In the VBIDE you can export the code module (FileExport). This can then
be
imported into any other workbook.

But if you mean code attached to the worksheet, this won't work as
importing
fails, but you can move the code to a module and use simple single calls
to
the macros from the worksheets.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sali" wrote in message
...
is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate original
worksheet

Then that is worksheet specific, and I suggest you record a macro and
re-create from there.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sali" wrote in message
...
i don't want to export *code*, i want to export worksheet *content* as a
code equivalent.
so, when that peace of code been run, the original worksheet is going to
be
rebuilt.

it is something like having "macro record" button on all the time.



"Bob Phillips" wrote in message
...
In the VBIDE you can export the code module (FileExport). This can then
be
imported into any other workbook.

But if you mean code attached to the worksheet, this won't work as
importing
fails, but you can move the code to a module and use simple single calls
to
the macros from the worksheets.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sali" wrote in message
...
is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate
original
worksheet

sorry for not being clear, this "record macro" was just as explanation.
does it mean that is not possible to export an *existing* excel sheet [or
even better whole workbook] as a equivalent macro set of coded instructions?

i may read cell by cell, prop by prop, and write output file with
appropriate macro code, but hoped to find some built-in solution.

thnx.


"Bob Phillips" wrote in message
...
Then that is worksheet specific, and I suggest you record a macro and
re-create from there.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sali" wrote in message
...
i don't want to export *code*, i want to export worksheet *content* as a
code equivalent.
so, when that peace of code been run, the original worksheet is going to
be
rebuilt.

it is something like having "macro record" button on all the time.



"Bob Phillips" wrote in message
...
In the VBIDE you can export the code module (FileExport). This can
then
be
imported into any other workbook.

But if you mean code attached to the worksheet, this won't work as
importing
fails, but you can move the code to a module and use simple single
calls
to
the macros from the worksheets.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sali" wrote in message
...
is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate
original
worksheet

Hi

Sorry, there is no such thing, I like the idea. What you want is a way to
store a meal as a recipe, the only semi-automatic way to do something like
that is to record the cook's actions.

HTH. Best wishes Harald


"sali" skrev i melding
...
sorry for not being clear, this "record macro" was just as explanation.
does it mean that is not possible to export an *existing* excel sheet [or
even better whole workbook] as a equivalent macro set of coded
instructions?

i may read cell by cell, prop by prop, and write output file with
appropriate macro code, but hoped to find some built-in solution.

thnx.


"Bob Phillips" wrote in message
...
Then that is worksheet specific, and I suggest you record a macro and
re-create from there.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sali" wrote in message
...
i don't want to export *code*, i want to export worksheet *content* as a
code equivalent.
so, when that peace of code been run, the original worksheet is going to
be
rebuilt.

it is something like having "macro record" button on all the time.



"Bob Phillips" wrote in message
...
In the VBIDE you can export the code module (FileExport). This can
then
be
imported into any other workbook.

But if you mean code attached to the worksheet, this won't work as
importing
fails, but you can move the code to a module and use simple single
calls
to
the macros from the worksheets.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sali" wrote in message
...
is there some tool to export excel worksheet as vba code?
i mean, to create equal macro, which would, when run, recreate
original
worksheet