modul eller macro til renaming af filer i eksten mappe

Hvad skal de renames til!~)

har du prøvet diverse software, her er et googlet eksempel:

http://www.sharewareplaza.com/All-File-Renamer-download_25986.html

eller skal det være i vba... hvis det skal være vba, så ville jeg hente programmet indlæsfilnavne fra www.makeiteasy.dk og bruge det til at ligge navnene på txt filerne ind i en tabel. Herefter ville jeg lave en dao.recordset funktion, som starter ved første post og så går dem igennem en efter en. Selve renaming'en ville jeg nok forsøge at ligge i en shell funktion, dvs. hvis du kan stykke en dynamisk ren eller rename kommandolinie sammen, så vil du kunne fyre den af med shell!~)

At bruge eksterne programmer er desværre ikke det jeg søger - jeg skal bruge et internt modul, da selve databasen skal "kunne klare det hele selv". Databasen skal nemlig kunne distribueres og efterfølgende anvendes af alle uden nærmere viden (den skal være "point and click for dummies" :-) ) - men tak for buddet :-)

Filerne skal iø blot navneændres fra "ukendt.txt" til "for-defineret.txt"

En idé ...

En *.bat fil i dit bibliotek kan aktiveres fra access og kan hermed udføre det ønskede ....

Rename *.txt *.NogetAndet

det var sgu simpelt - OG DET VIRKER :-) - SUPER

Nogen gange behøver det ikke være så indviklet :-)
Takker for point

"Databasen skal nemlig kunne distribueres og efterfølgende anvendes af alle uden nærmere viden (den skal være "point and click for dummies" :-)"

which also mean the bat file needs distributing too.

true - but it will be distributed as a package - that's not a problem :-)

I've run into a little problem: I've created this little bat-file within the directory:

echo off
rename folder\*txt name.txt

It runs perfectly when I run it from the folder, but when I run it from a macro it can't find the file. It will run if i define the absolute path in the bat file (c:\database_folder\folder\*.txt name.txt). How do I get around this - I'd like to keep the relative path so that it doesn't matter where the database is placed.

try CurrentProject.Path

CurrentProject.path not recognized as a command :(

app.path

Wait a moment, it sthe path in the bat file your having problems with.

.\NameOfFileToRename.txt


If the file(s) ypou want to rename and the database are in the same foleder as the BAT file then .\ should work.

The problem is, that when executing the bat-file it's not run in the "home directory" but from a "MAPI" folder - it seems to open in a temporary folder of some kind - I want to get around this

? Isnt the bat file in the same folder as the dB?

Yes it is - and that is what bothers me - the macro-call to the bat file seems to open outside the folder .....

seems you've been too quick accepting the answer from jensen363 :o)

Not sure what to suggest without making a new solution.

A batch file can be called with paramaters, so why not send the path/filename to the batch file?

http://home.att.net/~gobruen/progs/dos_batch/dos_batch.html

Look at section Batch File Parameters

I have no problem in returning any point´s given on a bad answer :-)

terry: the problem with the parameters is, that I only want to use the relative path in the bat - not the absolute (I will not be able to determine the absolute path, because the user shall be able to install the database at any desired path)

Er det ikke muligt at benytte :

Application.CurrentProject.Path

til at aflæse den til enhver tid gældende placering af din batchfil, og så benytte denne til aktiveringen ????

Dette virker hos mig :

Function RenameFile()

Batchfile = Application.CurrentProject.Path

    Call Shell(Batchfile & "\Rename.bat", 1)

End Function