Use getsaveasfilename variant to activate workbook

**e391961** · 05-18-2010, 03:28 PM

Hello, I'm trying to use a variant assigned to the getsaveasfilename function to activate a workbook. Here is the existing code:

Please Login or Register  to view this content.

When the program gets to the last line of code, it always returns a "subscript out of range" error. What am I missing? Thanks.

**royUK** · 05-19-2010, 01:25 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Added this time

**royUK** · 05-19-2010, 01:27 AM

The new work book will be the active workbook

You can't save a workbook with macros as *.xlsx, it must be *.xlsm

**e391961** · 05-19-2010, 08:24 AM

Thanks RoyUK, sorry about the formatting issue. I used the .xlsx extension because I want the workbook to be macro free when I run the save-as script. I'm not sure I understand your comment about the new work book being active. I'm looking to have the user specify a save-as file name, save the file, switch to another workbook, and then re-activate the original workbook that the user specified through the FileSaveName variant. What I'm stuck on is that last part, re-activating the original workbook. Any more thoughts by yourself or others would be greatly appreciated. Thanks.

**royUK** · 05-19-2010, 01:33 PM

You cannot have code in a2007 workbook and save it with the *.xlsx format toremove code.

I'mnot sure what you are doing so add an example workbook

**e391961** · 05-20-2010, 12:36 PM

Perhaps I've confused things by putting in the part about the extension. All I really need to know is how to use the Windows(........).Activate function with a filename specified by the saveasfilename function. What is it that I put in the (.......) part to make it work?