Office Home & Student 2007

[Howard31]

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.

 

[Rick Rothstein]

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?

 

[Dave Peterson]

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]

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!

 

[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 here:
http://www.rondebruin.nl/calendar.htm

(If you need a replacement???)

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!