internet

Hey Guys, do any of you know how to import into Peoplesoft from a flat file? From what I understand its an excel file converted into a txt file. I am trying to learn how to do this and the internet doesnt have anything that can help me. Thanks, Jordan

Hi! I got a question with VBA (bit of a novice) I've written the following code: Sub test() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("secure website") While .Busy Or .readyState <> 4...

Hi all I am looking for an easy -and working- formula to tell me when A1, B1 and C1 values are the same, after a search for help on the Internet I feel very confused, thanks in advance for your help. ColdGeorge

Hi there, I've been struggling with a problem for a macro that uses IE to open up a webpage and download values from a table to Excel. The macro works fine on all but 1 of my colleagues computers here at work. I can't figure out why his computer behaves the way it does, as it should have all...

Hello, I am having trouble with the below code. For some reason it will give a run-time error sometimes, but it is completely random. Unfortunately I can't provide the URL since it is internal but I'm thinking this error is due to a timing issue. As you can see below was my attempt at fixing...

I’m struggling to import data from the web from either of two web pages. This one https://mobile.sportingindex.com/markets/4855dfa3c28b43ceb332768100728224/c0c1dc8fc78347cca90c48e40328a64b/group_a.7e4187d6-9e42-4bb0-9bde-779fd4019f61/00000000000000000000000000000000 Doesn’t have the ‘buy’ or...

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!

This is the third time this has happened to me. I get a warning message that this site (Mr Excel.com) is not secure and my browser will not let me access it. I give it some time, days even when it initially happened, same result. I trial different browsers with the same result. I can access...

Hello! I am trying to write a macro and the first thing I need to do is log in to a website. It appears that I am able to have the macro open up the website, enter the username and password but I'm struggling with getting it to submit. Can someone tell me what I'm missing here? Dim HTMLDoc As...

Hello everyone, I inherited a table that compares the exchange rate taken directly from the Internet to the one from the database of our system. Afterwards, on the page they added a line that I do not need and I do not want to compare, so I'm interested in how to delete it from the table? My...

I'm trying to pull some sales data from a table on a website.... Seem to be stuck, getting "error 70 permission denied"..Is my code correct? Here is a snippet...everything up to this point is OK...I think it is the "innertext" line that might be erroneous. Set html = ie.Document Set...

I am trying to copy and paste data from the internet and it works fine at my work computer but when I do it at home it puts everything in column A rather than spread it out across the columns. Any suggestions as to why this may occur? I am most likely using different versions of excel at home...

Hi, I'm trying to populate a text field on a webpage; it looks like this: Using Chrome's element inspector I've determined the associated code to be: <code style="font-style: inherit; font-variant: inherit; font-weight: inherit; white-space: inherit; margin: 0px; padding: 0px; border: 0px...

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!

Hello Mr/Mrs Excel(s), This is might be a piece of cake if I were a MVP or expert in excel but I'm not. I went around circles on the internet and couldnt find what I desired. Here's my case. I had a textbox which I wanted to return the COUNTIF result after pressing a CommandButton. I know in...

Hi, thank you for reading. What I am looking for is a formula like If B18 Contains Apple, then I18 = "$6000" if B18 contains Essential, then I18=$12000" if B18 contains Access then I18 = "22000" Can something like that work? I just need it to find one word in a large paragraph of text. Oh...

I have a small query related to Excel Vb.I want macro which is get the value from Sheet1 in A section and open into internet explorer.when the page open it.It should copy the urls and paste into sheet2.if we have one or more value in sheet1 it should open all the urls and copy all the multiple...

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...

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...

I'm creating a database of prospects and have gleaned some info from the web. The problem is, the lists I copied & pasted have "Email: " prior to e-mail addresses and "Website: " prior to website addresses. I thought I could just find & replace these with nothing, but Excel doesn't see these...