Koda: |
ActiveSheet.SaveAs Filename:= _
ThisWorkbook.Path & "\" & Mid(ActiveWorkbook.Name, 0, 4) & ".txt", FileFormat:= _ xlTextPrinter, CreateBackup:=False |
Koda: |
' Shrani aktivni zvezek v isto mapo kot je Workbook in v format "ime zvezka".TXT
ActiveSheet.SaveAs Filename:= _ ThisWorkbook.Path & "\" & ActiveWorkbook.Name & ".TXT", FileFormat:= _ xlTextPrinter, CreateBackup:=False |
rimci je napisal/a: | ||
Ne uspem rešit. Spodnja koda mi shrani aktivni list z imenom zvezka (npr. Zvezek1.xls.TXT). Jaz pa se želim znebiti xls, torej da dobim Zvezek1.txt. Zaradi tega sem uporabil MID, ki pa je formuliram prav...
|
Koda: |
' Shrani aktivni zvezek v isto mapo kot je Workbook in v format "ime zvezka".TXT
ActiveSheet.SaveAs Filename:= _ ThisWorkbook.Path & "\" & Mid(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4, 4) & ".TXT", FileFormat:=xlTextPrinter, CreateBackup:=False |