How to use Excel workbook.saveas with automatic overwrite

excelObject.DisplayAlerts = False

Set excelObject = CreateObject("Excel.Application")    
excelObject.DisplayAlerts = False
Set wb = excelObject.Workbooks.Add
fullFilePath = importFolderPath & "\" & "A.xlsx"

wb.SaveAs fullFilePath, AccessMode:=xlExclusive,ConflictResolution:=Excel.XlSaveConflictResolution.xlLocalSessionChanges    
wb.Close (True)

 

 

 

https://stackoverflow.com/questions/14634453/how-to-use-workbook-saveas-with-automatic-overwrite

Running Jenkins job after few jobs ended, using Join plug-in

example:

you have 4 jobs, job1, job2, job3, job 4

job1 executes job2 and job3, and you want to run job4 only after both job2 and job3 finished:

Jenkins Join 01

  1. Install the Join Plug in: https://wiki.jenkins.io/display/JENKINS/Join+Plugin
  2. In Job1 > Configure, Post-build Actions, add Join Trigger
    1. Select trigger from drop-down (Success/Unstable/Failure/Aborted)
    2. Check the Run post-build actions at join checkbox, it will open the Post-Join Actions section
    3. check the Trigger parameterized build on other projects checkbox
    4. in Projects to build insert the Job that should run after the parallel Jobs finished (Job4 in our example), select trigger and choos if need to pass parameters
    5. Add more post-build action in order to run the parallel Jobs from the first Job (Job2 and Job3 in our example). if you want to pass parameters use the trigger parameterized build Plug-in (Jenkins Parameterized Trigger plugin)

Jenkins Join 02

 

 

 

 

Run c# program In Jenkins, cannot save Excel files

Usually get this error:

System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot open or save any more documents

After SaveAs method

 

to solve this problem do this works:

  1. Create directory “C:\Windows\SysWOW64\config\systemprofile\Desktop ” (for 64 bit Windows) or “C:\Windows\System32\config\systemprofile\Desktop ” (for 32 bit Windows)
  2. Set Full control permissions for directory Desktop (for example in Win7 & IIS 7 & DefaultAppPool set permissions for user
    “IIS AppPool\DefaultAppPool”

 

See here foe more details:

 

Exclude comments when searching in Visual Studio

Exclude comments when searching in Visual Studio

Shotly:

use regular this expression –

^~(:b*//).*your_search_term

  • ^ from beginning of line
  • ~( NOT the following
  • :b* any number of white spaces, followed by
  • // the comment start
  • ) end of NOT
  • .* any character may appear before
  • your_search_term your search term 🙂