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...
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...
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...
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.
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...
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
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...
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...
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...
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...
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...
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...
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
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...
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);
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.