window

Hello All, I'm currently working on updating a logging system we use at work. Currently the log has 4 Columns. I have revised the log in order to add a macro program to automatize a few items. So here is what we have. Column A has been page set to either have a blank or "C". This being if...

Hi Team, I have the following code that returns data from the web (via Power Query): Application.ScreenUpdating = False If CheckBox1.Value = True Then Sheet3.Range("B4").ListObject.QueryTable.RefreshPeriod = 1 Else...

Hi there, I have a userform which has a large amount of user inputs on the left hand side. There isn't much room and everything is a bit small and difficult to operate. The right hand side of the userform has some other controls which need to be visible at all times. Is it possible to embed my...

I would like to set up a link from a cell to open an Explorer window and search for tags that match the cell's contents. An example would be: 1. Click a cell that reads "Golf". 2. An Explorer window opens and automatically searches for any files tagged with the word "Golf". I already have a...

Hi guy ! How can i go directly to a window of an application with it'ID , because it does not have Please

Hi, will like to check how do I scrap data from a pop-up window. Will appreciate if any information/ example can be given for me to make reference to. Thanks.

Why when I go to the open command in excel the window is full sized. I cannot resize it or minimize it. The excel window itself I'm able to resize or minimize, but the minute i click open the window locks - I can't resize or drag it. Any idea why? It's really annoying when I'm trying to...

When using the Immediate Window in the VBA editor, if running a macro from one of the open workbooks, is it possible to specify which workbook it runs from instead of having to click into the project containing the macro? For example, say I have three open workbooks and each of them contains a...

Hi I am trying to display trend equation on my line chart but the option is grayed out in the format trend window. Why is that? Thank you so much.

I hope someone can help me out with a pivot table problem that I've yet tofigure out. I have a table setup that counts the number of instances that a trailerdelivers on an hourly basis. E.g., we have 7 deliveries at 08:00 AM. Most ofour deliveries are given an hour to complete the unloading...

Hi, Just have a question here, we have a shared Excel file and open by anybody at same time, however i have some risk that other may change the file while open to me. Is it possible that excel file open for only 1 user, and for some user, pop up the window that is open on user(application user...

Hello, I have Excel for Mac 2019 und want to design UserForms in the VB editor. I can create new UserForms end edit them in the designer window but once the designer window was closed it cannot be reopened. With right click on the UserForm entry in the Projekt explorer there is no entry to open...

Hello everybody. I'm scraping data from a site composed by hostile zulpages. I'm doing pretty well performing a good number of tasks. Now the problem is scraping a table in a modal window. https://imgur.com/a/CzHLnID As you can see in the image, the window is opened clicking the red button...

Good morning. I am adding sheets to work books using the right click on the sheet tab. After you have added 5 or 6 sheets, the 'Move to End' option drops off the window and you have to stroll down to the bottom to find it. Is there a way to make the 'Move to End' line remain at the top of the...

Hi I want to save as a workbook so I wrote the code below. It works fine, it gives me the window below which is save as window but when I click No (so I can pick macro enable file), I get this error message I know I am not following the syntax of Save as, but it used to work just fine...

Sigh... without confusing everyone with my 'non-working' code, here's what I am attempting to do: 1) I have a WS named "Washer_S25", among many others. 2) Every sheet has a date/time column B; using the format MM/DD/YY HH:MM 2B) A userform1 posts the date & time using the Now function. 3) Using...

Within my form, I need to open an external DB another Form but when I run the command, the window sits in minimize mode.... Private Sub Command38_Click() Dim appAccess As Access.Application Set appAccess = CreateObject("Access.Application") appAccess.OpenCurrentDatabase...

I am using the FAME (facebook ads manager for excel) add-on which downloads ad data from the api. It's pretty neat but I've noticed it won't download data unless excel is my active window. This means I have to sit and stare at my screen doing nothing else for the time it takes to download. Do...

Hi, I have a spreadsheet that is write password protected for certain cells. I assign a password via VBA to each worksheet. I have the same password assigned to the project in the project explorer window. This worked perfectly until I tried to change the password. Now it keeps telling me the...

For some reason my immediate window only displays the last half of my output. It's only a couple hundred lines at most. I ran a for loop from 1 to 10000 and it worked just fine. Anyone know what the problem is?