ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open a workbook with a name that was recorded in a cell (https://www.excelbanter.com/excel-programming/358931-open-workbook-name-recorded-cell.html)

emil

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