Helpful VBA/ActiveX AutoCAD Links
Some links that can help with designing VBA to handle AutoCAD are below: Iterating through layer collections Delete all objects in a layer How to copy all objects from one drawing to another in autocad through VBA
Take ANY SharePoint 2010 or 2013 Library. Does clicking on “Open in Explorer” hang your computer with an error after 1-2minutes?
Lets say you have a SharePoint Library and want to open in in Explorer to a whack of files by copying them in rather than through the web interface. BUT you cannot as there is an error. In SharePoint’s Library ribbon, you can if you… Click Library -> Open with Explorer And it hangs your […]
Dropbox .. your fired!
Dropbox cannot be run as service and always up has failed us making it so. So … what next? aws s3 and https://sprightlysoft.com/S3Sync/ Windows 10 sync software review http://www.backupreview.com/best-file-synchronization-software/ So far, winners are… (in order) @Max SyncUp (later) Beyond Sync – but will it run on a server w/o the $99 price? other AWS s3 […]
The New Office Add-in helpful links
After researching and finding some good information on the new office add-in I have found the following links that will help anyone in designing them: Build your first excel add-in Excel JavaScript API Excel JavaScript API in detail VSTO vs JavaScript API Office UI Fabric GitHub Library of Office UI Fabric with coding examples Inserting […]
How to deal with files with a name longer than 259 characters?
The fileinfo class that is the standard class to use for getting fullname of a file will produce an error when the path is too long. This is a path that windows allows but the class can’t handle the error. More on the subject is described here. After much research I installed the nuget package […]
Configuring and getting an RDS SQL Server dB from local to AWS – what a pain
The documentation is sooo not complete at AWS to get a dB restored from local to the AWS server. The error I had when i ran the stored proc (below) was “Database backup/restore option is not enabled yet or is in the process of being enabled. Please try again later.” These guys got me started, but […]
Access Sharepoint folder as a unc for automated file add
https://whitepages.unlimitedviz.com/2010/12/unc-path-naming-for-files-stored-on-sharepoint-2/ https://blogs.msdn.microsoft.com/johnguin/2012/06/24/enabling-the-webclient-service-in-windows/ http://www.smartdigitizers.com//other-development-tips/accessing-sharepoint-folders-using-unc/
Update a Visual Studio Project After Installing it using Windows Installer Method
You have to configure two items in the installer as described below: Increase the Product Version number under General Information and then create a Upgrade Path if not done already. Change the Product Code. Now you can do the following steps below. In order to update a project after it has been installed follow the […]
Choose SQL Cloud Service
UPDATE POST RDS trial: OH NO: RDS has no sysadmin rights and the app I need has Stored Procs that need that. So I installed an EC2 instance which is a fancy way of saying “got a computer up and running, logging into it using RDP and installing my own SQL express”. Gee I could […]
Cloud Sync and Storage … where to begin
Google of course. Here are the links that turned up. I am looking for 500GB – 1TB for a customer. Wikipedia site with a great compare – look down at the paid options Good Article to Read – Google vs Dropbox vs OneDrive Why one guy switched from Dropbox to Google Pricing Dropbox (1TB=$10/mo), Google (1TB=$10/mo), SugarSync (1TB=$55/mo), Box.com […]