active window

Hello all, I have a macro that looks for a "Save As" window to popup. Once the window pops up, the copied value of the cell will be pasted and then saved. My issue, is that I am now having to run the report program that creates the save as window in a Virtual Machine. as such, my code...

A spreadsheet I'm working on is calculating days since an injury has occurred. I have a macro set up in my VBA editor that recalculates it every (x) minutes/hours/whatever I set it up as. When I paste the object into powerpoint to run on our warehouse displays it will refresh a few times, but...

We are trying to write a script that opens Internet Explorer into a webpage that acts like a DOS screen. We then need to begin typing into said webpage. Below is the beginning code we have managed to make but it does not make the IE screen the current active screen to begin typing into and we...

Hi All, I have a macro which, at the moment, creates a worksheet, names it, alters columns etc, adds a table, and converts the table back to a range so that it can later be copied to a new workbook. At the moment all the alterations are made apparent to the user regardless of screenupdating =...

I am making a macro that will export data from an excel sheet to a powerpoint presentation to skip repetitive copy and pasting. Some of the data I'm grabbing is of variable size. I want to use the input box to allow the user to select the needed ranges. However, upon opening the powerpoint...

Hi, We decided to automate the ASAP Utilities' Functions through our code. I believe we don't have a decent choice but SendKeys. So as SendKeys has a global nature in sending the keying events across applications, It is better if we have a total control on the active window. Is there a way to...

Hi, I'm trying to write a macro that records the titles of the active window, together with the times that window was active for (i.e. start and finish time). The macro should run in the background all day long and record until closed. Please note that I mean Windows window, not Excel...

So I've created an Excel workbook to start and stop an external stopwatch and automatically copy the time to Excel, and everything works perfectly except the Stop function. Half the time it activates and the other half it doesn't. I used the ALT+TAB VBA SendKeys command which works fine, but...

I am running a budget model schools through excel in which there are multiple tabs into which I enter the inputs (e.g. #of students enrolled, maintenance cost/square foot, english department budget, etc.) and a single tab on which the output budget is calculated and summarized. The challenge...