excel - Convert all files from .html to .xlsx in a folder and save as filename using VBA -


my problem header states.

convert files within folder html (downloaded browser) .xlsx format.

  1. i use same folder path store files want converted , supersede on daily basis
  2. the number of files used on daily basis change
  3. there no 'file masks' relevant files ones within folder, there no subfolders
  4. files must opened, converted xlsx , saved again same name of source file.
  5. rinse , repeat until files have been converted , saved within same (or different if easier folder)
  6. i using excel 2011 (for mac) therefore file paths little different, if vba code, there should no issues of using on platform. main difference paths separated : instead of \. e.g. macintosh hd:users:documents:r7m:planning:locations

some of links have researched come close answer here:

opens txt files , saves excel : tried changing of information

looping through files in folder mac : advanced, reference need used. wasn't allowed post 3 links site gives references... think.

this (from link 1) may closest thing need...

private sub commandbutton1_click()  dim myfolder string  dim myfile string  dim foldername string   application.filedialog(msofiledialogfolderpicker)  .allowmultiselect = false  if .show = -1   foldername = .selecteditems(1)  end if  end   myfile = dir(foldername & "\*.txt")   while myfile <> ""  workbooks.opentext filename:=foldername & "\" & myfile 'save excel file  activeworkbook.saveas filename:=foldername & "\" & replace(myfile, ".txt", ".xls") 'use below 3 lines if want close workbook right after saving, dont have lots     of workbooks opened  application.displayalerts = false  activeworkbook.close  application.displayalerts = true  myfile = dir  loop end sub

any great!


Comments

Post a Comment

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

i have button on website when clicked, reveals map. button can seen when page first loads up, when clicked, section holding map slides open , goes out of screen since page loads @ top (normal). want page scroll down bottom of div select when button pushed, if map out of screen. if page scrolled down, , clicks show map button, don't want page jump bottom of map. i tried figure out myself, no luck. seasoned jquery coders able give me guidance? many thanks! map = mapdiv.gmap3("get"); infobox = new infobox({ pixeloffset: new google.maps.size(-220, -310), closeboxurl: '', enableeventpropagation: true }); mapdiv.delegate('.infobox .close','click',function () { infobox.close(); }); jquery(".slidingdiv").hide(); jquery(".show_hide").show(); jquery('.show_hide').click(function(){ lastcenter=map.getcenter(); jquery(".slidingdiv&quo
Read more

javascript - Highcharts multi-color line -

Image
i looking create highchart multi-colored line. if goes down under value, become red, , when comes on value, become green . here picture example: or maybe highcharts have other charts models differentiate high or low level color? you can achieve coloring using lineargradient coloring: color: { lineargradient: { x1: 0, x2: 0, y1: 0, y2: 1 }, stops: [ [0, 'red'], [0.25, 'yellow'], [0.50, 'green'], [0.75, 'yellow'], [1, 'red'] ] } here 0 in stops relates minimum value of series , 1 maximum value, , in between percentages between values. if find percentages according values prior creating chart use correct stops values make relate specific values in data (at least approximately). see this jsfiddle example .
Read more

javascript - Enter key does not work in search box -

tried search guys sorry. input in search box doesnt work (or search) when hit enter when user clicks search button. doing wrong? here code. thanks. <script type="text/javascript"> $(document).ready(function() { $("#submit").click(function() { var url = "http://asla.org/awardssearch.html"; url += "?s=" + $('#googlecse').val(); window.location = url; }); $('#googlecse').keydown(function(event) { if (event.keycode == '13') { $("#submit").click(); } else { //do nothing :) } }); }); </script> <form class="navbar-form navbar-right" role="search"> <div class="search"> <input id="googlecse" type="text" onblur="if(this.value=='')this.value=this.defaultvalue;" onfocus="if(this.value==this.defaultvalue)t
Read more