How can i save and close the first workbook after opening second workbook from i

[ravikumar00008]

Hi All,


How can i do like this.


I am opening second workbook from the first workbook at that time how can i save and close the first workbook.


So, that one workbook should open at a time.


This is how i tried but not succeeded.

[pre]

Application.Workbooks.Open ("E:Second_Data.xlsx")
Application.Workbooks("E:First_Data.xlsx").Save
Application.Workbooks("E:First_Data.xlsx").Close

[/pre]
Thanks in advance


Regards

Kumar

 

[Luke M]

Since the code is contained in the first workbook, this will only work if the close command is the last thing you want done.

Note, it's a backtick (above the tab key) to post code, not a single apostrophe.

[pre]

Application.Workbooks.Open ("E:Second_Data.xlsx")
ThisWorkbook.Save
ThisWorkbook.Close

[/pre]

 

[ravikumar00008]

Hi Luke,


Thanks for the reply.


Yes it works.


Regards

Kumar

 

[Luke M]

Thanks for the feedback, glad to help.