Passing Parameters t excel Macro

Hi,

I am workin gon a code in which start date and end date needs to passed to vb code.

Start dates and End dates are passed from a vbs file .
The vbs code is written below:

Set objExcel = CreateObject("Excel.Application")
With objExcel
.Workbooks.Open "C:\emailfetch\FetchEmails.xlsm"
.Visible = True
.Run "FolderTraverse",Now-1,Now
.ActiveWorkbook.Close True
.Quit
End With

Here parameters are passed as Now and Now -1 but with this format dates are limited to some specific scenario.

How can I pass dates which are not in the Now and Now-1 format.I want to pass dates in more flexible ways.
Any pointer will be appreciated


Regards
Rakesh

By means of more flexible way I mean if I want to pass dates of today and yesterday then Now and Now-1 will be fine.
What if I want to pass dates like 10-Aug-2013 & 01-Mar-2014.

How such dates will be entered (Now and Now-1,-2,-3 are not suitable as per my requirement.)

Hi Richard,

Scenario is like below:
Start dates and end dates are passed like:
.Run "FolderTraverse",Now-1,Now

These dates will be passed to a code in VB-->Sub FolderTraverse (a,b)...this code is a part of VB ,based on the dates received further calculation will be done

Originally Posted by Izandol

It is CLng not CLang
Also dateserial arguments are Year, Month, Day and not Day, Month, Year.

Hi Izandol,

Thanks for correcting me.
It works,thanks a lot again

Hi Guys,

Back again with queries...
I am executing a batch file whose Contents are
1.Date.Vbs
2.Makezip.vbs
3.mailsend.cmd
I am passing dates parameter from Date.vbs to a vb code ,like below
.Run "FolderTraverse",cLng(DateSerial(2014,3,1)),cLng(DateSerial(2014,3,4))

Now the scenario is I am required to pass these dates from a text file instead of vbs file.
Please provide some pointers.

TIA
Rakesh

Could you please help how to implement that

Hi Richard,

When you say grab the dates in a date variable ,should I grab these date in text file from user via console or entered inside text file.
And .txt file will be opened if we enter the name of that file in .bat file.