Inno Setup Command to Siliently Install vcredist

From the command line:

vcredist_x86.exe /q:a /c:"VCREDI~1.EXE /q:a /c:""msiexec /i vcredist.msi /qn"" "

In an Inno Setup script:

[Files]
Source: {src}\bin\vcredist_x86.exe; DestDir: {app}\bin\;

[Run]
Filename: {app}\bin\vcredist_x86.exe; Parameters: "/q:a /c:""VCREDI~3.EXE /q:a /c:""""msiexec /i vcredist.msi /qn"""" """; WorkingDir: {app}\bin; StatusMsg: Installing Micosoft's C/C++ runtime ...

References

• Update regarding silent install of the VC 8.0 runtime (vcredist) packages, Aaron Stebner's WebLog
• Inno Setup MSVC vcredist without bothering your users, Aron 2 Blue
• Choosing a Deployment Method, MSDN Library

Concatenate Multiple Files on the Windows Command Line

If the files are small in size, and you have a small number of them:

type file1.txt > out.txt
type file2.txt >> out.txt
type file3.txt >> out.txt

If you have a large number of large files, this might be a better option:

copy /b file1.dat+file2.dat+file3.dat out.dat /b

or:

copy /b *.dat out.dat /b

Formula to Increment Month in Excel

Given A1 contains the starting date:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

increments the month.

References

Adding/Subtracting n Month(s) To/From a Date, ozgrid.com
Excel forumula to add a month, Computing.Net

Registry Setting to View HTML Source in IE6 with GVim

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\View Source Editor\Editor Name]
@="C:\\vim\\vim60\\gvim.exe"

Dump and Load a SVN Repository

These are the steps I took the last time I needed to move a Subversion (SVN) repository from one machine to another.

* Dump the repository to a file:

   svnadmin dump /path/to/repositories/projectrepo > projectrepo.dump

* If your repository is large, you might want to compress it using your favorite tool. This was on Linux, so:

   gzip projectrepo.dump

* Transfer the repository to the target machine.
* Decompress:

   gzip projectrepo.gump.gz

* Create an empty repository:

   svnadmin create /path/to/new/repositories/projectrepo

* Load the project repository:

   svnadmin load /path/to/new/repositories/projectrepo < projectrepo.dump

Recovering a Deleted Google Account

I just deleted one of my Google accounts by mistake. In panic, I done some web searching on how to restore it. This led me to this page, Why can't deleted Google accounts be recovered? . From there I was led to this form, I can't access my account. After filling in as much information as possible, and submitting the form, my account was restored approximately three hours later. Given that others seemed to have less success, I can only guess I succeed without too much trouble because I could recall some significant details about my account, in particular the date I created it, the password for it, the account creation verification number, and because I linked it to another Google account.

Where is Trac installed on Ubuntu Linux?

/usr/share/pyshared/trac/