I'm stumped. I have a script that opens a spreadsheet,
modifies some values, and saves the new version.
The code looks like this:
(PASTE)
# open Excel file
my $Book = $Excel->Workbooks->Open($dest_xls);
my $sheet = $Book->Worksheets(1);
#######################################################
# fill spreadsheet with parameters from incells0.txt file.
#######################################################
# my ($param, $value);
while( my($param, $value)= each(%params) ) {
put_param_in_spreadsheet($sheet, $param, $value);
}
my $ok_value = get_ok_value($sheet);
#######################################################
# close spread sheet after writing
#######################################################
$Book->Save;
$Book->Close;
(ENDPASTE)
That's the entire code from open to modify to close.
When I run it, it works fine for me.
Someone else is using it, and having some problems.
It turns out that when the XLS spreadsheet is on
a unix drive mapped to windows, you get a popup
message every time it tries to save or close or something.
The popup says:
"A file named VOPU.xls already exists in this location. Do you want to replace
it?"
Yes/No/Cancel.
Why does it work fine on a windows drive but
popup when running on a unix drive?
Is there a "nice" way to make this work on
both types of drives?
I've been chasing this thing around all day,
to finally pin it down to this.
I'm tired. I'm cold.
And I just want it to work right now
so I can go home.
Greg
_______________________________________________
Boston-pm mailing list
[email protected]
http://mail.pm.org/mailman/listinfo/boston-pm
