Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I have a class module called DosOutputs. Here is one of the properties:- Public Property Let CommandLine(DOSCommand As String) mCommand = DOSCommand End Property I get the error "invalid use of property" when I try to set this property as follows:- objDOS.CommandLine = txtCommand.Text What am I doing wrong? Ta Andi |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
There has to be more to it than what we are seeing. I created the exact same
code at my end and it works fine. How is m_Command declared? String, Integer, ??? Try changing objDOS.CommandLine = txtCommand.Text To objDOS.CommandLine = "Test" Just to see if that helps... -- HTH... Jim Thomlinson "Andibevan" wrote: Hi All, I have a class module called DosOutputs. Here is one of the properties:- Public Property Let CommandLine(DOSCommand As String) mCommand = DOSCommand End Property I get the error "invalid use of property" when I try to set this property as follows:- objDOS.CommandLine = txtCommand.Text What am I doing wrong? Ta Andi |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Your completely right - I managed to work it out on the train home - I had
missed a declaration out - thanks again for your suggestions. Do you know of any good guides to class modules? I have another problem with custom events and Raiseevent but I want to do some reading before I post lots of questions.. Thanks again Andi "Jim Thomlinson" wrote in message ... There has to be more to it than what we are seeing. I created the exact same code at my end and it works fine. How is m_Command declared? String, Integer, ??? Try changing objDOS.CommandLine = txtCommand.Text To objDOS.CommandLine = "Test" Just to see if that helps... -- HTH... Jim Thomlinson "Andibevan" wrote: Hi All, I have a class module called DosOutputs. Here is one of the properties:- Public Property Let CommandLine(DOSCommand As String) mCommand = DOSCommand End Property I get the error "invalid use of property" when I try to set this property as follows:- objDOS.CommandLine = txtCommand.Text What am I doing wrong? Ta Andi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
class module? | Excel Programming | |||
Class Module for setting Automatic Calc | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |