Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Im trying to open a workbook using a macro. I keep getting an error that the file cant be found
I have two files in the same directory Questions.xl Admin.xl The user opens questions.xls. When they have completed entering data, the macro in questions.xls saves the file and copies one row into admin.xls. I cant specify the path because this application is designed to be saved by different people in different places so I dont know what the path will be. I thought by putting both files in the same directory, the macro would know where to find admin.xls. Heres my code Sub Complete( ' Save the users results, copies the summary information to the admi 'tool, saves the admin tool and closes it. Then it shows the user thei 'result ThisWorkbook.sav Sheets("Name ").Selec Rows("3:3").Selec Selection.Cop Workbooks.Open Filename:="admin.xls Rows("1000:1000").Selec Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= False, Transpose:=Fals Cells.Selec Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBotto ActiveWorkbook.sav ActiveWindow.Clos The error message says admin.xls can not be found. Any suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
How to make opening of workbook conditional of opening of another workbook | Excel Programming |