View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PM4 PM4 is offline
external usenet poster
 
Posts: 1
Default export to csv macro


Hi,

I'm looking for a macro in excel that lets me export to csv.
The filename must be the name of the sheet combined with the month and
year on the moment of export (like finance-052006.csv).
Can somebody help me out? I've been searching for a few hours but no
luck so far. I found macro's with static filenames or with a prompt. I
even tried to eddit the macro's but only got some errors.
It looks like i'll be working woth macro's much more the next few
months so i'm going to spend more time understanding it.

Kind regards,
PM.


--
PM4
------------------------------------------------------------------------
PM4's Profile: http://www.excelforum.com/member.php...o&userid=34025
View this thread: http://www.excelforum.com/showthread...hreadid=537853