@Velouria, thaks for pointing that out but I did that in the past first times many years ago but ran into issues with the LongPtr declartion. I set...
I wouldn't use N/A since it's also the way to show an error
@Charles: one tip make sure your code works with both 64-bit and 32-bit versions of Excel #If VBA7 Then Private Declare PtrSafe Function IsClipbo...
The code wil have to check if the file is present in the target folder, if it is, the use the command kill fullfilename (this means path AND filemname...
I think you should try use vb scripts instead of Excel VBA. I use vbsedit for many tasks, the code is Visual Basic and you can do much more. Vbs...
Good day, I also suggest you post the Excel version you're using
Great to read. Happy it helped one way or another. May I ofer you a tip, I have similar files wher I hide and unhide multiple worksheets and the th...
I use these code snippets I found a long time ago to remove all the connections that are created, maybe they can help you Public Sub RemoveC...
You cell content is imported as text and not as a sumber
Looks great. pity my 2021 version runs short on the new 365 functions ;(
I'm curious, this dynamic spilled array, is the number of elements in a cell limited to 2 or can there be more than 2?
I don't remember USERNAME() or USER() to being a function in Excel; it's a Windows setting You will probably have to use a macro to retrieve the E...
Okay, congratulations for your new job. You know where to find us
You can build it into the template file (if its'macro enabled) to correct this when the new file is gerated. You have to cross-check if the filename i...
I agree with Riny that PQ is a serious option. In my case, since neve stepped into PQ, I wrote an AddIn that contains all the functionality to pro...