ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Kill Syntax (https://www.excelbanter.com/excel-programming/363024-kill-syntax.html)

Ronbo

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.


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com