Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10305 > unrolled thread

How to close an open excel using MS Access VBA

Back to article view | Back to comp.databases.ms-access

Contents

  How to close an open excel using MS Access VBA Barry Wright <barry.edmund.wright@witstoronto.ca> - 2015-01-24 16:23 -0800
    Re: How to close an open excel using MS Access VBA "Phil" <phil@stantonfamily.co.uk> - 2015-01-25 09:41 +0000
    Re: How to close an open excel using MS Access VBA Abhijeet Gudur <gopal.abhijeet@gmail.com> - 2015-02-09 18:12 -0800

#10305 — How to close an open excel using MS Access VBA

Hi,

I have an open excel spreadsheet: C:\Excel Files\Entries.xls

What is the vba code that would close this file?

Thanks,
Barry

[toc] | [next] | [standalone]

#10306

On 25/01/2015 00:23:19, Barry Wright wrote:
> Hi,
> 
> I have an open excel spreadsheet: C:\Excel Files\Entries.xls
> 
> What is the vba code that would close this file?
> 
> Thanks,
> Barry
> 

Try

    Dim MyXL As Object

This bit opens the Excel application

       Set MyXL = CreateObject("Excel.Application")
       MyXL.Application.Visible = True
       Workbooks.Add

This bit closes it

       ActiveWorkbook.SaveAs Path
       MyXL.Application.Quit
       Set MyXL = Nothing

Path is the full path of the Excel file

Phil

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

[toc] | [prev] | [next] | [standalone]

#10340

wb -  C:\Excel Files\Entries.xls 
wb.close
set wb = nothing

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web