I have recently upgraded to Windows 7 and Office 2010.
I have my Excel documents sorted a certain way that I was used to in Xp and Office 2007.
The new Excel extensions have thrown this off.
I have gotten around this in folder view by removing extensions for known file types.
However, when I perform File - Open from within Excel I find that the extensions are back.
Is there anyway to keep the extensions out of this view as well?
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…