csv - Can a Batch File Tell a program to save a file as? (If so how) -
csv - Can a Batch File Tell a program to save a file as? (If so how) -
i trying automate file transfer process work , not sure how have programme save file.
currently have created working batch move log file point of creation right folder , rename include date. utilize start function open file. of works far.
now need file opened go file>save as>save
it doesn't need name changed. programme opens saves cvs , ultimate goal.
unless knows easier way alter log file csv file, open alternative well. in batch file.
windows 7 computer
edit 1*
renaming csv using ren command turns info garbage when opens in excel. going through programme create log csv makes info appear in right format. need know how tell programme save as. since there no shortcut think need way tell push: altf downwards down (arrow keys) come in enter
i realize programs autoit capable of preforming function not going alternative due restraints company computers.
further research lead me post: press keyboard keys using batch file unable find way create thought work case. maybe give go off of though understands more.
edit 2* looks might ugly if understands prove useful need. https://msdn.microsoft.com/en-us/library/8c6yea83.aspx
edit 3* sorry broad question assistance.
the bat far pretty simple:
move /-y "c:\users\xxx\desktop\asi test folder\station 5\station 5 log\station 5 log.log" "o:\lab\asi\logs date\week 2015-4-13"
ren "o:\lab\asi\logs date\week 2015-4-13\station 5 log.log" "station 5 log %date:~4,2%-%date:~7,2%-%date:~10,4%.log"
start "" "c:\users\xxx\desktop\asi test folder\station 5\station 5 log\station 5 log.log
pause
i trying send keys rsview have save program. create csv can opened excel doc created macro converts info more readable/chartable format.
if can save csv can utilize start command 1 time again open in excel run macro.
you should able utilize command line switches this, instead of ever opening file. http://plcview.blogspot.com/2012/03/rsview-enterprise-file-viewer-utility.html
"rsview enterprise file viewer.exe" /md process.log process.csv
csv batch-file logging automation
Comments
Post a Comment