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
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