![]() |
Open a workbook with a name that was recorded in a cell
I try to open a series of Workbooks from a list created in a Sheet, for ex.:
700.xls 701.xls 702.xls 703.xls 704.xls ActiveCell.Select Application.CutCopyMode = False Selection.Copy ChDir "E:\Servim\Livrari dupa inventar" Workbooks.Open Filename:="E:\Servim\Livrari dupa inventar\7011.xls" End Sub and I don't want to mention 700. xls, but to write the content of cell A1 Thank of support. |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com