969
mv Windows Linux
(discuss.tchncs.de)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 20 Apr 2024
969 points (97.1% liked)
linuxmemes
20707 readers
410 users here now
I use Arch btw
Sister communities:
- LemmyMemes: Memes
- LemmyShitpost: Anything and everything goes.
- RISA: Star Trek memes and shitposts
Community rules
- Follow the site-wide rules and code of conduct
- Be civil
- Post Linux-related content
- No recent reposts
Please report posts and comments that break these rules!
founded 1 year ago
MODERATORS
You also can't open two spreadsheets that have the same filename. I'm sure that's led to a helpdesk call or two.
I lost a lot of respect for Microsoft when I first saw that issue. It's such an easy to avoid limitation. Like probably a similar level of difficulty to remove that limitation than to write the error message explaining it, unless it's more of a spaghetti mess than I'm expecting it to be.
It’s to do with the ability to work with data across all open workbooks:
You can reference
[Workbook.xlsx]Sheet1!B2but if you have two excel workbooks open, both namedWorkbook.xlsxwhich one should be used?If you want to reference other files, you should use a less ambiguous way to refer to them. Like a relative path or full absolute path. The fact that that weakness is because of a half-baked feature like that actually makes me lose even more respect.
Edit: thanks for the info though, it does add some missing context.
So throw an error at runtime on that macro, most workbooks aren't the target of a macro
Whichever one has the smallest relative path to the workbook using it? How does it find the workbook if it isn't open already?
It doesn’t.