file extension error when saving workspace

B

bigduke

When trying to save a workspace using the icon under the view menu I'm
getting this error:
"This extension can not be used with selected file type. Change the
extension in the File name text box or select a different file type by
changing the Save as Type."

Has anyone else ran into this? I've created many worspaces before with no
problems till now.
 
S

Sanmarc Enterprises

When trying to save a workspace using the icon under the view menu I'm
getting  this error:
 "This extension can not be used with selected file type. Change the
extension in the File name text box or select a different file type by
changing the Save as Type."

Has anyone else ran into this?  I've created many worspaces before withno
problems till now.

I have this problem also - any fix out there?
 
Joined
Jun 19, 2010
Messages
1
Reaction score
0
file type problem

If it's any help, here's what I found...

First, I tried to save (via a button with VB code) as an .XLSX but it kept giving me the same errors as have been posted. I then changed the file extension to .XLS and it saved fine but, when I tried to open it, Excel warned me about the "unsafe" file type and macros included which could be dangerous. This is when I realized that it was a problem of the file having buttons w/VB code inserted (in my case) which required that the workbook be saved/opened as a macro-enabled workbook (.XLSM). Once I changed my code to use that file extension, I had no further problems.

I rarely play with VB functions (BIG NOOB here) but this seemed logical so I hope it helps.

~Rooney
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top