application caller

Hi, I'm trying to execute VBA code stored inside a variable, but so far no luck. I can compare it to PowerShell where you're able to do this: $currentuser = whoami PS C:\Users\testuser> $currentuser azuread\testuser PowerShell will execute "whoami" when you run $currentuser. If i try to...

I have a lot of data in an excel file, and one tab is for data entry only. I want just that sheet to be on calculate manual at all times and have that "Calculate" stay there. Is there any code that will keep that "Calculate" down there? Application.Calculation = xlCaluclationManual does not do it.

Dear all, I am an advanced VBA user as far as using it on the default Microsoft office applications is concerned. But currently I am writing a macro where it would be very beneficial to know how to control third party applications from VBA. Up till now I was quite successful using the Sendkeys...

I am creating a spreadsheet in which I am able to click a control button to bring up a form to enter dates, amounts, etc. It was working. Then it stopped. I wish I knew exactly what I changed, but I started receiving the run-time 13, type mismatch error on the line that assigns...

My friends, as a novice on VBA I'm struggling with a script. Basically it should select 2 defined ranges and copy those to the clipboard. That's all. But I have 18 different value ranges and 2 header ranges. Script should combine 1 header with 1 single range. So I need 18 individual scripts...