VBA Runtime Error 438 saving a Excel 95/2003 as FT 50 (2010)...

**Wiiconnaissance** · 09-17-2012, 05:19 PM

Hello everyone,

Title should read Excel 97/2003... UGH, sorry:
After hours of prepping a formula for a monthly roster (that I actually pull 5-9 times a month), I reached a resolve, only to run into a problem on my final approach; saving the file into a Excel 2010 format. Here is my VBA Macro formula:

HTML Code:

My research leads to a registry edit to fix the runtime error, but being in the military, registry tweaks are a no-go due to security settings; even if I wanted to, I couldn't change them. I even tried:

HTML Code:

Still a no-go. Maybe it's the FileFormat:=50, I don't know. All I know, is I don't want to save a Office 97/2003 File as a 2010 then run a Macro. I'd rather do it all in one Macro. Is this even feasible? Please advise.

**TMS** · 09-17-2012, 05:34 PM

If it has a macro in it and you want to save it as a 2007/2010 file type, it's going to have to be a .xlsm extension, not a .xlsx.

Get rid of all the xxx.Select ... Selection.yyy. Use xxx.yyy

For example: Cells.Select + Selection.AutoFilter = Cells.AutoFilter

Regards, TMS

**TMS** · 09-18-2012, 11:03 AM

Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Wiiconnaissance** · 09-18-2012, 01:37 PM

Thanks, TM for the information. Now I just need the final line figured out... how do I save it into .xlsm? The only information I've discovered on FileFormat is 50=2010.

After looking further, I actually need to save from 95 (it is how the system I pull the data from saves it) to a 2007 format. Any idea on how I can do that? I see nothing on fileformat:= for 2007.

**TMS** · 09-18-2012, 02:07 PM

See: http://www.rondebruin.nl/saveas.htm ... looks ike you need 52.

Regards, TMS

**TMS** · 09-18-2012, 04:00 PM

By the way, love the user name ... sounds like Kripke in the Big Bang Theory

**Wiiconnaissance** · 09-21-2012, 10:49 AM

Alright, moving the status to solved. Thanks for all of your help. And yeah, had this name a while, just rarely use it outside of gaming, but I like it so much it is now my norm. I appreciate it! Again, many thanks, this issue is wiizolved!