Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Daedelus
  • Order by date
  1. Daedelus

    Subroutine call error

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

    Automatically filling out website fields

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

    Automatically filling out website fields

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

    Automatically filling out website fields

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

    Opening a browser session from a VBA Script

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

    Opening a browser session from a VBA Script

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

    Subroutine call error

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

    Subroutine call error

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

    Row detection in Excel

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

    Row detection in Excel

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

    Default values for a form in Excel

    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]
  12. Daedelus

    Default values for a form in Excel

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

    How to create dictionaries in Visual Basic

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

    How to create dictionaries in Visual Basic

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

    Row detection in Excel

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

    Row detection in Excel

    I have an Excel worksheet I have set up to track how much time is spent on various activities. To make the time entry process quick and easy, each activity is listed on a row and days are listed on columns. Each row is given its own command button. When the user finishes a task, he presses the...
  17. Daedelus

    Mixed-up sorting

    ...has only a few locales (C, POSIX, and 4 variations of en_US), all of which have the same collation order for ordinary characters: !&quot;#$%&'()*+,-./ 0123456789 :;<=>?@ ABCDEFGHIJKLMNOPQRSTUVWXYZ [\]^_` abcdefghijklmnopqrstuvwxyz {|}~ The Linux cluster, which has the C, POSIX, and many...
  18. Daedelus

    Mixed-up sorting

    Annihilannic: Forgive me for not being clear in my original post. PHV has it right. I am trying to sort the contents of files, not the filenames. PHV: That works: both the Linux cluster and my workstation sort in the same fashion (-2-9 before -22-9) for the C_C.C locale. Thanks! That solves my...
  19. Daedelus

    Mixed-up sorting

    When I sort files on my workstation, I get a sorting that puts the following two entries in the indicated order: M22759/16-2-9 M22759/16-22-9 There is a remote Linux cluster that is being installed on which they sort as M22759/16-22-9 M22759/16-2-9 I figured it was collating-order difference...
  20. Daedelus

    Cannot log in to forums

    Thanks! That was the problem. I'm not too happy with cookies and had raised my security level to &quot;high&quot; a couple of months ago. The other forum has a &quot;always logged in&quot; feature that has gotten me in without problems (and I have not had need to enter Tek Tips from home). But I...

Part and Inventory Search

Back
Top