S
S
SMAILAIMEN2015-12-01 17:21:35
Macros
SMAILAIMEN, 2015-12-01 17:21:35

How to convert excel file need macro.?

Need a macro that converts excel file to txt file automatically.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Eugene, 2015-12-01
@yellowmew

people don't know how to google, eh
Powershell

$ExcelObject =  New-Object -Comobject "Excel.Application"
$ExcelBook = $ExcelObject.Workbooks.Open($args[0])
$ExcelBook.Saveas($args[1],6)
$ExcelBook.Close()

Save as in script.ps1
execute in Powershell :
script.ps1 "путь к Excel файлу" "путь к текстовому файлу"
Requires Excel installed on the computer.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question