MATLAB Central Newsreader - MATLAB builder for excel

MATLAB builder for excel

Roy — Mon, 29 Dec 2008 03:41:01 -0500

Hi, I am using R2007b, and I went to

Start > Matlab > Matlab Builder for excel > Deployment tool

I would like to convert an m-file to *.bas, so I can use Excel to open the basic file. But I encountered the following error,

"The chosen compiler does not support building COM objects."

So I run, "mbuild -setup", and choose the compiler,

"Lcc-win32 C 2.4.1"

This is the only choice I have, but it still does not work.
What should I do?

Thanks,
Roy

Re: MATLAB builder for excel

Ashish Uthama — Mon, 29 Dec 2008 18:49:51 -0500

On Sun, 28 Dec 2008 22:41:01 -0500, Roy <hip280@yahoo.com.sg> wrote:

> Hi, I am using R2007b, and I went to
>
> Start > Matlab > Matlab Builder for excel > Deployment tool
>
> I would like to convert an m-file to *.bas, so I can use Excel to open
> the basic file. But I encountered the following error,
>
> "The chosen compiler does not support building COM objects."
>
> So I run, "mbuild -setup", and choose the compiler,
>
> "Lcc-win32 C 2.4.1"
>
> This is the only choice I have, but it still does not work.
> What should I do?
>
> Thanks,
> Roy

> What should I do?
Install a supported compiler. (those which have a check mark under builder
ex)
http://www.mathworks.com/support/compilers/release2007b/

(VC++ 2005 express edition is free for download at microsoft's website)

Re: MATLAB builder for excel

Roy — Tue, 30 Dec 2008 01:08:02 -0500

Hi Ashish, yap thats what i did, but I saw there is a footnote that says,

"Microsoft Visual C++ 2005 Express Edition requires the MSSdk variable to be defined in the Windows environment when used with MATLAB and related products. The value of this environment variable is the path to the installation directory for Microsoft Platform SDK for Windows Server 2003. This environment variable is not usually defined by the Microsoft Platform SDK installation program. "

But there were no instructions I could follow on how to set this
MSSdk variable. Do you know how can this be done, or point me to
somewhere with the instructions?

Thanks,
Roy

"Ashish Uthama" <first.last@mathworks.com> wrote in message <op.umxs9dwha5ziv5@uthamaa.dhcp.mathworks.com>...
> On Sun, 28 Dec 2008 22:41:01 -0500, Roy <hip280@yahoo.com.sg> wrote:
>
> > Hi, I am using R2007b, and I went to
> >
> > Start > Matlab > Matlab Builder for excel > Deployment tool
> >
> > I would like to convert an m-file to *.bas, so I can use Excel to open
> > the basic file. But I encountered the following error,
> >
> > "The chosen compiler does not support building COM objects."
> >
> > So I run, "mbuild -setup", and choose the compiler,
> >
> > "Lcc-win32 C 2.4.1"
> >
> > This is the only choice I have, but it still does not work.
> > What should I do?
> >
> > Thanks,
> > Roy
>
> > What should I do?
> Install a supported compiler. (those which have a check mark under builder
> ex)
> http://www.mathworks.com/support/compilers/release2007b/
>
> (VC++ 2005 express edition is free for download at microsoft's website)

Re: MATLAB builder for excel

Roy — Tue, 30 Dec 2008 01:26:02 -0500

Oh I found a solution at
http://www.mathworks.com/support/solutions/data/1-66BY08.html

Please follow the steps listed below to setup the MSSDk environment variable after you have installed Microsoft Platform SDK for Windows Server 2003.

1. Go to Control Panel -> System -> "Advanced" -> "Environment variables".
2. Create a new system variable with the name "MSSDk".
3. The value of this variable should be the path where the Microsoft Platform SDK for Windows Server 2003 is installed.
4. Click OK a few times to close out the Control Panel window, and all its children.
5. Restart MATLAB.

However, how do I look for the path where the Microsoft Platform
SDK for windows server 2003 is installed?
After installing VC 2005 Express edition, I have the path C:\Program Files\Microsoft Visual Studio 8.
But I don't see anything that says Windows Server 2003.

"Roy" <hip280@yahoo.com.sg> wrote in message <gjbs9i$gv2$1@fred.mathworks.com>...
> Hi Ashish, yap thats what i did, but I saw there is a footnote that says,
>
> "Microsoft Visual C++ 2005 Express Edition requires the MSSdk variable to be defined in the Windows environment when used with MATLAB and related products. The value of this environment variable is the path to the installation directory for Microsoft Platform SDK for Windows Server 2003. This environment variable is not usually defined by the Microsoft Platform SDK installation program. "
>
> But there were no instructions I could follow on how to set this
> MSSdk variable. Do you know how can this be done, or point me to
> somewhere with the instructions?
>
> Thanks,
> Roy
>
> "Ashish Uthama" <first.last@mathworks.com> wrote in message <op.umxs9dwha5ziv5@uthamaa.dhcp.mathworks.com>...
> > On Sun, 28 Dec 2008 22:41:01 -0500, Roy <hip280@yahoo.com.sg> wrote:
> >
> > > Hi, I am using R2007b, and I went to
> > >
> > > Start > Matlab > Matlab Builder for excel > Deployment tool
> > >
> > > I would like to convert an m-file to *.bas, so I can use Excel to open
> > > the basic file. But I encountered the following error,
> > >
> > > "The chosen compiler does not support building COM objects."
> > >
> > > So I run, "mbuild -setup", and choose the compiler,
> > >
> > > "Lcc-win32 C 2.4.1"
> > >
> > > This is the only choice I have, but it still does not work.
> > > What should I do?
> > >
> > > Thanks,
> > > Roy
> >
> > > What should I do?
> > Install a supported compiler. (those which have a check mark under builder
> > ex)
> > http://www.mathworks.com/support/compilers/release2007b/
> >
> > (VC++ 2005 express edition is free for download at microsoft's website)

Re: MATLAB builder for excel

Ashish Uthama — Tue, 30 Dec 2008 15:13:15 -0500

On Mon, 29 Dec 2008 20:26:02 -0500, Roy <hip280@yahoo.com.sg> wrote:

> Oh I found a solution at
> http://www.mathworks.com/support/solutions/data/1-66BY08.html
>
> Please follow the steps listed below to setup the MSSDk environment
> variable after you have installed Microsoft Platform SDK for Windows
> Server 2003.
>
> 1. Go to Control Panel -> System -> "Advanced" -> "Environment
> variables".
> 2. Create a new system variable with the name "MSSDk".
> 3. The value of this variable should be the path where the Microsoft
> Platform SDK for Windows Server 2003 is installed.
> 4. Click OK a few times to close out the Control Panel window, and all
> its children.
> 5. Restart MATLAB.
>
> However, how do I look for the path where the Microsoft Platform
> SDK for windows server 2003 is installed?
> After installing VC 2005 Express edition, I have the path C:\Program
> Files\Microsoft Visual Studio 8.
> But I don't see anything that says Windows Server 2003.
>
The solution says:

"Microsoft Platform SDK for Windows Server 2003 also needs to be installed
when using Microsoft Visual C++ 2005 Express Edition."

I assume you have not installed it. Google for it, download, while
installting either note the default path or install to a location of your
choice. Now use this path value for the steps above.

Note: If a solution is not clear, feel free to leave feedback (there is a
button on the top). I know for a fact that this is looked at regularly and
solutions updated if required.