stolen from my ramblings .....
After getting home in the last few minutes I figured before I go to bed I
probibly should quickly explain what I am doing, then if anyone really has a
question they can speak up
and why cant it?? I do all kinds of stuff with M$ files every day
switching between different computers and computer systems including
linux. the only parts that dont work, will never work in linux, not
because they cant, but because some developer thinks "its not a good
idea" to do that. Give it up,
I've never known a developer to say this. I've known a lot to say "We've
been working to reverse-engineer the proprietary and non-standard
Microsoft file formats so that we can be compatible for years but it is so
convoluted and changes with every new version of Office that we can't keep
up!"
I have to admint right away I rarely touch access.
AND
nothing i know of in the linux world will work with the vba stuff. so all of
that has to be pre-writen in windows(gotta be able to debug). however it can
be inserted because while you can read and write the vba stuff to the file
you cant execute any of it.
that said for a specific application I on a regular basis (cron : 11pm
nightly) I execute a perl progie that opens an excel file checks to see if
the current month exists in a sheet, add a new sheet with the month name in
it if it doesnt, (then for sanity it checks that we havent writen todays
lines out already (BTDT)) gets some data from the excel file (prev days
stuff) then writes out a ton of data to that excel file, (remember NO vba
runs here) however because excel calculates cell data as it goes inserting
the formula "=a5029+b8929" works just fine. then I take some of that data
plus other outside data (mysql) and pop that data to the end of a word
document.
now come 9am (or whenever the guy that plays with them wants to) these files
(lets start with the excel) get opened from a samba share on the linux box
onto a winhozed XP machine running office 2003 (xp) some of that data is
used, and some new data is added, the file is saved. then he plays with the
word document (usually this includes only opening, printing, closing but
sometimes more happens). then later in the day (or at least after this dude
is done) a little bit more computer literate lady opens the same excel files
(she doesnt care about the word stuff) from the samba share onto winhozed
vista running office 2007, where she runs some of that vba stuff i hinted to
earlier (he doesnt because he doesnt need to, but he "could" and this vista
machine is a newly upgraded machine, this used to be done completely on
windows/office xp) then copies pastes some more data saves it and waits for
cron to do the end of the day stuff. the only thing i cant get rid of
(except for turning it off completely) is that stupid user control for vista
pops up with a warning saying your about to open a file from a location on
the network (((DUH))) otherwise this happens flawlessly, mostly, when
people dont hoze it up.... my biggest problems are failed logins from the
users saying "it didnt work last night I cant find the file" the file is
never not there, but im sure thats a shock to everyone here :D
IF thats not what you were thinking of then thats OK, but I dont know what
your talking about then.
the cron stuff happens every day, the rest happens M-F except holidays
If your going hey what about that vba stuff thats a way done to death
discussion. seems some linux people feel that its a mistake to put
executable code(script or not) in with data, I personally dont care what
people think, I do what I do to get the job done !!! and this is how its
done. and any argument that "we cant run the vba" is NOT a valid current
anti M$ argument! It had its place, it doesnt have it anymore!
nite :D
Richard Reynolds
[EMAIL PROTECTED]
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
