#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Kill Syntax

I am trying to kill files with the following code;

Dim tmpName2 As String
tmpName2 = TmpName & tmpMonth & TmpYear & "Test.xls"
MsgBox tmpName2
Kill "c:\test\tmpName2"

The name is correct but I get an error on the Kill line of code. What is
the correct code to kill tmpName2.

Thanks, for any help.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Kill Syntax Jim Thomlinson Excel Programming 0 June 1st 06 05:06 PM
Kill Michael Excel Programming 2 August 23rd 05 11:53 AM
'Kill' solomon_monkey Excel Programming 7 January 7th 05 09:56 AM
Kill Syntax and path Joe User[_3_] Excel Programming 3 July 30th 04 09:02 PM
AutoFill KILL Frustrated[_2_] Excel Programming 1 July 29th 03 04:40 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"