Slow compilation in VS2005 when using 3rd parity components

         I fought months with terrible slow compilation in VS2005 when using 3rd parity components.
I've tried everything. What I've discovered compilation speeds up when I've disconnected network cable... I've investigated proxies, NICs, DHCPs and lot of similar - no success...

Finally I've hit on an idea disable certificates checking in IE - and hurrah!  

If you experiencing similar problems try do the same
(In IE go to advanced tab and disable "Check for publisher’s certificate revocation" option

The breakpoint will not currently be hit. Debugging problem

Today I'm fighting with VS and debugger issue.

I've placed breakpoint in source but I'm seeing yellow warning:

"The breakpoint will not currently be hit. No symbols have been loaded for this document"

What I've tried / checked to sort this out

1. Checked if I'm in DEBUG mode (it was)
2. Cleaned solution (didnt help)
3. Removed all files from OBJ and BIN folders (helped!)

Remote Debugging in Visual Studio .Net 2005

Steps you need to do to debug remotely .NET application

1. On the remote box start program msvsmon.exe(Usually located in C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\Remote Debugger\x86)
   
   
2. Open VS.
   Click Tools -> Debug Processes .
   
   
3. In the Name box , enter the name of the remote worksation.
   (NOTE:There is required administrative right to connect to remote box)Sometime you need to enter full path to remote workstation like thisdomain_name\user_name@remote_ws_name
   
   
4. Select process you are looking for  and click Attach.
   (NOTE: Common Language Runtime has to be checked)
5. 
   In VS open file(s) you wish to debug. 
   

 

Bloomberg API

Lot of financial companies use Bloomberg (tm) terminals.

Bloombergs offers excellent API for .NET allowing as well as realtime as static data receiving.

On the API / SDKs site Bloomberg offers DLLs witch detail examples.

Interested? Look at "WAPI [GO]" 

Disabling macros while openning Excel files

My development required open and read Excel file with macros inside.
I’ve used my standard lib to open and read file-turned out that Excel macro displays dialog expecting user option selection.
What I’ve looked for was possibility to disabling Excel macros at all. 
I’ve googled a lot and finally found msoAutomationSecurityForceDisable as solution.


Example:

<br />Excel.Application excelObj = new Excel.Application ();<BR><br />excelObj.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityForceDisable;<BR><br /><BR><br />// Create Workbook<BR><br />Excel.Workbook theWorkbook = excelObj.Workbooks.Open ( fileName, Type.Missing, true, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office<br />