input box finds and opens folder in windows explorer -


the problem:

i have 10,000 numbered folders. example:

root/7000-8000/7400/7473/

root/3000-4000/3800/3846/

these network folders "unit folders" contain documents, design, photos, accounting, etc data each "unit" company sells. these documents organized subdirectory. dozens of employees refer these folders hundreds of times per day. tedious drill down folder looking for.

what want:

i want create simple input box, user has enter in unit number, lets between 1 , 100,000, , press enter. system automatically open corresponding "unit folder".

how:

i looking me figure out scripting language need learn done, functions in particular should into, , deal-breakers should know about.

i need sort of input box, simpler better, can stay on desktop or in taskbar. next need parse input digits, , break them down thousands, hundreds, tens, etc. need assemble variables target folder, create correct command send explorer. lastly need issue error if went wrong.

thanks in advance advise!

we got figured out. code attached below if else comes across this:

option explicit  private function checkpath(strpath string) boolean         dim fso new filesystemobject          if fso.folderexists(strpath)             checkpath = true         else             checkpath = false         end if end function  '''''''''''''''''' private sub cmdgo_click() dim unit double 'unit number dim unitth integer 'for thousand of unit dim unithu integer 'for hundred of unit dim locationstring string 'for string store folder location dim exists boolean 'ensure folder exists  locationstring = "z:\unit folders\" if val(txtunit.text) > 90000     unit = val(txtunit.text) - 90000     unithu = fix(unit / 100)      locationstring = locationstring & "rtb90000-90999\rtb"     locationstring = locationstring & "90" & unithu & "00"     locationstring = locationstring & "\rtb90" & unit & "\" else     unit = val(txtunit.text)     unitth = fix(unit / 1000)     if unit > 10000         unitth = unitth + 10     end if     unithu = fix((unit - unitth * 1000) / 100)      locationstring = locationstring & unitth & "000-" & unitth & "999\"     locationstring = locationstring & unitth & unithu & "00"     locationstring = locationstring & "\" & unit & "\"  end if exists = (checkpath(locationstring)) dim x if exists     x = shell("c:\windows\explorer.exe " & locationstring, vbnormalfocus) else     msgbox ("folder not exist") end if  end sub

Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers ...
Read more

keyboard - Smiles and long press feature in Android -

i've created android keyboard. how add features inserting smilies, , using long keypresses display symbols? to create long-press behavior allows select several options pop-up menu, follow guide (specifically pop-up menu section): http://developer.android.com/guide/topics/ui/menus.html smileys (also known emoticons) combination of keys, understood programs , parsed same way. have do, when clicks smiley face on keyboard, simulate pressing of key combination matching emoticon. example, when clicks smiley, should simulate key presses ':' , ')' :). here's list of emoticons: http://en.wikipedia.org/wiki/list_of_emoticons
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());...
Read more