Dear All, I'm new to this group and my programming skills in VBA are a bit outdated. Writing some csv file is quite easy, but I have some restrictions with it.
Hoever, I would like to ask for some quick help on this: I have a workbook (active) and want to create a vba macro manages to: 1) save all sheets in this workbook as CSV files with the name of the sheet 2) ensure that the csv files have no limits in accessing them by other tools while the wokbook is still open 2) keep the workbook in xls format open ( to edit further on ) Any code snipet which helps is welome. Thanks a lot Rolf -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
