Port and host scanner IN JAVASCRIPT
So I am a little paranoid about downloading this kind of software – so I searched “javascript host ip scanner”. This is a slick little tool that does the job.
Getting the user to pick an Excel cell range via a dialog …
I have made a couple tools with setup variables that I wish to keep in Excel and not really accessible to the end user per-se. So I use named ranges. However, rather than type up elaborate setup documents for a spreadsheet – the end user said “can I get a helper routine to fill all […]
XML to drive very generic queries
So I had the idea for a project that the easiest way to get some customization into a dB driven system is to use XML – but that would require an engine being built in some platform. Most of the horsepower for his part of the project is in SQL server. So I went surfing. […]
SQL Connections, Drivers and ODBC drive me crazy. Here is one that worked. Import to Excel from SQL Server
What I am rying to do is use a stored proc in SQL Server and feed it some parameters making it dynamic. What the stored proc does is a query to an excel spreadsheet and compares whats different in a SQL database. The crazy part was that using ADODB in VBA worked once under certain […]
VBA Classes 101 links
I often have to refer to this so here are some bookmarks to remember. this is a good primer once you have the over all syntax. I uses classes often – just not my own so much in VBA since the application is different. I usually do “get in -= do = get out” programming […]
AutoCad copy/paste to and From Excel
I am not sure why this seems so hard – there must be a good reason that I don’t understand, but upon a copy/paste to and from Excel, it is seems oddly strange that AutoCAD does not auto-translate into the standard that is common across the whole world. I know one can link and some […]
Drive Space getting you down – automate it…
Drive Space for local backups (local mean QUICK backups) can get ownerous and it constantly needs user interaction. Well lets put a stop to that and fullfill a dream I have. a) cull either on a date or file limit basis b) cull rules are to keep last item in the year last item in the […]
add jQuery and/or scripts to pages that you don’t have control over
Perhaps there is a already a plug in written… in firefox. Firefoxplugin to hid element. Write a jQuery Plugin? not quite the focus I think. Try this. Firefox xul application? Try This.
Windows cmd to ‘touch’ a file and update the date/time
http://support.microsoft.com/kb/69581 uses the copy command in a special way. A great resource of unix commands in powershell including the touch command. What this was needed for was to kick off a script that works off dates changing. Update the date and the process kicks off. Not my idea – but this was my way to get it […]
AutoCAD auto cleanup – a script on close
Research links: talk of general cleanup that one should do triggers in AutoCAD are called reactors (this is a good starter article) A colleague mentioned not to do anything that takes up too much time on a document close reactor – because it triggers AFTER the close has been issued. I suggested on a save? […]