is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?

[Daniel]

is it possible to execute write to the fields in another .xsl form a macro
in another .xsl? e.g. some way to load another .xsl into an .xsl macro and
write to its data?

[Daniel]

i mean xls not xsl

"Daniel" <[email protected]> wrote in message
news:[email protected]...
> is it possible to execute write to the fields in another .xsl form a macro
> in another .xsl? e.g. some way to load another .xsl into an .xsl macro and
> write to its data?
>
>

[Dave Peterson]

Both workbooks are open?

workbooks("book1.xls").worksheets("sheet1").range("a1").value _
= workbooks("book2.xls").worksheets("sheet99").range("b33").value

If you need to do bigger ranges of data, record a macro when you do a copy|paste
or copy|paste special|Values (depending on what you want).

Daniel wrote:
>
> i mean xls not xsl
>
> "Daniel" <[email protected]> wrote in message
> news:[email protected]...
> > is it possible to execute write to the fields in another .xsl form a macro
> > in another .xsl? e.g. some way to load another .xsl into an .xsl macro and
> > write to its data?
> >
> >

--

Dave Peterson