I'm attempting something similar for a project I'm working on. *notes*
I have to insert an excell sheet with the lay-out of the new progres
reports into the Access database they're working with to manag
projects.
On these excell sheets, there is a calc option, where it automaticall
adds several numbers together. Two of these numbers can be gotten fro
the database, a third will have to be filled in manually as it is a
estimation of next year's costs.
There is also additional information, such as 'projectleader name'
'project number', 'project description' and so on that are stored i
the Database and which they'd want very much to be able to get fro
there instead of having to write that out each time over and ove
again.
Would you suggest I leave the excell sheet outside of the database an
attempt to figure out a way to VB it? It's just, there's nothing bu
lay-out and that sum on that excell sheet, so I'm attempting t
recreate it in Access, which is probably a bit easier, and then, whe
they want to send it round, I can just export it as .xls and tag it t
an email.
I'll probably do that..
*Access has a set of directory commands that you could use i
conjunction
with other MS Office applications. For instance, you could write VB
code
to scan and organize data files on your LAN for use by multiple
applications.
B-b-b-but, you probably don't want to have to convert data i
storage
betweer these multiple formats. Better to leave data files i
native
formats.
-
Pook
