window

Hi, I am using Power Query with Excel 2010. If I want to check something in Excel proper whilst developing a query, I have to close the Power Query window to do this. I.e. It doesn't work like VBA editor! I find this behavior irritating - is there a way that I can navigate within Excel tabs...

Hello. I created VBA code to download data from SAP and it works fine. The only thing is that it takes a long time and changes SAP screens frequently. Is there any possibility to force SAP window to stay in the background? Macro starts a new SAP session at the beginning and closes it at the...

Hi Experts.... I don't want other users to be able to see my DAX formulas... So, could you please tell me VBA code to PASSWORD PROTECT from users opening Data model window. Thanks in advance

Help please! I am using Office/Excel 2016. My VBA Editor has got screwed up. The Project Explorer is rammed on top of the Code Window and both are immovable. When trying to view the Properties Window it takes up the whole screen and is immovable. I want to have the original configuration -...

Per the title, I can see the added table in the Measure Edit window, and I can see it in the Power Pivot window, I can create a measure that accesses it's columns, but I can't see the table or the measure in the PivotTable Fields window, even if I select ALL. Has anyone else seen this type of...

I've managed to get to the active window ( the pop up window) but am unable to access information in what appears to be a table within ( the table doesn't have a name and only thing to go by is classnames... attached is the html / jsp code would appreciate some help here pls... < body...

I have an excel file in which I have made three data connections using the data connection wizard. the option first selected was "ODBC DSN". I have unchecked the "refresh every XX minutes" option since sometimes when refreshing I get a popup window with an OK button that states that there was a...

Hello All.... My requirement was to fetch few records from an excel sheet based on some criteria. Because this is the first time i have got an assignment where i have to learn VBA, i wrote a simple code to fetch data based on just one criteria (i'll include the other fields and checks later)...

I am running some old code, and during the programme , it opens a window for one of my folders, as if it is looking for data or saving , if i press cancel on the window the code continues to run and completes. All the data is correct so if clearly does not need whatever may have been in that...

Hi, Whenever I use the Autofilter option I have to manually drag the window out so it's wider and longer - I'm doing this everytime as my selections are many and wide (lots of characters), am doing this several hundred times during each session!! Is there some VBA or setting that will widen the...

I have a long list of formulas which use a vlookup to other workbooks. I wanted to change the date in the name of the workbook being refereced in the formulas so I tried that by the find and replace function but when I do that, an "Update Vales" window pops up and when I close that window, only...

I'm running Excel 2016. I have xlsm file that hides the application window when its userforms are running. If I attempt to close another Excel workbook (Book1) that has no macros, the Excel window for the xlsm appears visible and becomes the active workbook, and Book1 still remains open. I've...

Hi Guys, I would like to know if it's possible to create a custom window in excel like the one below (Accessibility Checker): My idea is to use something like that to create a menu for my spreadsheets at tha left side. Once we can create ribbons, maybe it's also possible. Anybody knows...

I am trying to return to Cell A1 in a very large spreadsheet however the window will not scroll with the Macro I have created. I do have the Freeze Rows and Columns turned on. The window stays on column BC. Does anyone have any solutions? Thank you

Hi, I'm looking for some code that will take a screen dump of an IE window that is already open and copy it to the clipboard. So, the code mimics me moving from Excel to the IE window (that is already open and maximised), doing a printscreen/copying the whole page, and then pasting it into the...

Hi, I have the following code that opens an internet window from Excel using vba, however the IE window never opens up 'maximised' - how can I adapt my code to achieve this? Dim IE As Object Set IE = CreateObject("internetexplorer.application") IE.Visible = True IE.navigate...

Hello, How do I write a code to activate the 'Save as' window and a certain location. the name of the file will always be different that I want to save it as, but the file path will more or less be the same. Thanks for your help. Best wishes, Peggy

when ever i start the process of printing a window shows up to preview the print before i print the document. so when i cancel that window to adjust a few things these dotted lines show up on the page and for some reason i used to be able to move those dotted lines around but now i cant. i think...

Hello, Is it possible to create a window or box on a sheet within a workbook where I could drop another workbook into and it would rename it and save it to a predetermined location?