Tags » Vba

VBA Coding Best Practice

DEFINITION: Best practices are the agreed general set of guidelines that is believed to be more effective at delivering MS Excel based tools which are: 311 more words


Using Excel as a Front-End for Access

A lot of people may ask the question ‘Why would you want to use Excel as a UI for an Access Database?’.  And they’re right to ask since there are many other tools out there better suited for creating a UI let alone better database tools.   1,175 more words


Word to PDF VBA Converter

My current job role involves producing and handling many  word reports for multiple clients here in Oman. Recently we received a complaint from one client saying that our reports show up as weird characters! 746 more words


Setting Default Desktop Scheduling Options

One of the takeaways from the recent Construction CPM Scheduling Conference in New Orleans last week (other than a couple of hurricanes on Bourbon street) was an acknowledgement that while Microsoft Project does indeed enable best practice scheduling, by default many of the required features are turned off.  327 more words

Project Desktop

Outlook Location Button

I wrote a simple subroutine last year that puts my conference line information into the location window of my Outlook appointments. After showing it to my work buddy, Rizwan, he suggested I post the code on my blog. 796 more words


Первичный анализ очередного фишинга

Краткий разбор свежего семпла подручными средствами (а-ля сам себе sandbox)

И так, приступим к вивисекции.

Пример письма опубликую как только получу разрешение. Если вдруг кто-то забыл, как выглядит типичный современный фишинг – смотрите пример из … 39 more words


Excel VBA Code : Worksheet Object Example 1

Program Code in VBA :
// put values in the cell range A1 to A5 and B1 to B5

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 33 more words