VBA Excel help

dunk · Mar 11th, 2002, 08:42 AM

Hi, Im looking for what probably is a simple piece of code, but I cant get it to work. it is a .exe file in VB

Open Excel (this works fine)

Open a | delimited file (this works fine)

Save the file as a text file of the same
name without promping the user about a file exists of the same name etc.

now close Excel(I cant get this working)

I hope somebody out there would be able to help me.

dk · Mar 11th, 2002, 09:37 AM

Is your code running from Excel or from VB?

If it's from Excel then use

Application.Quit

If it's from VB then use

xlAppObjectName.Quit

Where xlAppObject name is the name of the variable you're using to reference Excel. If this isn't right then you're probably best off posting the offending bit of code.

Regards,

D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 08:42 AM	#1
dunk New Member Join Date: Feb 2002 Posts: 30	Hi, Im looking for what probably is a simple piece of code, but I cant get it to work. it is a .exe file in VB Open Excel (this works fine) Open a \| delimited file (this works fine) Save the file as a text file of the same name without promping the user about a file exists of the same name etc. now close Excel(I cant get this working) I hope somebody out there would be able to help me.

Mar 11th, 2002, 09:37 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Is your code running from Excel or from VB? If it's from Excel then use Application.Quit If it's from VB then use xlAppObjectName.Quit Where xlAppObject name is the name of the variable you're using to reference Excel. If this isn't right then you're probably best off posting the offending bit of code. Regards, D