Microsoft has no support for LOTUS macros in EXCEL 2000

les_austin

New Member
Joined
Oct 9, 2002
Messages
10
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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

lbass

Board Regular
Joined
Aug 15, 2002
Messages
104
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
 

Forum statistics

Threads
1,143,640
Messages
5,719,984
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top