Well I know the password, I just need to be able to open the excel file, copy all the data to a new excel file and then save it (hence having an identical file that isn't password protected) Then I'll use perl to play with the excel file.

My main problem is that there is no way to open a file in perl that is password protected, so I have to open it in VB (whichever version) and then save a non-password protected file. Bit long winded...

Hi guys, I desperately need a program that will open a password protected excel file and then save it as a none password protected file.

Problem is perl is not letting me do that so I've turned to VB. I don't know ANY VB so haven't got a clue where to start and haven't got time to learn it...

Anyone know where there may be code for this/similar code. Or does anyone want to write some code? ;-)

Thanks,...

hi guys, i am new to perl and I have a question about excel.

I am using the Spreadsheet:Par seexcel module to open a workbook and read data from it. My problem is that the workbook is password protected and I cannot access it. Does anyone have any solutions to this? There is no way that I can remove the protection.

i have a csv file with lots of data. I'm trying to create a 2d array to store this data.

However I have no idea how to do this. This is how far i've got so far...

char a[135][21];
char b[10];
int i=0;
int j=0;
for (j=0;j<22;j++)
{
for (i=0;i<136;i++)
{
a[j][i]=fin.getline(b, 20,',');
}
}

Basically, the data...