Monthly Archives: November 2016

Linkdump: Excel VBA

Debugging keys: http://www.excel-spreadsheet.com/vba/debugging.htm More debugging, esp. the Debug object: http://www.cpearson.com/excel/DebuggingVBA.aspx User forms: http://www.excel-spreadsheet.com/vba/userforms.htm VBA for filter/copy/paste: http://www.listendata.com/2015/04/excel-vba-filtering-and-copy-pasting-to.html

Posted in Excel, Linkdump | Leave a comment

SQL Server: time zone adjustment that accounts for Daylight Saving Time changes

This pulls the calendar for Daylight Saving Time from the server. DECLARE @time_in DATETIME SET @time_in = GETDATE() — SET @time_in = ‘2016/10/15 09:20:00 pm’ DECLARE @timezone_adjustment INT SET @timezone_adjustment=DATEDIFF(hh,GETUTCDATE(),GETDATE()) DECLARE @time_string NVARCHAR(60) –Convert from stored UTC datetime to local. … Continue reading

Posted in Programming, SQL Server | Leave a comment

Linkdump: CSS within MS Word

http://www.bing.com/search?q=integrate%20css%20into%20word%20document&qs=n&form=QBRE&pq=integrate%20css%20into%20word%20&sc=0-24&sp=-1&sk=&cvid=3A39E61ADFD04F908F18DE80BF73A571 http://superuser.com/questions/65107/how-to-apply-external-css-stylesheet-to-document-in-microsoft-word http://webmasters.stackexchange.com/questions/34115/convert-microsoft-word-documents-doc-x-into-html-files http://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_other/how-do-i-create-a-custom-css-file-for-word/3405d558-fa43-42b7-8aa6-38583804e66d    

Posted in Uncategorized | Leave a comment