Hello.

When i am trying to use DateTime Datatype in my VBA macro, it gives me
"Automation type not supported by visual basic"

do i have to add some kind of reference to the specific library ? i cannot
find any information on this.

Thank you

Try using just Date. It supports both Date and Time...
--
HTH...

Jim Thomlinson


"Alex" wrote:

> Hello.
>
> When i am trying to use DateTime Datatype in my VBA macro, it gives me
> "Automation type not supported by visual basic"
>
> do i have to add some kind of reference to the specific library ? i cannot
> find any information on this.
>
> Thank you

Hello Jim.
First of all thank you for responding so quickly.

I am trying to get start/end dates from user in dd-mm-yyyy hh:mm:ss format
and a value in minutes for example 2

then i will make 2 minute sql statements to find out min/max of certain
value over that period of time

so i need to manipulate datetime i couldnt find anything for date datatype
that can be equal to DateTime.AddMinutes

"Jim Thomlinson" wrote:

> Try using just Date. It supports both Date and Time...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Alex" wrote:
>
> > Hello.
> >
> > When i am trying to use DateTime Datatype in my VBA macro, it gives me
> > "Automation type not supported by visual basic"
> >
> > do i have to add some kind of reference to the specific library ? i cannot
> > find any information on this.
> >
> > Thank you

Sorry about taking so long to get back to you (meetings). Try something like
this...

Dim dte As Date

dte = Now()
MsgBox dte

dte = dte + TimeSerial(0, 2, 0)
MsgBox dte

--
HTH...

Jim Thomlinson


"Alex" wrote:

> Hello Jim.
> First of all thank you for responding so quickly.
>
> I am trying to get start/end dates from user in dd-mm-yyyy hh:mm:ss format
> and a value in minutes for example 2
>
> then i will make 2 minute sql statements to find out min/max of certain
> value over that period of time
>
> so i need to manipulate datetime i couldnt find anything for date datatype
> that can be equal to DateTime.AddMinutes
>
> "Jim Thomlinson" wrote:
>
> > Try using just Date. It supports both Date and Time...
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Alex" wrote:
> >
> > > Hello.
> > >
> > > When i am trying to use DateTime Datatype in my VBA macro, it gives me
> > > "Automation type not supported by visual basic"
> > >
> > > do i have to add some kind of reference to the specific library ? i cannot
> > > find any information on this.
> > >
> > > Thank you

Thank you very much. Solved my problem

"Jim Thomlinson" wrote:

> Sorry about taking so long to get back to you (meetings). Try something like
> this...
>
> Dim dte As Date
>
> dte = Now()
> MsgBox dte
>
> dte = dte + TimeSerial(0, 2, 0)
> MsgBox dte
>
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Alex" wrote:
>
> > Hello Jim.
> > First of all thank you for responding so quickly.
> >
> > I am trying to get start/end dates from user in dd-mm-yyyy hh:mm:ss format
> > and a value in minutes for example 2
> >
> > then i will make 2 minute sql statements to find out min/max of certain
> > value over that period of time
> >
> > so i need to manipulate datetime i couldnt find anything for date datatype
> > that can be equal to DateTime.AddMinutes
> >
> > "Jim Thomlinson" wrote:
> >
> > > Try using just Date. It supports both Date and Time...
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "Alex" wrote:
> > >
> > > > Hello.
> > > >
> > > > When i am trying to use DateTime Datatype in my VBA macro, it gives me
> > > > "Automation type not supported by visual basic"
> > > >
> > > > do i have to add some kind of reference to the specific library ? i cannot
> > > > find any information on this.
> > > >
> > > > Thank you