Help me with a simple Macro

[robo0808]

---

Simple ra unta, pero di ko kabalo.

I have a folder which contails multiple files. I want to copy all those files to a new folder but add a .xls para mahimo siya excel file. All of this in a macro using VBA para i incorporate nako sa uban macro.

Experts, please help. Labad na ako ulo.

[salbahis]

i remember when i still do vba there is a vast amount resources sa MSDN, try starting from their...

[ingkiang]

sample like convert a .txt file to .xls?

[robo0808]

sample like convert a .txt file to .xls?

Yes bro. Actually, the files have numeric extensions, like .
C:\Folder1
file.999
file.998
file.997
file.888

I need to copy, transfer to another folder, and then add a .xls extension, like.

C:\Folder2
file.999.xls
file.998.xls
file.997.xls
file.888.xls

[nap_opaline]

Bro try download this freeware basin mka tabang:

Rename Master download and reviews from SnapFiles

[salbahis]

sample like convert a .txt file to .xls?

i think he mean renamed, convertion is much more complicated...

to start heres how you move and rename a file in vba

FileCopy "source-file.000", "destination-file.xls" 

then put this function on a loop....

[snifruz]

bro kung rename ang paagi ani..dali ra kay naa may free software nga makabatch rename ka...dali ra paagi

pero kung iconver siya from one type to another kay murag lisud2x na..but i think naay available na software ana..naa bitaw si mr google... hehehe...

btw bro ang name sa application akong gamit kay faststone photo resizer though pang picture ni siya pero pwede ni morename(add additional text whether before or after sa filename) bisan unsa na klase nga file or even folder..hehehe

[robo0808]

OT. Kinsay way lingaw diha na kabalo aning VBA, naa ko i pa trabaho.

[ChaosOrb]

unsa nga VBA bai...post lang kay atong tabangan