Search results for query: *

Oh, if you post code, it would make things a bit easier to read if you put it in [ code ] tags just to let you know.

Oh, sorry. I forgot two small, but important parts of code that you'll need. This one makes the page visible to you. Some things don't work unless it's visible. IeApp.Visible = True This one tells the program to wait while the page is loading. While IeApp.Busy DoEvents Wend Hope...

In the code I showed IeDoc. When it is set to IeApp.Document, it takes the webpage associated with the IeApp Object. It basically does the same thing.

If it is filling in a type of form, then you are going to have to dive into the source code of the webpage itself. Try to find the id's of the text boxes (where it'll say something similar to: <input type = text name = "blah" id = "THIS RIGHT HERE"> NOTE: If there is no 'id', then 'name' will...

If the URL is always in the same place, then this code should do the trick. If not, then hopefully you can find some use out of this Function surf ' // Get the main system object Dim Sessions As Object Dim System As Object Set System = CreateObject("EXTRA.System") ' Gets the system object...

When you say webpage, do you mean like in Internet Explorer? If so, then yes it is possible(At least in IE, not sure about other browsers).

I appreciate your help, but I figured to do that on my own around 2 weeks ago. Thanks anyway!

You never initialized "MyRange" nor "xlSheet" either. Not sure if it would still work or not...

Hello, I have 4 different macros that I want to run in sequence (with some added steps in between). I know how to call other header files and call their Subs, but I want to know how to call their Main Sub. Any help? Thanks in advance. P.S. There's one macro that I need to call an hour later...

Nevermind, i figured out how it could be done. I exploited what seems to be a glitch. If you set the active sheet to a sheet that does not exist, an if statement testing to see if any cell has any string in it will always yield true apparently. Since that's the case, then one can just make a...

Thanks a lot, however i tried that and it didn't seem to work. Apparently i cannot make a boolean, that isn't too much of a problem, however i cannot even make an excel.worksheet object, nor can i use the for each you provided. I tried manipulating the code a little bit, but i'm still confused...

Hello, I'm trying to write some code that makes a new sheet with a given name in an existing workbook. However, if the sheet already exists, I want the macro to use that for what it has to do. Any help? Thanks

Hello, I have a macro that takes data from an Excel sheet, performs certain tasks in Extra, then writes onto the sheet. I can get that working normally, but I would like it so that if the Excel sheet is already open, it writes onto that particular sheet. But if it is not opened, then the macro...

I already said that I know about DisplayAlerts. It's not problem...

Hello, I have a macro that writes to an Excel Spreadsheet and then saves it. However, when the spreadsheet is open a Save As window appears when it first wants to save. But after that, it doesn't appear again. Is there a way to make sure that the Save As window doesn't even appear the first...

You see, what i want to do is wait for the user to press one of two keys, each one does something different. Is there any way that can be done? I've tried waitforkeys, but it only works for one key. Thanks in advanced.