file extension error when saving workspace

  • Thread starter Thread starter bigduke
  • Start date Start date
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.
 
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.
Click to expand...

I have this problem also - any fix out there?
 
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
 
Back
Top