explorer

Hello All, This is one of those annoyances that just pops up from time to time and I can find nothing on it anywhere. i work with a dual monitor setup. Often it is better to drag the vba editor from one monitor to the other. Every time i so, it now resizes the editor to the size of a very...

Hello I'm trying to open 4 windows of "explorer.exe" (windows explorer) application and I would like to define their position and size. I found some code which works perfectly with notepad ! I've tried to modify it ...to make it work with "explorer.exe" I've replaced : np_retval =...

I need a macro that , in excel, shows a folder name, its path, # folders underneath it and # files in each folder. Each sub folder would also be listed and properties included in the spreadsheet. Like I was clicking on properties of each folder and sub folder individually (which I don't want...

We have a corporate Power BI MIS, which is hosted on the Power BI cloud. When you log in it picks up your credentials from your PC so there's no actual login needed but you have to go through several access screens which validate you. I'm trying to collect data from BI as the data has to go...

You would think this is easy but I, and it seems many others, can't export the details of an explorer search. I've had great success by copying an address, paste in Chrome, to show the full path, file size, and date modified of any directory. But this won't work with search results. I have...

Hi! I need to open windows explorer to access a file, and it would be nice to have a macro in that file to automatically close the explorer window (This is not Internet-explorer!) I found plenty of macros to open explorer windows (Shell) but none wich will work to close it. The path to the...

I am having a problem opening a SharePoint folder (not a specific file in the folder) using VBA. I have searched Mr. Excel extensively and have found MANY suggestions to try using... FolderPath = "http://nexus/sites/.../MySharePointFolder" Shell "explorer.exe " & FolderPath, vbNormalFocus...

Hello all, I am trying to automate some tasks which are being done through Internet explorer, which include downloading a file and then copying it to a different directory and renaming it. I was more or less successful in finding the information on how to do this, the code is working, but it...

Hi all, Is it possible to open Internet explorer via VBA, navigate to Google, take a screen shot of the Google home page and save that screen shot in a specified location (all through VBA)? This should all happen in the background, i.e. Internet Explorer shouldn't be visible to the user. Thanks!

I have two Excel's files out of 7 that shown with light color icons in Windows 10 Explorer. I am using Excel 2016. These two files will not open in Excel, but the other Excel files will. How do I correct this problem and open the file? Thanks in advance Jim Goodman

Hi - have a new laptop and after the reinstall of Microsoft Office... when I open my excel files through Windows Explorer they open in separate instances. Every file opens in a new instance. they uses to open in the same instance. I can get them to open in the same instance by opening one file...

Hello! This should be pretty simply. Was hoping for a macro that will go to a website, copy all the data (as if I were to ctrl+a), and paste that into excel. Any assistance would be greatly appreciated. Thank you!

Hi there, I am looking for a way to paste the directory of a file into a cell of an open workbook. I need the ability to open file explorer and choose the file to copy the directory from. Thanks, D

My workbook is called abc.xlsm I run the following code and it's fine, ie it saves it as abc.xlsm ThisWorkbook.SaveAs Filename:=Left(String:=ThisWorkbook.FullName, _ Length:=Len(ThisWorkbook.FullName) - 5) If I now save my workbook...

I have a web query set up (ie Data>>From Web) where the source is connected via an API. Everything is working great as long as the data set is relatively small - I can manipulate the parameters by date and it is working for 2 months (~13K rows) but if I change it to 6 months then I get this...

Hi. with deactivate whe can take actions when change of a workbook to another, but can't know when user go to file explorer or internet or another application. how can know when user leave excel? or how can know the active aplication?

I am trying to make to put a date into a field on a website and I have 2 options on how to do this and I can't seem to make either one work. 1. I can put it into the field directly which doesn't seem to be working <span class="gwt-InlineLabel WCRF WBRF" style="min-width: 14.5px;"...

Hi, I need to copy and paste only header and description from explorer link. Below link extracts all test on explorer. Expected Results as below- Kolkata gets best cities award for tackling climate change Kolkata, along with 10 other cities from across the globe, has been honoured with the...

Hi, I have created macro which copy links from HTML and paste in excel sheet. I need specific links to selected and others to be ignored. Below is the sample of HTML code and VBA which I have created. Can anybody please help me so that I can select specific links From below HTML, I need links...

Guys / Gals, The VBA Editor typically groups the code by type: - Worksheets - Forms - Modules - Class - Et Cetera. My explorer just lost this grouping and all items are now sorted strictly alphabetically. How can I restore the grouping by type? Thank you, John In Annapolis, MD