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

Hi Richard,

I am using dates as .Run "FolderTraverse",cLang(DateSerial(1,3,2014)),cLang(DateSerial(2,3,2014))
After executing I am getting following error:
Run time error type mismatch Clang.

And output is getting fetched from dates 04-mar-2014 to 28Feb2014 instead between 1 and 2 March

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.

I do not want to open file in the middle of operation .All these scripts need to be scheduled for some specific time so dates should be mentioned initially not in the middle after the files open .
I need a text file where I can enter dates in the starting and then execute my code.

Scenario is like this.
I will run execute.bat
this bat file contains
Date.vbs
Makezip.vbs
mailsend.cmd

Date.vbs opens a file FetchEmails.xlsm and Pass dates to that vb code inside FetchEmails.xlsm
On the basis of these dates mails will fetch from outlook inexcel ,then makezip.vbs makes zip of those fetch mails and mailsend.cmd will send mail to specified address.

What I require is just enter those dates from text file instead of passing it to vbs file.
One more can date be entered in the form of dd/mm/yyyy instead of yyyy/mm/dd.

Hi Richard,

I got this http://stackoverflow.com/questions/2...d-with-cscript.
Can you please check will it be helpful.