Re: $$Excel-Macros$$ save all sheets as csv and KEEP xls format open for edit (Excell 2003)

2010-08-09 Thread Aindril De
Hey Rolf, You can use the following Code. Public Sub SaveWorksheetsAsCsv() Dim WS As Excel.Worksheet Dim SaveToDirectory As String Dim CurrentWorkbook As String Dim CurrentFormat As Long CurrentWorkbook = ThisWorkbook.FullName CurrentFormat = ThisWorkbook.FileFormat ' Store current details f

$$Excel-Macros$$ save all sheets as csv and KEEP xls format open for edit (Excell 2003)

2010-08-08 Thread rolf.kem...@renesas.com
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 al