Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go back to the previous excel file
I have the following macro that works great:
Sub OpenData() ChDir "Y:\somewhere" Workbooks.Open Filename:= _ "Y:\somehwere\Tables.xls" Windows("calculation.xls").Activate End Sub This works as long as the macro is run in the file "calculation.xls". How can I change it so that it will return to the file from which the macro has been launched? I uderstand that I could change the name "calculation.xls" each time for a new file, but I am sure that I and others will sometimes forget and then have to go manually to that file. Or is it possible to open the file "Y:\somehwere\Tables.xls" without it going to the front? houghi -- This was written under the influence of the following: | Artist : BBC Philharmonic | Song : Symphony 6 | Album : The Beethoven Experience |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go back to the previous excel file
Just store the caption of the active workbook and use it to re-Activate the
window: Sub dural() Dim w As Window Set w = ActiveWindow n = w.Caption 'ChDir....... 'Workbooks.Open Filename:=..... Windows(n).Activate End Sub -- Gary''s Student - gsnu200836 "houghi" wrote: I have the following macro that works great: Sub OpenData() ChDir "Y:\somewhere" Workbooks.Open Filename:= _ "Y:\somehwere\Tables.xls" Windows("calculation.xls").Activate End Sub This works as long as the macro is run in the file "calculation.xls". How can I change it so that it will return to the file from which the macro has been launched? I uderstand that I could change the name "calculation.xls" each time for a new file, but I am sure that I and others will sometimes forget and then have to go manually to that file. Or is it possible to open the file "Y:\somehwere\Tables.xls" without it going to the front? houghi -- This was written under the influence of the following: | Artist : BBC Philharmonic | Song : Symphony 6 | Album : The Beethoven Experience |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go back to the previous excel file
Gary''s Student wrote:
Just store the caption of the active workbook and use it to re-Activate the window: Thanks, works great. houghi -- This was written under the influence of the following: | Artist : Evanescence | Song : Everybody's Fool | Album : Not For Your Ears |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I get back previous version of a file I copied over in excel? | Excel Discussion (Misc queries) | |||
Match Last Occurrence of Numeric Value and Count BACK to Previous | Excel Worksheet Functions | |||
Revert back to previous file version | Excel Discussion (Misc queries) | |||
Go back to previous worksheet | New Users to Excel | |||
Roll back to previous date | Excel Worksheet Functions |