date/month problem
i have to link my workbook thru the vba code. The logic is
that i need to look for months. LIke if my worksheet is of
may month then i need to link with a column of anohter
workbook which is also may and likewise continue for
forthcoming months.
i search for may-04 in the workbook. My thought is what if
the user changes May-04 to May'04 or any other format....!
How to resolve this ambiguity...is there a way whereby i
put a condition??? or do i need to write a lot of if
condition's?????????
any thots will be appreciated
|