Hi, Firstly Many Thanks in advance for any help/comments.
\r\n
\r\nI have a VB6 application that basically adds data to a database (access). Part of this information is a date in numerical form Ie DD/MM/YYYY. What i would like to do is take this date from the VB6 app and add it to a Excell sheet. So the sheet would have a monthly view of days acros the top say 1,2,3,4 and so on. What i would like is to take the date on my app say the 1/mm/yyy and put a 1 underneath the 1 on the excell sheet. Basically i want a excell sheet listing orders on specific days and i want to add the order date using the application.
\r\n
\r\nI used to run a query to see how many orders within two dates, which worked fine, but now i would like to look at a sheet of 1 month and visually see when the orders were placed ( if this helps explain)
\r\n
\r\nThanks for any help/input
\r\n
\r\nPaul