When I double click on an xlsx Excel file, it opens as readonly temp file xl0000001.xls and I cannot save any changes. To work around this, I close the spreadsheet without closing Excel. Then open the same file again and the correct file is opened in readwrite mode.
There are so many ways a user configuration can be in terms of versions of Excel, Office, Windows, SPs, filters, browsers, frameworks, wrappers, and Document Management Systems. It's ridiculous to give users the run around to different groups or forums specializing is artificially segrated topics. Excel users know they're screwed until they (and their correspondents) switch to sane open document format, so they'll try everything with a reasonable effort, then go away. The so-called experts never really solve or fix anything. Users arrive at some passable workaround and just stop coming back.
phone and address
Developer of iPhone apps and web innovations
Thursday, April 28, 2011
Thursday, April 21, 2011
How to set icon for shortcut to HTA
The icon in the upper left corner of the running HTA is specified in the icon attribute of the hta:application tag. Just put in the pathname of the ico file*. Your HTA markup is read and executed by mshta.exe, not explorer.exe. So it makes sense that file explorer will list your hta file with a generic icon. A shortcut to your hta file will also have a generic icon. Nothing got lost or corrupted because your file is just a markup interpreted at runtime containing the name of an icon resource. You never compiled that icon resource into anything to corrupt.
However, after the shortcut has been created, you can change the icon of that shortcut using right-click->properties. Then use the change icon button and pick from a list of windows icon made available thru the DLL that handles shortcuts. After changing your shortcut, copy it back to your distribution folder and the icon will stick. On the client's machine, don't create new shortcut with the hta. Instead, copy the shortcut directly.
We all know that file explorer is schizophrenic in many ways. Windows file shortcuts are binary files that don't show well in notepad. URL shortcuts are text files containing the URL in plain text. As such they should be readable by programmatic processes like AJAX, but some hack in the OS screws that up. That is either braindead or extraterrestrial ingenuity depending whom you ask.
*Btw, the ico file should actually exist. Since this will be read by Windows developers, these types of questions are encountered quite frequently.
However, after the shortcut has been created, you can change the icon of that shortcut using right-click->properties. Then use the change icon button and pick from a list of windows icon made available thru the DLL that handles shortcuts. After changing your shortcut, copy it back to your distribution folder and the icon will stick. On the client's machine, don't create new shortcut with the hta. Instead, copy the shortcut directly.
We all know that file explorer is schizophrenic in many ways. Windows file shortcuts are binary files that don't show well in notepad. URL shortcuts are text files containing the URL in plain text. As such they should be readable by programmatic processes like AJAX, but some hack in the OS screws that up. That is either braindead or extraterrestrial ingenuity depending whom you ask.
*Btw, the ico file should actually exist. Since this will be read by Windows developers, these types of questions are encountered quite frequently.
Subscribe to:
Posts (Atom)