Microsoft has no support for LOTUS macros in EXCEL 2000

[les_austin]

Hi,

I've had confirmation that they will not support lotus macros.
Which leaves me with a daisy, my main excel report is now as useful as **** on a bull.
If anyone could help theres a few pints waiting in Dublin.

Lotus translation -
copymnth - Copies data to current Month
TITLE
{paneloff}{windowsoff} -Goto January data
TURNS OFF SCREEN AND PANEL - NOTE
/wgpd
WORKSHEET GLOBAL PROTECTION DISABLE
/rucj17..co108~
RANGE UNPROTECT CJ17 TO CO108
{goto}D17~
MOVES CELLPOINTER TO D17
{for counter,1,((C6-1)*7),1,right} - Moveto required month
MOVES THE CELLPOINTER BASED ON CONTENTS OF C6
/c{r 5}{D 91}~cj17~ - Copy data to Current
Month
FROM WHERE THE CELLPOINTER ENDS UP COPIES
THE RANGE FROM THERE RIGHT 5 CELLS AND DOWN
91 ROWS TO CJ17
/wgpe
RE ENABLES GLOBAL PROTECTION
{Home}{windowson}{panelon}
TURNS PANEL AND SCREEN BACK ON


With thanks, Les

 

[lbass]

Sorry I don't know VBA.

Try this:

Click on Tools - Options - Transtion
Then check Transtion navigation keys.

Turn on the macro recorder???

Then go thru the keystrokes
Don't worry about Paneloff and windows off
You'll want to see what is happening anyway.
when you get to {r 5} press the right arrow
5 times -- now the fun part {d 91} sorry!
Press the down arrow 91 times. Try before recording the page down key and see what that gives you.
Also seems to me a period is missing???
I expect that the range of 5 columns and 91 rows should be highlighted?? You'll have to see if the data you need is included.
When you get a tilder "~" press the enter key.

Good Luck
Lloyd