[causemaker]

Hi, I'm having trouble with a *.xlw file. On a Win95 computer, with
Excel97 sr-2, a user will open the file "abc.xlw". She then hits
CTRL+A, and something (a macro?) runs and copies data from a *.txt
file on our network.

On any other computer, this process will not work. I can't figure out
how to make it run. If we open the same "abc.xlw", and hit CTRL+A,
all excel does is a Select All. I've looked for macros/vba projects,
and can't find anything.

I also posted this is ms.public.excel.worksheetfunctions, but got no
response so far.

Any help would be appreciated!
Thanks!

[Tom Ogilvy]

It is possible that ctrl+a is mapped to a macro by her personal.xls file or
an addin and has nothing to do with the *.xlw. This situation would match
what you describe.

Do this, close, then open xl (don't open the xlw file), open a blank
workbook and do ctrl+a on her computer and see if it copies the text file.
If it does, then you can see it doesn't have anything to do with the *.xlw
file.

Regards,
Tom Ogilvy


"causemaker" wrote in message
om...
Hi, I'm having trouble with a *.xlw file. On a Win95 computer, with
Excel97 sr-2, a user will open the file "abc.xlw". She then hits
CTRL+A, and something (a macro?) runs and copies data from a *.txt
file on our network.

On any other computer, this process will not work. I can't figure out
how to make it run. If we open the same "abc.xlw", and hit CTRL+A,
all excel does is a Select All. I've looked for macros/vba projects,
and can't find anything.

I also posted this is ms.public.excel.worksheetfunctions, but got no
response so far.

Any help would be appreciated!
Thanks!

[Andi Causemaker]

Thanks for the suggestions - I tried the Ctrl+A on a blank workbook, and
nothing happened.

It looks like there is a macro written in the spreadsheet itself (not in
VB) and is 'activated' by Ctrl+A. Is code in the spreadsheet itself not
supported by Excel versions later than 97? There is no personal.xls on
her computer.

Thanks again.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom Ogilvy]

Sounds like a Lotus 1-2-3 macro if it is in a regular worksheet (not
supported after xl97) or if it is a macro sheet, than an xl4 style macro -
supported in xl5 and later in addition to VBA.

Regards,
Tom Ogilvy

Andi Causemaker wrote in message
...
Thanks for the suggestions - I tried the Ctrl+A on a blank workbook, and
nothing happened.

It looks like there is a macro written in the spreadsheet itself (not in
VB) and is 'activated' by Ctrl+A. Is code in the spreadsheet itself not
supported by Excel versions later than 97? There is no personal.xls on
her computer.

Thanks again.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!