Excel Compatibilty issue with file conversion

[Jonah]

Hi Guy's I'm having an issue in where I have developed a Macro which on the event of a button press which will generate an email and convert the Spreadsheet which was being worked on into a csv file.

Now, this works great in Excel 2007, I press the button and I receive the email and in the attachment is a csv file which I open and everything works great. Now when I have tested this on an Excel 2003 machine. The email comes through fine and the attachment is a csv one, but when I come to open it, I get the message, 'The file you are trying to open, '12345654321.csv', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening file. Do you want to open the file now?'

On clicking yes, it opens the spreadsheet in an excel format???????

Here is my code, any help would be much appreciated.

Please Login or Register  to view this content.

Thank You

Jonah

[pike]

hi Jonah
you cant just change the file extenion to csv Its still a xls workbook. it just displays the csv icon

[pike]

my bad in 2007 its .xlCSV extension

[Jonah]

my bad in 2007 its .xlCSV extension

Hi Pike, why does this work in Excel 2007 but not in Excel 2003 then. It converts the file to a csv format in 2007

Kind Regards,

Jonathan

[pike]

try for 2003

Please Login or Register  to view this content.

[pike]

my only other thoughts are that 2007 will open the xlms as a xlcvs
but 2003 wont so are you sending the correct workbook?

Please Login or Register  to view this content.

[Jonah]

try for 2003

Please Login or Register  to view this content.

Where would I place this in my code?

[pike]

try..

Please Login or Register  to view this content.

[Jonah]

my only other thoughts are that 2007 will open the xlms as a xlcvs
but 2003 wont so are you sending the correct workbook?

Please Login or Register  to view this content.

The workbook is the one in where the code lies. I'm not picking up the workbook from anywhere. I'm converting the same workbook through this script and then emailing it as a csv file.

[Jonah]

try..

Please Login or Register  to view this content.

I get a 'Type mismatch error'

Jonah

[pike]

then

Please Login or Register  to view this content.

also try closeing the workbook before attaching it

[Jonah]

then

Please Login or Register  to view this content.

also try closeing the workbook before attaching it

Hi Pike, still the same error...

[pike]

Try closing the saveas work book before attaching it
and .Close savechanges:=False to true

[Jonah]

Try closing the saveas work book before attaching it
and .Close savechanges:=False to true

Still not working Pike. It works in 2007, but I get the same error message in 2003 when I click the button. Type Mismatch

I think I've closed the saveas work book by attaching it. and .Close savechanges:=True.

I've put this sub in my workbook. The rest of my code is in the module.

Regards,

Jon

[pike]

Hey Jonah
Someone, if they have a definitive answer, will reply
it cant be much

[Jonah]

Hey Jonah
Someone, if they have a definitive answer, will reply
it cant be much

Thanks for trying to help Pike, I really appreciate it. Anyone else have any ideas?

Jonah

[Jonah]

Hey Guys, can anyone help me with this problem. Thank You,

Jonah

[Jonah]

Thanks for all the help on this. My problem was a mistake in the code.

FileExtStr = ".csv": FileFormatNum = -4143

Is in 2003 also a 6

FileExtStr = ".csv": FileFormatNum = 6

Thanks Ron de Bruin for this. Thank you to all who tried to help also. Much appreciated.

Jonah

[pike]

arr.. good work

[pike]

and special thank you for marking posts solved with the answer
If I had and reps left they would be yours