Thread: 2 things
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 2 things

Nigel,

I looked for deleting of files and only found issues with
rows, colums and such. I want to delete a .csv file from
within word and this .csv file is not open. It's the data
file that is used for the mailmerge. After the mailmerge
i'm done with this particular data in this file.
-----Original Message-----
I thought this thread had already been discussed ??

Deleting a csv is no different to deleting any other

file, do you mena from
within Excel?

"Michael Wise" wrote in message
...
I can not get Excel to quit. I am using

application.quit
second item is after this code.
Here is code:

Open word
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
WordApp.Documents.Open "c:\PSV

Travelog\Travelog
Template.dot"
WordApp.Visible = True
WordApp.Documents("Travelog

Template.dot").Close
SaveChanges:=False

'-------------------
'Close Excel

Application.DisplayAlerts = False
'Workbooks("PSV WO and Specs.xls").Close 'Close
Excel
Application.Quit

'------------------
'Program Ending

' --- Do not modify ---
GoTo EndMain
Main_Err:
Main_Error_Handler

EndMain:

End_Text = "Macro Finished" & vbCrLf _
& "Time Started :" & Start_Time & vbCrLf _
& "Time Completed:" & Now & vbCrLf _
& "Your File is Open in word you may print it
now!"
End_Macro End_Text
End Sub ' Main

second item- How can I delete an .csv file after a
mailmerge takes place in a .dot

Michael





----== Posted via Newsfeed.Com - Unlimited-Uncensored-

Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the

World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total

Privacy via Encryption =---
.