Andy,
Thanks for the link. I've book marked it to try out some of the stuff
in there.
Regards,
Steve
On Aug 12, 9:52 pm, Aindril De wrote:
> Hi Steve,
>
> In Excel 2007 certain things have changed in the VBA front as well. While
> saving the file in any XML format that is .xlsx in this case,
ame
> and you may be able to drop the FileFormat: parameter altogether.
>
> I did some quick testing.. it looks like if you're NOT changing
> the file type, you could simply use:
>
> ActiveWorkbook.SaveAs Filename:=TheFileName
>
> hope this makes sense.
>
> If yo
Name = ActiveWorkbook.Name
and you may be able to drop the FileFormat: parameter altogether.
I did some quick testing.. it looks like if you're NOT changing
the file type, you could simply use:
ActiveWorkbook.SaveAs Filename:=TheFileName
hope this makes sense.
If you need any clarification
Hi Steve,
In Excel 2007 certain things have changed in the VBA front as well. While
saving the file in any XML format that is .xlsx in this case, you need to
supply the file fomat value as well. The following link will give you
further details on this.
http://www.rondebruin.nl/saveas.htm
Regards,
Hi,
I have this macro that someone had helped me with quite a while ago.
It was working fine until I went to update it to work for Excel 2007.
The macro below is what it was until I changed ".xls" to ".xlsx".
'SaveAsExcelWorkbook2()
'Remember to add the reference to Microsoft Scripting Runtime
D
