hi there,
once again i've got a problem.
i want to export a single sheet of my workbook into a new workbook. therefore i've got the following code:
but if i run that sub, i get this error:
Compile error:
Sub or function not defined!
furthermore vba marks the line
as i am a bloody beginner i would guess the error occurs because of some functions linked to the sheet i want to export. so my questions basicly are:
1) is it because of the links leading to the sheet?
2) how can i solve this problem
thank you very much
i'd be absolutly thankful for every little help.
cheers
matthias
once again i've got a problem.
i want to export a single sheet of my workbook into a new workbook. therefore i've got the following code:
Code:
sheets("Channel").Copy
ActiveWorkbook.SaveAs fileName:="C:\test.xls"
ActiveWorkbook.Close
but if i run that sub, i get this error:
Compile error:
Sub or function not defined!
furthermore vba marks the line
Code:
call WriteManifoldResults
as i am a bloody beginner i would guess the error occurs because of some functions linked to the sheet i want to export. so my questions basicly are:
1) is it because of the links leading to the sheet?
2) how can i solve this problem
thank you very much
i'd be absolutly thankful for every little help.
cheers
matthias