Recent content by Daedelus

I first learned to program 28 years ago with whatever version of basic was implemented on the HP2000 mainframe systems. While I am not a true programmer, I have used a wide variety of languages over the years, and learned some basics of others. I have seen some truly torturous syntaxes. What...

Thanks! That is what I was looking for. I am sure that there are better ways of accomplishing this. But I am also sure that my XML is not up to the task. For my fairly simple purposes, SendKeys should work fine.

I don't control the server and have no idea what is running on it. I didn't write and have no ability to change the form. I am only someone who has to fill out the form. All I am doing is writing a VBA app for MS Excel to make it easier for me to accomplish this. I was only wondering if it...

I have an Excel application which prepares data for entry into a web-based form on our Intranet. It even opens IE for me and sizes it so I can see both the information and the form to enter it. But I would prefer it if I get the app to fill in the data itself. Is there some way I can send a...

Thanks! Is there any way to direct a text stream to the webpage? (I would like to automatically enter data into the entry fields.)

How can I open a browser and follow a link from a VBA script, and control the size and position of the browser window? I have an Excel spreadsheet application that organizes data in the spreadsheet for entry into a form on our Intranet. I would like to have it not only organize the data, but...

I searched until I found the help pages explaining this. This has got be one of the most ridiculous syntactical rules I have ever come across! Parentheses are required for functions when returning a value, but cannot be used when ignoring the value. Parentheses cannot be used when calling a...

I have a subroutine declared by the following line: Sup Fliprows (ByVal tp as String, ByVal bot as String) I have tried to call it with the line: Fliprows ("ZMeetings", "ZSixSigma") When I try to enter this line, however, the VB Editor comes back with: Compile Error: Expected: = Try as I...

Sorry. I was wrong again (I did this over a year ago). I apparently created the buttons using the "Forms" toolbar, not the "Controls Toolbox" toolbar. No wonder I was having such trouble. Thanks, and a belated thanks to Skip as well.

Sorry to take so long (10 months) to get back to this. I was hit with a very heavy assignment before I could go any further, and am only now getting back to this issue. I created these buttons using the "Control toolbar" in Excel. Once the button was created, right-clicking on it provides a...

My apologies! I was searching the windows forums for threads relating, and had not realized it sent me back here when I decided to post.[hammer]

This is probably simple, but I can't seem to locate the right syntax/locations. I have a workbook with a macro which, at one point in its execution, opens a form for user input. I would like for the last value entered to show up as the default the next time the form is activated, even if the...

Thanks. Actually, I just discovered a solution. I came across one help page example where in they created the dictionary with the line: Set d = CreateObject("Scripting.Dictionary") Apparently the argument has to be a string, even though they don't show quotes in most of their examples. Once I...

I am trying to create a dictionary object in a Visual Basic Macro running in Excel. The VB Help shows this example for creating and populating the object: Dim d 'Create a variable Set d = CreateObject(Scripting.Dictionary) d.Add "a", "Athens" 'Add some keys and items d.Add...

Thanks! That helps, but it doesn't get me all the way home yet. In order to use it, I need to know which control was responsible for the function call. And unfortunately, I have not been able to figure out how to do this either (other than assigning each button its own subroutine). That may be...