explorer

Dear All - I have a clients folder on Drive "D" and there are 2522 XL file numbered from 10001 to 12522 - each month i do a backup for the clients active that month - there is a file named "LIST" that have all active clients ID - So what i wanted to do is a way that i can copy the files that...

I am attempting to automate a form on our business proprietary website - which has nested frames. There are a few select drop-down elements and a few text box elements on the frame. I have searched the internet and tried just about everything but keep failing to snag the sub frames needed to...

Hi all, In brief, webquery cannot import JavaScript, that's why I thought it could be easier just to make VBA do following: Switch to internet explorer, go to web Topic Related Searching at ANY.COM., wait 30 sec, select all (as if ctrl+a), then copy (as if ctrl+c), then back to VBA...

Hi, i'm trying to automate a download process using a macro. SO far i've got it to work good, but I'm struggling with the last bit of my code. Basically the code i have so far logs on to a website, adjust some parameters and then clicks download. The problem is that after i press download...

Hello everyone, Long time lurker, first time poster here. The solutions I have found on this board have saved me countless hours in the past so thank you! When you click on the below link it opens a PDF. Is it possible to use VBA in Excel 2010 to save that PDF to my PC? Maybe save it as...

Hi there, I want a macro to open windows explorer and just select a file but don’t want it to open the file. I’ve got a list of document names in excel split into some variables. I also included some hyperlinks in it, so you can directly open the selected file. But now I want a macro that...

Hi All, Thanks in advance for your help. My question is pretty much summed up in the title. I have a .csv file that is saved in the same location as the same name every day. I then visit a webpage that has some text, a field for the file name/path, a browse button, and an upload button. I...

Hi, I have some files that are fairly tedious to process. Basically all I have to do is open a report (it's in .txt delimitted format), filter a column for a value, copy the results of the filter and paste them into a sheet in a different workbook. Then I repeat for each report in the...

I am trying to get property tax values for about 200 properties. The info is publicly available on this site: http://www.hawaiipropertytax.com/Searc/GenericSearch.aspx?mode=PARID I have a list of Parcel IDs (also known as TMK Value) that identify properties in a spreadsheet. Here are just two...

Const strURI As String = "http://www.google.com/#sclient=psy&hl=en&safe=active&source=hp&q=site:+squidoo.com+%22space saver treadmill%22&aq=f&aqi=&aql=&oq=&pbx=1&bav=on.2,or.r_gc.r_pw.&fp=d69918eb06677aa8" This code snippet deals with one single hard-coded http, but I need the code to reference...

Hi: I need to figure out the VBA---either run by a Word or Excel macro, it doesn't matter---that cycles through all PowerPoint, Excel, and Word documents in a folder and then updates the following property fields: Title, Subject, Author, Category, and Keywords. I can use Application.InputBox to...

I have created a userform with Command Buttons to open various spreadsheets that we use very often. What I would like to do is add some additional buttons that would open Windows Explorer in a specific folder. Even better if it would default to the "Search" option. Can this be done?

I found the code below on an earlier post from 2002, but it did not give me the full path, including subfolders and file name. It just gave me the files in that particular folder and did not include the subfolders, etc. How do you change it so that I get the full path? I want to use it for an...

A gracious individual posted a solution to my problem here: http://www.mrexcel.com/forum/showthread.php?p=2172141#post2172141 However, the solution doesn't work for me. For whatever reason I can't install (MICROSOFT INTERNET CONTROLS) or (MICROSOFT HTML OBJECT LIBRARY). I need help finding out...

I am simply trying to select the Last Name and State radio button so I can then move on with the rest of my routine. Any help would be appreciated. I am having issue with this piece of code: Ie.Document.getelementsbyname("L")(1).Click Here is the below HTML I am sourcing from: Find a...

Everything works fine with this code...,but the last piece. IE.Document.forms(0).submitIt's not selecting the proper HTML button. I have included the HTML source code to identify tags: Below is the full routine: Sub NPIRegistry() Dim IE Set IE =...

I am having trouble running Excel VBA code in an excel workbook through Internet Explorer (IE). The code I have runs fine in Excel. But when I running by opening in IE I get an error. For example trying to run the simple command Range("A1").Select Results in the error message Method 'Range' of...

Hi, I have an Excel Sheet with some questions on it and I send this this worksheets with VBA code which works in MS Excel but when you put this file on a webpage the Thisworkbook.SaveCopyAs mypath & myfilename debugs. The code is below. Sub SendMail() Dim Msg, Style, Title, Help...

Hello, 1. Does anyone have a VBA solution to determine which IE version a user has installed? I would like to use in a select case statement to process web actions based upon the version installed. 2. If user has IE8, does anyone have VBA code to open new browser, open a couple of tabs...