VBA Code to Add function while retrieving data to Excel

[pkj7461]

Hi,
I have a column in my Select statement of query that retrievies data based on a Function that is defined in a Module.
Like this: PQRAge: DateDiffW([Create-date],Date()).
This DateDiffW is defined in the module

I am retreiving this data into Excel sheet using ADO.Net.
How do I add the module in my select statement.?
Thank you for your time,
Prasanna.

[ADezii]

Hi,
I have a column in my Select statement of query that retrievies data based on a Function that is defined in a Module.
Like this: PQRAge: DateDiffW([Create-date],Date()).
This DateDiffW is defined in the module

I am retreiving this data into Excel sheet using ADO.Net.
How do I add the module in my select statement.?
Thank you for your time,
Prasanna.

Create a Public Function in a Standard Code Module and call it directly in an SQL Statement as in:

'The following SQL Statement will retrieve an individual's Last Name, First Name, Date of Birth, and the Weekday the individual was born on. The Weekday is obtained by passing the [DOB] Argument to the fCalculateWeekDay() Function and displayed as a [WeekDay_Born] Field
SELECT tblTest.LastName, tblTest.FirstName, tblTest.DOB, fCalculateWeekDay([DOB]) AS WeekDay_Born
FROM tblTest;

[pkj7461]

Create a Public Function in a Standard Code Module and call it directly in an SQL Statement as in:

'The following SQL Statement will retrieve an individual's Last Name, First Name, Date of Birth, and the Weekday the individual was born on. The Weekday is obtained by passing the [DOB] Argument to the fCalculateWeekDay() Function and displayed as a [WeekDay_Born] Field
SELECT tblTest.LastName, tblTest.FirstName, tblTest.DOB, fCalculateWeekDay([DOB]) AS WeekDay_Born
FROM tblTest;

Hi, This seems to be not working. I am sorry If i haven't explained this properly.
My original select statement in Access retrieves one of the columns through module like this: PQRAge:DateDiffW([Create-date],Date()). This works fine when I add them to the select statement in Access.

However, I am retrieiving the same column with the VBA Code and place them in Excel sheet. The code fills allother data except the PQRAge.
How do I achieve this in VBA Code written in Excel?
Thanks,
prasanna.

[NeoPa]

I'm not sure that's possible Prasanna. Unfortunately the Excel SQL works via MSQuery rather than Access. It only has access to the basic SQL. You could try (as a long shot) to add a function into your worksheet and see if that is usable from within the query.