and you guys thought I was a jerk...

[neuroman9999]

hey @NauticalGent , you reading this?

https://www.excelforum.com/excel-programming-vba-macros/1328331-open-file-in-a-folder.html

 

[The_Doc_Man]

I'm not a member of that forum, but you are actually trying to help the other person. I'm in favor of that. I'll offer this advice which I hope is somewhat constructive. The person wanted an explanation of what was going on. Here is my take on it and you will have to paraphrase.

When you open a file through Windows Explorer, there is a "default file" as part of the file dialog. For Explorer, that default is "*.*" (i.e. any file at all). Also, in Explorer there is no barrier to the use of the default "file associations" - the things that say that you use Adobe Reader on a .PDF and Access on an .MDB, etc. So opening the file from a folder goes through the "file associations." That means that a .PDF gets opened by an Adobe product.

That same file system dialog opened from a program such as Access or Excel might have different defaults for opening files. Like for Excel, the file selection string is perhaps "*.XLS, *.XLSX, *.CSV" or something similar. In that context, the file system dialog isn't going through Windows Explorer. Therefore, the associations might not apply in the same way because of the more restricted nature of the program doing the file-open step. That is, Excel isn't as powerful as Windows at opening files because it cannot apply associations that don't lead back to Excel.

I hope you can help that person. If this advice makes sense, well and good.

By the way, there are still times when you definitely are a jerk. But the thread you referenced wasn't one of them.

 

[AccessBlaster]

But why drag NG into it? Seems unnecessary.

I also know a very intelligent engineer who is in Italy. you probably don't know him though. a government man:

https://www.access-programmers.co.uk...algent.138584/

 

[The_Doc_Man]

Yeah, some things are harder to figure. BTW, Adam, IIRC John is in Virginia now.

 

[neuroman9999]

Yeah, some things are harder to figure. BTW, Adam, IIRC John is in Virginia now.

I assume that Gent's name is John? I did not know this.

By the way, there are still times when you definitely are a jerk. But the thread you referenced wasn't one of them.

no kidding!? well thanks, grandpa. I can be an ass with the best of them. and I seem to know a little more about excel nowadays than I do access. not sure why that is. but then again, I'll always know more than you about any program that is classified as non-legacy.

But why drag NG into it? Seems unnecessary.

I'm not draggin anyone into it. I have no idea how Gent feels about me, nor do I care. because some of the things he's said to me in the past have made no freakin' sense. things like ""there is still hope for you"" and a few other things. well, I don't need people telling me ""there is still hope for me"". That sounds exactly like an intellectual like Richard. Intellectuals suffer from many things, one of which is that they're so smart they get confused about the fact that they're not the best. Gent is not that way I don't think, however the human race is suffering from that very thing everywhere. and there's nothing that can be done about it. because the force is so huge, everyone gets sucked into it. so, good luck to you guys. I'm sure you will all be fine.

by the way Richard, I've been banned on another forum as well, primarily because my level of intellect ticked off one of the mods there. And I'm sure his disdain for me will last forever. He's found me on other websites too. The forum I'm referring to is heavily political and some there are suffering from serious political correctness. But I don't really blame them. Different environments for different folks. This is the man that hates me as much as you do, regarding technical competence:

https://www.mrexcel.com/board/members/jon-von-der-heyden.31398/

https://uk.linkedin.com/in/jonvonderheyden

and I'm sure he's an expert in Excel. I seem to not be liked by a lot of folks in the UK. =/ Although I did have someone contact me from that country 3 weeks ago for advice on using technology. meta tags behind webpages, to be exact. A woman living quite a ways away from London.

 

[The_Doc_Man]

I've been banned on another forum as well, primarily because my level of intellect ticked off one of the mods there.

Why am I not surprised? And for what it is worth, both of those links have security requirements that I choose to not exercise.

 

[neuroman9999]

both of those links have security requirements that I choose to not exercise.

well I didn't research that part. ummmm....and the one for the mr. excel board does NOT need to have you logged in to view. I found his profile without being logged in. so you can do it too.