Recent content by DaOtH

All's Interesting, thanxs for that. But how would one extract the User Id Details like the Full Name from ActiveDirectory for instance ? "In three words I can sum up everything I've learned about life: it goes on." - Robert Frost 1874-1963

Right, I appear to be able to avoid the problem by implementing the following code in each workbook, however i still find it funny behaviour. (and now i need to find a way to insert this code in each new workbook i create though the addin) Private Sub workbook_Open() On Error GoTo...

Nope, not referenced, did that double check myself already before posting this question. "In three words I can sum up everything I've learned about life: it goes on." - Robert Frost 1874-1963

Yep, that part i was able to figure out already, that's not the issue. He has the addin installed and it works properly. Nevertheless, the button on in the file i then send him tries to execute the macro in the .xla file in my add-ins folder instead of his own. "In three words I can sum...

Hi, I created an Excel Addin, in it a bunch of macro's and distributed that file. In a normal workbook i have buttons, referencing to a macro in this addin, without a link to the addin file, just the macroname itself. When i distribute this last workbook to another user, having the addin...

Welll... yeah... makes it a bit nicer, Still funny why the .Find does not work Anyway, don't think there will be much difference in the result / runtime. Thnxs "In three words I can sum up everything I've learned about life: it goes on." - Robert Frost 1874-1963

No .range available on the Workbook Object However, i do not think it has to do with the accessing of the range itself, since the following does work, however it is offcourse not a perfect solution. For intR = 1 To Range(strRange).Rows.Count For intC = 1 To Range(strRange).Columns.Count...

Hmm, i see the logic in defining the workbook object. But i am using named ranges, so to get the sheet the named range is on, i need to get the info from the properties of the named range. However, the range can not be accessed without defining the sheet it is on... (havent yet been able to...

Guys, funny problem, trying to execute a bit of code. Problem is that the results are incorrect when running normally (or in debug), however, when executing the same little step, using the same variables, results in a correct result. little line is: Set r =...

Hey, Easily anwsered yourselves if you tried a google on the terms: sap modules overview and take a look at the very first thing it comes back with, has clear and basic explanations of the modules. "In three words I can sum up everything I've learned about life: it goes on." -...

Yep, progress being that i am in the last week of my current job, starting with my new employer 1st of oct. Meaning, i've got a nice week off next week. Will spend some of the valuable free time publishing here. sorry, but i am overloaded with last bits and pieces and knowledge transfers and all...

stupid... should have seen that myself Tnxs vongrunt "In three words I can sum up everything I've learned about life: it goes on." - Robert Frost 1874-1963

Nice function, But anybody any idea how to make it returning only unique values ? Can't figure it out "In three words I can sum up everything I've learned about life: it goes on." - Robert Frost 1874-1963

'Yes. All of the users have the same permissions.' Meaning... the permissions on the folder are on the AD group(assuming you use AD). Does this person actually is a member of this group ?, hasn't the password been expired after they logged on this morning... "In three words I can sum up...

I guess it is not really possible, The start menu is just another folder with shortcuts, and if you right click on it and say explore, you basically say, explore this folder. But i think adding a shortcut pointing to %SystemRoot%\explorer.exe C:\ in your quicklaunch bar will do what you...