2007 VBA Workbook Referencing

[Davenumber40]

I've searched for a thread on this but didn't come up with anything. I apologize if there is one.

I'm a self taught VBA'er so I'm not sure if I'm using the best method. I'm converting my 2003 code to 2007 and the file extensions are giving me fits. Any time I use SaveAs or Open I am including the file extensions. Obviously in 2003 this was easy but now I hate to use all this hard code.

Examples:
Workbooks.Open "Z:\My Documents\4 Archive\04 - Original Apps\Excel Qual Test\Current Qualifications.xlsx"
ActiveWorkbook.SaveAs Filename:=(sDir & "Quals to Load.xlsm")

What's more, my workbooks now include the extension in the title bar at the top (Current Qualifications.xlsx - Microsoft Excel) and my Workbooks("Current Qualifications").Select isn't working presumably because my workbook is "Current Qualifications.xlsx".

Is there an easier way to handle file extensions in 2007?

[romperstomper]

You don't need to use an extension when doing SaveAs as long as you specify the right fileformat argument. That is pretty much essential in 2007 given the different formats available for workbooks.
For the Workbooks reference it is better, IMO, to always include the extension, but I would point out that it is almost never necessary to actually select or activate a workbook (or worksheet, range etc.) in order to work with it. If you assign the workbook to a workbook variable, then you can refer to it directly:

Please Login or Register  to view this content.

[Davenumber40]

Thanks! I should have probably been using that method all along.