csv - How can I use absolute path in batch file or force vbs not to need the path? -


i writing batch file , part of converts .csv .xlsx. i've been able incorporate solution post:

convert .csv .xlsx using command line

dim file, wb  createobject("excel.application") on error resume next each file in wscript.arguments     set wb = .workbooks.open(file)     wb.saveas replace(wb.fullname, ".csv", ".xlsx"), 51     wb.close false next     .quit end

it works great, issue must pass absolute path batch file work, so:

csv2xlsx.vbs c:\users\data\ktq\abc.csv

as explained in original thread, doesn't work doing following:

csv2xlsx.vbs abc.csv

this bit of pain if move folder need update path. there way can force vbs take in above command correctly finding file, or can absolute path file in question , pass in somehow? great!

the following script provide path of running .vbs script. can use such script determine path of files.
if, instance, script stored in c:\users\data\ktq\yourscript.vbs", script bellow outputstrmainpathasc:\users\data\ktq` (without trailing backslash):

dim objshell : set objshell = createobject("wscript.shell") dim strpath : strpath = wscript.scriptfullname dim objfso : set objfso = createobject("scripting.filesystemobject") dim objfile : set objfile = objfso.getfile(strpath) dim strmainpath : strmainpath = objfso.getparentfoldername(objfile)   'cleaning no longer needed objects set objfile = nothing set objfso = nothing set objshell = nothing  print strmainpath

so, supposing script in same folder .csv files, able find them all. if have level of files, in c:\users\data\ktq\myfiles\ go if change print part of code above this: 

print strmainpath & "\myfiles\"

adapting code, should this: 

dim objshell : set objshell = createobject("wscript.shell") dim strpath : strpath = wscript.scriptfullname dim objfso : set objfso = createobject("scripting.filesystemobject") dim objfile : set objfile = objfso.getfile(strpath) dim strmainpath : strmainpath = objfso.getparentfoldername(objfile)   'cleaning no longer needed objects set objfile = nothing set objfso = nothing set objshell = nothing  dim file, wb  createobject("excel.application")     on error resume next     each file in wscript.arguments         set wb = .workbooks.open(strmainpath & "\" & file)         wb.saveas replace(wb.fullname, ".csv", ".xlsx"), 51         wb.close false     next         .quit end

Comments

Post a Comment

Popular posts from this blog

sql - can we replace full join with union of left and right join? why not? -

can replace full join union of left , right join? if no,why? 'yes' if t1 , t2 sets (no duplicated rows), otherwise answer 'no'. create table t1 (i int); create table t2 (i int); insert t1 values (1); insert t1 values (2); insert t1 values (2); insert t2 values (3); full join select * t1 full join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 (null) 3 union select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 (null) 3 union all select * t1 left join t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 1 (null) 2 2 2 2 2 2 2 2 (null) 3
Read more

javascript - Parallax scrolling and fixed footer code causing width issues -

i bolted bits of code. 1 parallax scrolling, , other piece of fixed footer code found here: http://codepen.io/madshaakansson/pen/cgjch though after bolting , fixing few issues, have problem different widths. header different width footer, , main content doesnt span whole width of page. have tried adjusting width of content css 100%, made main content span whole width, ended breaking footer. i not sure need change make these different bits of code work together. advice appreciated. my attempt: http://codepen.io/dingerzat/pen/qgbwkk html /*global define: false */ function init() { window.addeventlistener('scroll', function(e) { var distancey = window.pageyoffset || document.documentelement.scrolltop, shrinkon = 300, header = document.queryselector("header"); if (distancey > shrinkon) { classie.add(header, "smaller"); } else { if (classie.has(header, ...
Read more

iOS: Performance of reloading UIImage(name:...) -

i have tableview , each row has icon. 90% of rows have same icon. in cellforrowatindexpath method load image assets folder this: var cellimage = uiimage(named: "myimage") does pose performance problem? os somehow smart enough it's same image each time? better if loaded image once , saved in class variable , assigned each time? uiimage 's named: api does kind of caching. if @ uiimage's documentation , states: use init(named:in:compatiblewith:) method (or init(named:) method) create image image asset or image file located in app’s main bundle (or other known bundle). because these methods cache image data automatically, recommended images use frequently.
Read more