matthewtayloruk 0 Posted May 10, 2023 Share Posted May 10, 2023 Hi folks-- I've a bunch of spreadsheets attached in my Evernote that had macros in. Therefore their filename was something.xlsm. I've edited each spreadsheet and removed the macros. Now I want to rename the files in evernote to something.xls - ie. to remove the 'm'. I used to be able to do this, but now can't. Does anyone know how to achieve this functionality? Link to comment
Level 5* gazumped 12,078 Posted May 10, 2023 Level 5* Share Posted May 10, 2023 Hi. Device? OS? Evernote version? I don't believe you can rename the file inside Evernote, but if you open it up to remove the macro, why not resave with the correct name and delete the original. Link to comment
MvdH 490 Posted May 10, 2023 Share Posted May 10, 2023 4 hours ago, matthewtayloruk said: Hi folks-- I've a bunch of spreadsheets attached in my Evernote that had macros in. Therefore their filename was something.xlsm. I've edited each spreadsheet and removed the macros. Now I want to rename the files in evernote to something.xls - ie. to remove the 'm'. I used to be able to do this, but now can't. Does anyone know how to achieve this functionality? I experience the same thing on Windows 11 latest Evernote v10 version. I cannot change filenames extensions anymore, as I could with Evernote 6.x Legacy. The only workaround I know is saving the attachment, renaming, deleting old one from the note, re-adding the renamed attachment. Link to comment
matthewtayloruk 0 Posted May 25, 2023 Author Share Posted May 25, 2023 Hi-- Those workarounds would work, but when dealing with hundreds of spreadsheets it's annoying. What also makes things worse is that I used to have another workaround to stop evernote automatically displaying images. I would load a jpeg file as 'picture.dat', then rename it in evernote to 'picture.jpg'. This is a way to stop evernote wanting to inilne the pictures, which I don't want. Being able to change the file extension to fool Evernote into not doing default (and not turn-off-able) behaviours is very useful. Seemingly someone thought it'd be a good idea to remove file extensions in some recent version and to me this is a major step backwards in valuable functionality. I'm getting closer and closer to just moving to OneDrive now 😞 Link to comment
Level 5* gazumped 12,078 Posted May 25, 2023 Level 5* Share Posted May 25, 2023 3 hours ago, matthewtayloruk said: when dealing with hundreds of spreadsheets it's annoying Hi. Two things... On 5/10/2023 at 3:18 PM, gazumped said: Hi. Device? OS? Evernote version? I don't believe you can rename the file inside Evernote, but if you open it up to remove the macro, why not resave with the correct name and delete the original. I'm intrigued as to your process: how do you come to be saving hundreds of files with macros, and how are you removing the macro content if not by opening them individually? Link to comment
Boot17 1,540 Posted May 25, 2023 Share Posted May 25, 2023 6 hours ago, matthewtayloruk said: What also makes things worse is that I used to have another workaround to stop evernote automatically displaying images. I would load a jpeg file as 'picture.dat', then rename it in evernote to 'picture.jpg'. This is a way to stop evernote wanting to inilne the pictures, which I don't want As far as this one goes, you can just use the preference setting for that -- Choose 'Title' instead of 'Preview' for how you want the default view to be for images: 1 Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now