ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find an existing file. (https://www.excelbanter.com/excel-programming/341483-find-existing-file.html)

கற்பகம்

Find an existing file.
 
Hi Group.

A downloaded new application.mde must check for an existing
application.mde with the same name, and import its data into the
downloaded one, and delete the existing version.

Any code samples, suggestions.

Thanks.
Karpagam Elangovan


havocdragon

Find an existing file.
 
I think this is what you are looking for. The "C:\temp\Test.xls" is just an
example, but this is where you put the file path and name to be deleted.

Dim objFSO As Object
Dim strpath As String

Set objFSO = CreateObject("Scripting.FileSystemObject")
strpath = "C:\Temp\test.xls"

If objFSO.FileExists(strpath) Then
objFSO.DeleteFile strpath, True
End If


"கற்பகம்" wrote:

Hi Group.

A downloaded new application.mde must check for an existing
application.mde with the same name, and import its data into the
downloaded one, and delete the existing version.

Any code samples, suggestions.

Thanks.
Karpagam Elangovan



கற்பகம்

Find an existing file.
 
Almost..
But here is the exact problem.

For example I have TEST3.3.mde (New version).
And the user is working with TEST3.2.mde.

When I download TEST3.3.mde, it must automatically import data into
TEST3.3 from TEST3.2, and delete TEST3.2.mde.

Thanks.



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

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