No copy workbook method in Excel 97? 2

[money99]

Hi there. I developed a small macro where the user fills in data on a worksheet and at the end he could press a button which copied the workbook onto the clipboard. I made this at home using office 2000 but when I took it back to work where office 97 is still used the copy method failed. Is there any way round this problem? I was copying the worksheet.

 

[xlbo]

Pls post the code that is failing and an indicator as to which line it fails on Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[money99]

This is the line that fails and it is the only line assigned to the button. What it did was to automatically open a new workbook with the worksheet pasted.
Workbooks("FEED2.1.xls&quot.Worksheets("FormSheet&quot.Copy
Regards
Vas

 

[xlbo]

What error do you get ??
Just tried the line and it works fine on my excel ('97 SP2, NT4)

If you are using a Controls Toolbox button, you will need to set the "Take Focus On Click" property to false. NB - the only way I could get an error from your code was to set the property to true and that gives a 1004 error Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[money99]

Thanks Geoff.
It opened the document in 97 with the "take focus on click" property set to true.
Vas