| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recorded macro has hard cell contents. | Excel Discussion (Misc queries) | |||
| Excel macro, editing recorded cell.. not current | Excel Programming | |||
| Editing recorded macro code. Referencing workbook name in functio | Excel Programming | |||
| how is the syntax to replace a date, recorded within a macro with a cell value ? | Excel Programming | |||
| how is the syntax to replace a date, recorded within a macro with a cell value ? | Excel Programming | |||
Threaded Mode
