Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update from different sheet
I have recorded a basic macro within a file, which opens another file, saves
it, then closes it. Reason being the other sheet needs to be opened to update, the new data which is then read by the first sheet. The problem I am having is that one of the files referenced in file2 doesn't exist, so during the running of the macro, it comes up with the open file dialogue. I have to leave this ref in file2. This needs to be cancelled for the macro to continue. Is there anyway around this? Or even a better way to do this? My macro currently looks like this: ChDir "Z:\" Workbooks.Open Filename:= _ "Z:\May.xls", UpdateLinks:=3 ActiveWorkbook.Save ActiveWindow.Close End Sub Hope this all makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I have a macro update the sheet? | Excel Discussion (Misc queries) | |||
Update from another sheet in same workbook | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Auto Update Sheet Tab | Excel Worksheet Functions | |||
update sheet on the web | Excel Discussion (Misc queries) |