shellnomad.blogg.se

1. #EXCEL DO NOT HAVE OPTION TO CHANGE DEFAULT FILE LOCATION HOW TO#
2. #EXCEL DO NOT HAVE OPTION TO CHANGE DEFAULT FILE LOCATION FULL#

the file is indeed open twice, once for %1 in the line of action and again for %1 in the DDE message.

the double quotes around the %1 in the line of action are needed for a path with interstitial spaces can be interpreted correctly.Ģ. This brings me to two tentative conclusions:ġ.

#EXCEL DO NOT HAVE OPTION TO CHANGE DEFAULT FILE LOCATION FULL#

Note that the full path is "C:\Documents and Settings\Joe\My Documents\Temp\Book1.xls". However, I get several errors when I click on the icon of the Book1.xls file in a Temp folder, namely:ĭocuments\Temp\Book1.xls could not be found.ĭespite these errors, the Excel file is opened correctly. If I remove the double quotes in the "open" action line, I do not receive guests enable double-macro. The same is true if I close the file Options window, then re-open it. In other words, if I change the %1 and reference '%1', click OK, and then click on Edit again, %1 (without the quotes) reappears at the end of the two lines of action 'new' and 'open '. (Old Excel 2003 puts up-to-date and perhaps more older MSWin XP SP3 updates to date.)īut if I try to delete the reference %1, XP (?) restored automatically, but without the quotes in the line of action "open". It does not appear in the line of action on another PC. It would not surprise me if the reference for %1 in the action line is redundant and root cause of the problem. Unfortunately, I do not know what that file type Advanced had my experiences. It simply may not be obvious without the enable macro prompt.Īlso note: I don't get the enable macro double guests when I open the file in Excel, for example by clicking on the name of the file in the list of recently opened files in Excel. Note: I think that the root cause, twice, opening the Excel file may exist even for files Excel without macros. I did not notice the problem then because I couldn't have clicked on a file icon for the Excel file with macros. I suspect that this began after I was experimenting with different Types of files advanced under Tools > Options for files in a folder. Specifically, if I start Excel (new book), add a dummy macro (Sub doit() / End Sub), and save Book1.xls, when I then click Book1.xls, I get two guests enable macro.

#EXCEL DO NOT HAVE OPTION TO CHANGE DEFAULT FILE LOCATION HOW TO#

ERGO, I don't know how to reverse the trend.Īll of a sudden, when I click on a file icon to open an Excel file with macros, I am invited twice to activate the macros (medium security). Behavior of the ADV change corrupt Excel File Types?