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!

  • Congratulations strongm 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: *

  1. john30120

    Excel Menu Calls Macro on Focus

    Thanks to Fumei..... There is an interesting subtlety as to how the new menu item is created. If you use Tools,Customize,Commands and then under the Categories column select "Macros", then you can rename this menu, drag it to either the toolbar or a submenu. Then right click on that and Assign...
  2. john30120

    Excel Menu Calls Macro on Focus

    Please let me start over. There is no code. I have created a custom menu item called "My Menu Item" and it dwells in the Insert dropdown. I have linked it to a subroutine which does nothing except set j=j. And I have put a breakpoint on that line so I can see when it is called. I would hope...
  3. john30120

    Excel Menu Calls Macro on Focus

    I have a spreadsheet wherein each row is an entry for a sequential date. It may be necessary to add an entry in the middle of the old data. So add a row in between the 2 rows and process the data and update the spreadsheet. But that is not my question. Assume I add a custom menu item to the...
  4. john30120

    Excel Menu Calls Macro on Focus

    I want to allow adding the row only under certain circumstances and VBA is a nice way to sort this out. Additionally, I am trying to learn the nuances of VBA in Excel and it seemed strange that the menu would call the macro before the caption was clicked.
  5. john30120

    Excel Menu Calls Macro on Focus

    Using Excel 2003... I have a added a custom submenu "Add New Row" to the "Insert" CommandBar. It calls a VBA subroutine. The problem is that the subroutine is activated when "Add New Row" gets the focus (or mouseover) and does not wait for a click. As a side note, but maybe part of the problem...
  6. john30120

    Excel VBA write to cell

    Wow! That seems an unnecessary limitation. I have seen examples of code elsewhere that seems to write to cells butgivien my struggles it seems you are correct. Thanks
  7. john30120

    Excel VBA write to cell

    Using Excel 2003.. I am trying to write from within a VBA function back to the worksheet. j=Range("B1").Value reads the value into j just fine but Range("B1").Value = j generates an error the worksheet is not protected and the function result reads back into its cell OK. I am missing...
  8. john30120

    Subclassing within activeX

    The essence of the problem is this. In a regular VB EXE program you might have MyForm.bas and MyModule.mod and if you had a subroutine in MyModule.mod that needed to call a subroutine in MyForm.bas you could do so with the call call MyForm.mySub(). In the ActiveX world you have UserControl.ctl...
  9. john30120

    Subclassing within activeX

    I am trying to do something in VB6 that perhaps would be better done in C++ (which I am trying to avoid due to incompetence). I have a dll that interacts with the sound card and returns events through windows messages. To set up the subclass to intercept the messages I need to use the AddressOf...
  10. john30120

    Using iTivity (VNC) with RDS

    Thanks to all and especially Brian for excellent vendor interest and support. Running the admin agent as I am doing now is serviceable and essentially solves my problem. But, it looks as if the iAgent v5.1.01 would be a complete fix. I'll contact the software company and see if they want to try...
  11. john30120

    Using iTivity (VNC) with RDS

    I have had a chance to work with the server and a workstation side by side. Indeed the problem seems to be with the graphic output of the iTivity. For example: Logged in as user1 on the server and user2 on the workstation, iTivity Admin is started from the workstation. The icon pops up on the...
  12. john30120

    Using iTivity (VNC) with RDS

    Several points and thanks to all. 1) Running the RDP in "console" mode makes no difference. 2) I have tried both the iAgent and the iAdmin and neither works using RDP. Medware (Sage Software) is using iAgent v4 as they don't yet have an automated install for v5. I can do a manual install of v5...
  13. john30120

    Using iTivity (VNC) with RDS

    The RDS works otherwise OK. There does not seem to be a port conflict. There may be an inherent conflict with using iTivity with RDS although I can't get directly to their customer support. I'll investigate using the RealVNC. Have you used this specifically with iTivity? Thanks
  14. john30120

    Using iTivity (VNC) with RDS

    I am using iTivity (supposidly uses VNC) to connect an XP Pro box to a software help desk elsewhere for program maintenence. I would like to activate this connection using Remote Desktop to control the box as the XP Box is physically hard to access. I understand that XP only allows one RDS...
  15. john30120

    CGI.PM Upload TMP Directory

    oops... I left out a vital line in the cgi script. use CGI; $CGI::DISABLE_UPLOADS = 0; $CGI::POST_MAX = 128 * 1024; binmode(STDIN); $query = new CGI; $filename = $query->param("UploadFile"); $tmp_file = $query->tmpFileName($filename);
  16. john30120

    CGI.PM Upload TMP Directory

    ##### HTML Code # <FORM name="Upload" ACTION = "/cgi-bin /upload/uploadDisplay.pl" ENCTYPE="multipart/form-data" METHOD="post"> # <INPUT TYPE="file" NAME="UploadFile"> # <input type="submit"> # </form> ### End HTML # script at /cgi-bin/upload/uploadDisplay.pl use CGI; $CGI::DISABLE_UPLOADS =...
  17. john30120

    CGI.PM Upload TMP Directory

    Using a Perl script to process a file upload, I am trying to assign the temp directory to an existing r/w enabled folder (windows box) on my website. Apparently, cgi.pm looks for a "/tmp" folder off the root and if not found sticks the file in the cgi-bin directory with the Perl script...
  18. john30120

    Using an ISA card

    I need to update an automation program to VB6. It was written in Quickbasic and used interrupt driven assembly routines to cycle the interface cards. The hitch is a 32 channel A to D card that must use the available ISA slot. The ideal solution would be a custom control that would convert the...
  19. john30120

    perl cgi and SSL

    The ssl links to the /secure subdirectory of the server. It is accessed by https://myDomain.com/secure/index.htm I will put the cgi-bin directory under this so <root>/secure/cgi-bin/makeHTML.pl Thanks
  20. john30120

    perl cgi and SSL

    I am converting an NT hosted website to use a SSL connection. The present site generates its web pages by running perl scripts in the cgi-bin directory and reads and writes files from the files directory. My inclination is to move the cgi-bin and files directories as subdirectories under the...

Part and Inventory Search

Back
Top