is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. som

  • Thread starter Thread starter Daniel
  • Start date Start date
D

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?
 
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).
 
Back
Top