Prev: Invoices
Next: Cracking VBAProject Password
From: Matt on 15 May 2010 21:17
Hi
I'm trying to develop a system that will drag out a 16 week roster from a
monthly (annual)schedule.
I have seven worksheets,
One illustrates an commencement of the week that the classes commence.
The second details the week commencing& the days of that week (and is
summarized into months, (eleven months are hidden)
The third and forth sheets are the sixteen week roster for chefs and
management students I have written a macro for this)
The fifth sixth and seventh sheets are for trainer and room allocation
My question is can a macro be written to recognize the date and fill in the
details of subject,session, trainer, and room or is there another method
I am so close...
I can send you the file if you like
From: joel on 16 May 2010 06:48

The are two methods of matching dates


1) Convert both dates to a serial date using Datevalue to convert
string dates to a serial date (number).
2) Sse the format function to convertt a serial date (number) to a
string

StrDate = format(Mydate,"MM/DD/YY")

Make sure if you are using names of months or date that both string you
are trying to match have the same letters capitalized.


If you are using the VBA Find method you need to using a string in the
find method even though the workshet cell is a number. The find method
is matching the text value of the worksheet cell.


set c = cells(what:="4/5/10",lookin:=xlvalues,lookat:=xlwhole)


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=203055

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Invoices
Next: Cracking VBAProject Password