Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 557
Default Change all files format in folder

Hi all, i need two macros
Macro 1:- which can convert all files in folder from "xls" fromat to
"xlsm"
Macro 2:- which can convert all files in folder back to "xls" format
from "xlsm"
Please can any friend can help.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default Change all files format in folder

what was wrong with bernie's solutions in your other post?

--


Gary


"K" wrote in message
...
Hi all, i need two macros
Macro 1:- which can convert all files in folder from "xls" fromat to
"xlsm"
Macro 2:- which can convert all files in folder back to "xls" format
from "xlsm"
Please can any friend can help.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Change all files format in folder

See also my reply in that thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gary Keramidas" <GKeramidasATmsn.com wrote in message ...
what was wrong with bernie's solutions in your other post?

--


Gary


"K" wrote in message
...
Hi all, i need two macros
Macro 1:- which can convert all files in folder from "xls" fromat to
"xlsm"
Macro 2:- which can convert all files in folder back to "xls" format
from "xlsm"
Please can any friend can 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
Change name of files in a folder TISR Excel Programming 3 April 8th 06 06:24 AM
Change names of Files in a folder TISR Excel Programming 1 April 1st 06 10:40 AM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven Excel Discussion (Misc queries) 1 January 24th 06 03:28 PM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven[_2_] Excel Programming 1 January 24th 06 04:23 AM
Change names of files in a folder to match names in Excel Column saybut Excel Programming 4 February 9th 04 06:26 PM


All times are GMT +1. The time now is 07:27 PM.

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"