Hi all,

I just purchased Microsoft Office Home & Student. Ive been using VBA for
Excel 2003 for a long time. In the Excel edition that I mentioned before
there are a few things that do not seem to be recognised in VBA for example
the Format function and the Date function I dont know if this is to do that
it's Home & Student version or maybe because its 2007 and there is something
else in its place.

Any help will be greatly appreciated!

Thanks.
--
A. Ch. Eirinberg

I don't have the Home & Student edition in order to check, but Format and
Date are two standard functions in VBA and should be available in all
versions of VBA. What happens when you try to use them? If you get an error
message of some kind, then tell us what error message are you getting? If
you don't get an error message, then what does happen when you try to use
them?

--
Rick (MVP - Excel)


"Howard31" wrote in message
...
Hi all,

I just purchased Microsoft Office Home & Student. Ive been using VBA for
Excel 2003 for a long time. In the Excel edition that I mentioned before
there are a few things that do not seem to be recognised in VBA for
example
the Format function and the Date function I dont know if this is to do
that
it's Home & Student version or maybe because its 2007 and there is
something
else in its place.

Any help will be greatly appreciated!

Thanks.
--
A. Ch. Eirinberg

Open the workbook with the problem (on the problem PC)
Go into the VBE
Select that workbook's project
Click on Tools|References, look for a MISSING reference.

Delete it or replace it with one that you need.

Missing references can cause errors that have no relationship to the line that's
marked as error.

Howard31 wrote:

Hi all,

I just purchased Microsoft Office Home & Student. Ive been using VBA for
Excel 2003 for a long time. In the Excel edition that I mentioned before
there are a few things that do not seem to be recognised in VBA for example
the Format function and the Date function I dont know if this is to do that
it's Home & Student version or maybe because its 2007 and there is something
else in its place.

Any help will be greatly appreciated!

Thanks.
--
A. Ch. Eirinberg

--

Dave Peterson

Thanks Dave Peterson,

There was a missing reference and I unchecked it as you suggested and the
problem was solved!

Now the reference which was missing was to Calender object which was
available in VBA for Excel 2003 What happened to it in 2007? Why is the
Calender Library not availble in 2007?

Once again Thanks for your help!
--
A. Ch. Eirinberg


"Dave Peterson" wrote:

Open the workbook with the problem (on the problem PC)
Go into the VBE
Select that workbook's project
Click on Tools|References, look for a MISSING reference.

Delete it or replace it with one that you need.

Missing references can cause errors that have no relationship to the line that's
marked as error.

Howard31 wrote:

Hi all,

I just purchased Microsoft Office Home & Student. I€„¢ve been using VBA for
Excel 2003 for a long time. In the Excel edition that I mentioned before
there are a few things that do not seem to be recognised in VBA for example
the Format function and the Date function I don€„¢t know if this is to do that
it's Home & Student version or maybe because its 2007 and there is something
else in its place.

Any help will be greatly appreciated!

Thanks.
--
A. Ch. Eirinberg

--

Dave Peterson

The calendar control used (through xl2003) to be installed when Access was
installed. If you don't have Access 2007 installed, then it sounds like this is
still true.

Ron de Bruin has some notes and a link to a different calendar control he
http://www.rondebruin.nl/calendar.htm

(If you need a replacement???)

Howard31 wrote:

Thanks Dave Peterson,

There was a missing reference and I unchecked it as you suggested and the
problem was solved!

Now the reference which was missing was to Calender object which was
available in VBA for Excel 2003 What happened to it in 2007? Why is the
Calender Library not availble in 2007?

Once again Thanks for your help!
--
A. Ch. Eirinberg

"Dave Peterson" wrote:

Open the workbook with the problem (on the problem PC)
Go into the VBE
Select that workbook's project
Click on Tools|References, look for a MISSING reference.

Delete it or replace it with one that you need.

Missing references can cause errors that have no relationship to the line that's
marked as error.

Howard31 wrote:

Hi all,

I just purchased Microsoft Office Home & Student. I€„¢ve been using VBA for
Excel 2003 for a long time. In the Excel edition that I mentioned before
there are a few things that do not seem to be recognised in VBA for example
the Format function and the Date function I don€„¢t know if this is to do that
it's Home & Student version or maybe because its 2007 and there is something
else in its place.

Any help will be greatly appreciated!

Thanks.
--
A. Ch. Eirinberg

--

Dave Peterson


--

Dave Peterson