ExcelBanter - name of Workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - name of Workbook (https://www.excelbanter.com/excel-programming/276079-name-workbook.html)

René Kerstgens

name of Workbook

I have two workbooks open in Excel. WorkbookName1 and WorkbookName2.

In Workbook2 i want to place with vba the name of Workbook1 in a variable.

After that i want to copy the range A10:b20 from Workbook2 to Workbook1

How to do this???

thanks in advance

René Kerstgens

Ron de Bruin

name of Workbook

See your other thread

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"René Kerstgens" wrote in message ...
I have two workbooks open in Excel. WorkbookName1 and WorkbookName2.

In Workbook2 i want to place with vba the name of Workbook1 in a variable.

After that i want to copy the range A10:b20 from Workbook2 to Workbook1

How to do this???

thanks in advance

René Kerstgens

All times are GMT +1. The time now is 02:14 AM.