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 […]
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. […]
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 […]
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 […]
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 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 […]
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.
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 […]
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? […]
What someone asked me was to make the xml readable, and I needed it last week too. The term is called “pretty print” and that is the function or procedure that needs to be performed on the text to make it work. What I use is Notepad++ with the tool plugin called “XML Tools”. Simply […]