Hi Rob!
So your files had been saved as XSLM? I haven't even looked at those new
extensions so far, and right now I don't have access to that Office
installation. Have you modified the open command for XSLM accordingly,
or did you stick with my instructions literally which only mention XSL?
I used to sign my macros with a simple self signed certificate, which
made macro trust inherent to the file and not dependent on file
location. But of course, the directory based solution seems more simple.
On the whole I am not conviced at all by this new Office version.
1. Things in the toolbar were always accessible by one click.
Now I have to select the right tab first.
2. Seldom used stuff was in the menus and had clear names. Now I only
see symbols, and have to use tooltips to know what they do.
3. Most programs had the same interface based on menus, toolbar, working
area. Now I have to lern new user interface concepts as Office, IE,
Media Player are different from each other and from the whole rest.
4. Applications could be adapted to work with really small screen
resolutions or simply small windows. Judging by the amount of area
those new toolbars consume, you are effectively forced to run in full
screen mode with some not-too-low resolution.
About your suggestion of dual core processors: hello, has the world gone
insane? Office applications are about handling office data, not about
simulating fluid dynamics or rendering 3D movies! They might require
some memory, but should require near to no CPU. But that it should be
like this doesn't make it so, and I fear you might still be right, and
it might be designed for advanced processors simply because it's easy to
waste resources.
For all these reasons, I did not yet update on my notebook and probably
never will. And that's why I can't check about .xslm right now.
Martin
Rob wrote:
Hi Martin,
I had done it that way so nothing to try other than your further
suggestions.
However, I was having some other problems with macro security. I had made My
Documents and its sub folders trusted and when I removed that from the trust
centre the files opened as they should by double clicking, albeit more
slowly.
In fact, on my system and from reading others' complaints, any xlsm files
open slower AND macros act slower AND calculations are slower than their xls
counterpart. It seems leaving the files as xls is the way to go for some.
What has Microsoft accomplished with this version? I think a backward and
confusing program for sure!!
Is this program more suited to those running dual processors?
Rob
"Martin von Gagern" wrote in message
...
Hi Rob!
Yes, remove / and e, add "%1" including quotes, and the [ ] brackets in
[rem see command line] are to be included as well. Maybe I'll formulate
this more clearly.
So if this did not solve the issue for you, you can try some
intermediate steps I tried while examining this problem.
1. Double-click an Excel document while another is already open
2. Start Excel from the start menu, then double-click a document
3. Start Excel and open the document using the open dialog
4. Remove the [rem ...] and open a document
All these solutions resulted in the file being opened quickly for me.
4. however caused the document to be opened again when closing Excel, or
in an error message from Explorer, at least in some cases.
If all of these approaches fail, then it looks like your Excel is really
busy loading the file. Have a look at the Task Manager's process list to
see whether Excel or the idle process consume more CPU. I always had the
system idle while waiting that minute.
Let's see if we can get this solved for you as well...
Martin
Rob wrote:
Hi Martin,
I tried that solution but did not make any difference. Maybe I didn't
follow the procedure exactly. The instructions that were given I have
produced below as they are a bit confusing.....
Application for this operation:
At the end of the line, replace /e with "%1"
Does that mean I remove the / (the forward slash) and the e, and add
"%1"
including the quotation marks?
DDE-Application not active:
Insert new text: [rem see command line]
Do I include the [ and the ] brackets?
Rob
"Martin von Gagern" wrote in message
...
Does http://martin.von-gagern.net/howtos/excel2007load help?
I wrote about this in another thread here, but I know many people only
monitor their own thread. Sorry for the duplicate to everyone else.
John wrote:
I have worksheets that only have from 1 to 7 rows and Excel 2007 takes
anywhere from 30 to 60 seconds to open these worksheets. I am running
Windows XP SP2
on a IBM/Lenova with 1 Gig of ram and a 3 Ghz processor.
Is there any setting I can change (or turn off) to speed this muther
up?