41
Sistemas Automáticos / Re: Excel (Duvida)
« em: 2020-09-16 21:14:43 »
Assim? Dá erro.
Citar
Sub PRNtoPRN()
Dim xWs As Worksheet
Dim xcsvFile As String
For Each xWs In Application.ActiveWorkbook.Worksheets
xWs.Copy
wbk.Application.DisplayAlerts = False
xcsvFile = "C:\MetaStock Data" & "\" & xWs.Name & ".PRN"
Application.ActiveWorkbook.SaveAs Filename:=xcsvFile, FileFormat:=xlCSV
Application.ActiveWorkbook.Saved = True
Application.ActiveWorkbook.Close
Next
End Sub