Add created date and last modified time in a cell in Excel

If you want to add the last save time and/or creation date in Excel cells follow this steps (via VBA scripts):

date

1. Hold ALT + F11 keys, that will open the Microsoft Visual Basic for Applications window:

2. Click Insert > Module, and paste the following macro in the Module Window:

Sub Workbook_Open()
Range(“A1″).Value = Format(ThisWorkbook.BuiltinDocumentProperties(“Creation Date”), “short date”)
Range(“B1″).Value = Format(ThisWorkbook.BuiltinDocumentProperties(“Last Save Time”), “short date”)
End Sub

3. Press F5 key to run the macro.

Then it inserts the created date in Cell A1, and inserts the last modified date in Cell B1.
(you can modify the cells by simply editing the script and replacing A1,B1 with the disired cells)

Enjoy !

Facebook down 27.09.2013

It seems that after lots of technical problems Facebook really went down… 
facebook down

facebook down2

Sharepoint sends mail that goes in spam folder | Outlook 2010 / 2013 | Exchange 2010

exchange

A few days ago I received a request from a reader of my blog:

I am a SharePoint Developer and not familiar with exchange server.  I will really appreciate if you can please help me on this:

Issue is that we are sending an email from our custom application in SharePoint to “ALLUsers” group which contains all the employees of the organization. This email is send via SharePoint using SPUtility.SendEmail method. Now, not all the times but some times emails goes to Junk E-mail folder. 
 
We have discussed this with IT and they said they have already added the IP address of our SharePoint Server into “whitelist”. After much discussion, they have send us following code to add it in our email:
 
objMessage.Configuration.Fields.Item(“http://schemas.microsoft.com/cdo/configuration/smtpauthenticate“) = cdoBasic objMessage.Configuration.Fields.Item(“http://schemas.microsoft.com/cdo/configuration/sendusername“) = “abc@dom.com” objMessage.Configuration.Fields.Item(“http://schemas.microsoft.com/cdo/configuration/sendpassword“) = “password_of_abc@dom.com
 
I am not sure that this will work. Also, what else we can do? we are running “Exchange Server 2010 SP2 with Rollup #5″
Solution:

#1. If the Exchange Server spam filter also filters the local relay then:

Probably they only white-listed the ip but that doesn’t make Exchange to also skip the anti-spam policy.
We are talking about a e-mail addresses that is on a server and when you try to send emails to addresses from the same server they go into junk.

To do that, they have to give this command in power-shell:

set-mailbox nameof.mailbox -AntispamBypassEnabled $true

get-mailbox nameof.mailbox | fl *spam*,*SCL*
AntispamBypassEnabled  : True
*replace nameofmailbox with the name of the account configured

#2 If the Exchange Server does not filter local relay for spam: 

You are sending a internal e-mail from a address to a list and it goes to spam but the exchange does not filter local relay.
Then you need to add a safe senders list via a GPO for everyone for Outlook. Because the problem is Outlook has it’s own mechanism for anti-spam.
( For testing before you do that: add this address to safe senders on one computer with Outlook and then send the mass message and see if it still goes to spam –> it should not ).
Tutorial how to make a GPO for this can be found here.

If you have problems / questions / ideas please you can comment here or contact me

Enjoy !

How to boot in safe mode Windows 8 ( The easiest way )

One of the first problems that a Windows 8 user has is….
“How can I boot in Safe Mode… the classic F8 is not working….” 

The easiest way is: 

1. Press Windows Button and write msconfig, and Enter
1
2. Go to Boot Tab, and select Safe Boot:

*Other info:
Minimal is the normal safe mode.
Alternate Shell is a safe mode with command prompt console
Network is a safe mode with network

4

3. Restart

3

4. After reboot you will be in safe mode. Do your work ^_^

5. After you finished you have to go back to msconfig ( step 2 ) and un-check safe mode, and then restart:

*If you do not do this step after reboot you will be again in safe mode !
4
Enjoy !

Windows 8 Keyboard Shortcuts ( complete list )

1

New Windows 8 Keyboard Shortcuts

Win – Display Start Menu
Win + Mouse Scroll Wheel – Zoom in and out on the Start Menu
Win + L – Lock your PC and return to logon screen
Win + P -Projector Options
Win + X – Admin tools menuWin + Enter – Starts Windows Narrator
Win + (plus sign + ) – Screen zoom in
Win + (minus sign – ) – Screen zoom out
Win + Print Screen – Saves a screenshot in the picture library screenshot folder
Print Screen – Saves a  screenshot to clipboard
Alt + Tab – Classic app switcher
Win + Tab – Metro app switcher
Alt + F4 – Close application (Desktop and Metro)
Tab – Select different items
Ctrl + C – Copy
Ctrl + X – Cut
Ctrl + V – Paste

New interface shortcuts
Win + C – Displays charms
Win + Z – Displays app bar
Win + I – Settings side menu
Win + K – Devices menu
Win + H – Share menu
Win + F – File search
Win + Q – Application search
Win + W – Settings search
Win + (period . ) – Snap Metro app to the right
Win + Shift + (period . ) –Snap Metro app to the left
Arrow keys + spacebar – Select app tile

Shortcuts for desktop
Win + D – Show Desktop
Win + M – Minimize to Desktop
Win + R – Run
Win + T – Taskbar previews
Win + U – Ease of Access Center
Win + Pause / Break – System Information
Win + comma – Peek at desktop
Ctrl + Shift + Escape – Task Manager
Win + Right Arrow – Aero snap right
Win + Left Arrow – Aero snap left
Win + Up Arrow – Aero snap full screen
Win + 1 through 9 – Launched applications pinned to the taskbar

Shortcuts for File Explorer
Win + E – Open File Explorer
Ctrl + N – Additonal File Explorer window
Alt + F + P – Open Command prompt at current location
Alt + F + r – Open PowerShell prompt at current location
Ctrl + Mouse Scroll Wheel – Change view
Ctrl + Shift + N – New Folder
Alt + Enter – Selected File/Folder Properties
F2 – Rename selected item
Ctrl + F1 – Show or Hide Ribbon
Alt + Up arrow – Navigate up a folder
Alt + Left Arrow – Navigate to previous folder
Alt + Right Arrow – Navigate forward

Shortcuts for Internet Explorer 10
Ctrl + B – Favorites Manager
Ctrl + D – Add site to Favorites
Ctrl + I – Favorites List
Ctrl + G – Feeds
Ctrl + H – History
Ctrl + J – View Downloads
Ctrl + N – New Window
Ctrl + P – Print
Ctrl + Shift + P – Open InPrivate mode tab
Ctrl + T – New tab
Ctrl + K – Duplicate tab
Ctrl + W – Close tab
Ctrl + Shift + T – Reopen closed tab
Ctrl + Tab – Switch between open tabs
Ctrl + R or F5 – Refresh Page
Ctrl + U – View Source
Ctrl + F or F3 – Find on page
Ctrl + E – Move cursor to address bar to search the web
Alt + Home – Homepage
Alt + Left Arrow – Back
Alt + Right Arrow – Forward
F10 – Menubar
F11 – Toggle Full Screen Mode
F12 – Developer Tools

Shortcuts for Internet Explorer 10 Metro
Ctrl + E – Move cursor to address bar to search the web
Ctrl + F or F3 – Find on page
Ctrl + R or F5 – Refresh Page
Ctrl + P – Print
Ctrl + T – New tab
Ctrl + K – Duplicate tab
Ctrl + W – Close tab
Ctrl + Tab – Switch between open tabs
Ctrl + Shift + T – Reopen closed tab
Ctrl + Shift + P – Open InPrivate Mode Tab
Ctrl + L or F4 – Open address bar
Alt + Left Arrow – Back
Alt + Right Arrow Forward
The pretty nice list can be found here: download a PDF or XPS

How to activate Windows 8 Enterprise

How to activate Windows 8 Enterprise ? 

1. Press Start button ( from the keyboard ) / and type cmd :
1

2. Select the Command Prompt and click on the Run as an administrator :
2
3. Type: slmgr.vbs -ipk “WINDOWS-8-ACTIVATION-KEY” 
*Replace “WINDOWS-8-ACTIVATION-KEY” with your Serial Number 
3
If you have problems don’t hesitate to comment / contact me. 

Enjoy !

Blog is back online / Hosting problems

Because of some serious problems with the hosting provider I had to move the blog, and took it offline for a few months to move it to another host. 

Thanks BlueHost for support. Really a super professional hosting company. 
logo

Thank you all for the support & in the next days I am going to upload new materials with Windows 8 / Exchange server 2013  & other interesting things. 

HowTo Whitelist a domain or email address in Microsoft Exchange 2010

exchange-2010-logo-e1344444075384

First of all, what is a whitelist ?
A whitelist is a list of known safe email senders.  Whitelists can be made up of IP addresses, domain names, or email addresses.  In most cases businesses will choose to whitelist domain names of highly trusted customers or suppliers, or email addresses that are the source of critical emails.

Whitelist features are not available via Exchange Management Console (the GUI), so this will have to be completed via the Exchange Powershell Open powershell via the exchange menu item and run one of the following scripts, based on your requirement:

To check whats currently whitelisted (Bypassed Recipients):

Get-ContentFilterConfig

To whitelist a single email address:

$list = (Get-ContentFilterConfig).BypassedSenders

$list.add("new.mail@address.com")

Set-ContentFilterConfig -BypassedSenders $list

To whitelist an entire domain:

$list = (Get-ContentFilterConfig).BypassedSenderDomains

$list.add("domain.com")

Set-ContentFilterConfig -BypassedSenderDomains $list

ENJOY.

And if you encounter any problems feel free to comment contact me.

How to check if standard or enterprise Exchange 2010 is installed?

This thing can be done by using the GUI or by using Powershell.

A. Using GUI

1.Open EMC / Expand untill you get to Server Configuration ( and click on it ) / On the right panel will appear the server configuration:

2. Click on View / Add/Remove Columns

3. In the window that appears click on Edition and the Add / then OK:

4. After that the column with the edition will appear:

B. Using Powershell

1. Open Microsoft Exchange Management Powershell
2. Run the following command:

get-exchangeserver


ENJOY.

And if you encounter any problems feel free to comment contact me.

Forefront Protection 2010 for Exchange Server 2010 | Antispam / Test

First of all why do you need Forefront Protection for Exchange Server ?

Microsoft Forefront Protection 2010 for Exchange Server (FPE) provides fast and effective protection against malware and spam by including multiple scanning engines from industry-leading security partners in a single solution. FPE provides customers with an easy-to-use administration console that includes customizable configuration settings, filtering options, monitoring features and reports, antispam protection, and integration with the Forefront Online Protection for Exchange (FOPE) product. If you have installed FPE on multiple Exchange servers, such as in an enterprise, you can manage them with the Microsoft Forefront Protection Server Management Console (FPSMC). Additionally, you can use Windows PowerShell, a command-line shell and task-based scripting technology that enables the automation of system administration tasks, to administer FPE.

Installing FPE on a Mailbox / Hub Transport Exchange Server

  • During installation you’ll be asked whether or not to enable Antispam, the default will be to not enable it.  That’s what we want, we’ll leave that task to the Edge server.
  • FPE on an internal machine will provide Antivirus and Antimalware protection.  You’ll also be able to run on-demand scans of individual mailboxes if you so choose.

Installing FPE on an Edge Transport Exchange Server

  • This time the default will be to enable Antispam, which is exactly what we want.
  • Edge servers don’t have direct access to any mailboxes, so you can’t run scans on selected objects from here.

Update FPE Spam Definitions and Engines

  • Spam/Virus/Malware definitions should come through Windows update automatically.  Just be sure they’ll install automatically.
  • To update your FPE Engines, browse to your Policy Management -> Global Settings -> Engine Options and choose Update All Engines Now from the options pane.

Send Test Emails

  • To test if Antispam is functioning properly head on over to Gtube.net.  Send a Gtube test from an external domain and you should receive an automatic reply that the mail is undeliverable:#550 5.7.1 Message rejected due to content restrictions ##
  • To test Antivirus/Antimalware, use EICAR.org.  Send the EICAR signature as an attachment from an external domain and you should receive the email, but the attachment will be quarantined.