Article View: comp.apps.spreadsheets
Article #57comp.apps.spreadsheets
From: hfreedman
Date: Thu, 06 Aug 1992 23:28
Date: Thu, 06 Aug 1992 23:28
22 lines
1598 bytes
1598 bytes
I would like to create a calendar from several rows of information in order to do some academic scheduling. In columns I have name, course, day, starttime, endtime, etc. I would preferably like to see this in the spreadsheet with columns as days of the week, and rows as the hours of the day, one calendar for each name. Does anyone know of a macro for this. Alternately, I seem to remember WordPerfect having a calendar macro. Does anyone know of a method to set this up? i.e. get the spreadsheet into WordPerfect (easy as table or text) and then (perhaps using the merge feature) create the calendar? Second alternate. Does anyone know how to get a range out of a spreadsheet into a comma delimited file with a CR LF at end of rows? This way I can bring it into a calendaring package. e-mail direct or reply here. I'll summarize. Thanks ------------------------------------------------------------------------- Hy Freedman HFREEDMAN@JANUS.MTROYAL.AB.CA Chair Department of Computer Science and Information Systems Mount Royal College Calgary, Alberta, Canada 403-240-6036 403-850-0661 -------------------------------------------------------------------------
Technical Details
Message-ID:
<1992Aug6.172820.2719@mtroyal.ab.ca>Path:
arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!sdd.hp.com!caen!destroyer!ubc-cs!unixg.ubc.ca!kakwa.ucs.ualberta.ca!acs.ucalgary.ca!cgate.sait.ab.ca!mtroyal!hfreedmanShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!sdd.hp.com!caen!destroyer!ubc-cs!unixg.ubc.ca!kakwa.ucs.ualberta.ca!acs.ucalgary.ca!cgate.sait.ab.ca!mtroyal!hfreedman Newsgroups: comp.apps.spreadsheets Subject: comp.apps.spreadsheets Message-ID: <1992Aug6.172820.2719@mtroyal.ab.ca> From: hfreedman@mtroyal.ab.ca Date: 6 Aug 92 17:28:20 MDT Organization: Mount Royal College, Calgary, Alberta Lines: 22