How To Use Excel.Application.GetSaveAsFilename() Method



TODO:

Have you ever wanted to use the Excel.Application.GetSaveAsFilename method to save your files?


SOLUTION:

Excel.Application excel = new Excel.Application();

FileInfo fileInfo = new FileInfo(txtInputFile.Text.Trim());

//so show the save as, and then filter by current extension only....reason is, that SaveAs() will save in current format, so format changes cannot happen here.
object fileName = excel.GetSaveAsFilename(fileInfo.Name, string.Format("Excel files (*{0}), *{0}", fileInfo.Extension), 1, "Save File Location");

 

NOTES:

This example will display the Save As dialog box.  I limit the box to the current file type, as calling excel.SaveAs(filename) will not change the file type.

How To Fix A Missing Local Publishing Profile Visual Studio 2012



TODO:

Have you lost the ability to publish your website locally?  If so, then you lost your profile for local publishing.

 

SOLUTION:

The second post on this link, has a correct solution.  Basically you need to add a new profile, choose File System as the type, and select a valid location.

 

NOTES:

There are no notes on this topic.

How To Add A Custom Pre-Requisite To A Click-Once Application



TODO:

Have you ever wanted to add your own prerequisites to a Click-Once application?

 

SOLUTION:

1.  Follow the instructions here to create a package manifest.

2.  Follow the instructions here to create a product manifest.

3.  Last restart Visual Studio and you will see your prerequisites in the list.

 

NOTES:

There are no notes on this topic.

How To Fix "Team Foundation Error: Login Failure: Unknown Username or Bad Password" Error in Visual Studio



TODO:

In Visual Studio, you try to click on Security or other items, and you receive "Team Foundation Error:  Login Failure: Unknown Username or Bad Password"

 

SOLUTION:

You need to start Visual Studio as your Domain User

start -> run > runas /netonly /user:my domain\myuser "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe

 

NOTES:

There are no notes on this topic.