Hi. sorry to butt in like this but I made some minor changes to pgt-example-3 to avoid the error in C4 when there is nothing to split and als when the...
Tenta questa soluzione Default = Left(UserForm1.TextBox1.Text, InStrRev(UserForm1.TextBox1, ".") - 1)
If you're using ListObjects (Table) then it's easy but the other option is for you you say whay you think distinguishes the row you hav as the header ...
Hi, I'll say welcome to the forum. I've been on it but not posted much answers. Your question did tickle my curiosity. You mention that you just s...
Hi Phil, I figured out that much, passing shorter strings had no problems and also the text in the string is not really something I would use in a ...
Hi Phil, Excuse my budding in but I was trying to help someone of the Excel Help Forum () The texts this person is using somehow throws an error an...
Hi, besides the fact that you are cross-posting (Excel Help Forum), why aren't you attaching your file with the macro? You've attached a xlsx file ...
Update: I added a Public Sub Auto_Open (instead of Private) and just invoked the macro Begin_Here again, then it works but what really bugs me is that...
Forgot about the Function Captiontxt, sorry, that's nothing, the TempFileList.lst is the files name and extension the log is part of the xlsx filename...
This is the full code. GetProjectlogBestanden is the modified version that I rewrote so that it works GetProjectlogBestanden2 is the original co...
Hi Phil, Thanks for your answer I understand you don't have the variables, but that's not the issue, the fact is that under Office 365 Business th...