Search results for query: *

Hi, I am setting up a home 2003 server (after running an NT PDC for years, I am retiring it)I am running Server 2003 Standard (not SBS 2003). I have opted not to run a domain anymore (not really worth it). So the server is configured as a file server and will be used in a peer-to-peer workgroup...

I have the code below in a sheet I open from another workbooks code. Sub Auto_Open() Dim TA As String If Sheets.Count > 4 Then TA = Worksheets("Stats").Range("TopAssemblyNumber") Sheets(TA).Select End If CreateCustomCommandBar End Sub It does execute upon...

I have tried to create a shell command to run a command line from an external application. The quoting of the command and the paths to the files it operates on as well as the redirect for the log file is proving.... well exasperating to say the least. Here is the code the VB has in it: Shell...

I need to run a command line for an application installed on my machine. First I need to change to the directory where the .exe is located and then execute the command. I thought I could start a cmd window and then use sendkeys to cd to the directory and then execute the command line. Sendkeys...

Okay, this is a tricky one I think. I have popup menu (right click) that fires when a user clicks in any cell of column 2. Here is the problem. I create new worksheets (Sheet.Add)in a very sophisticated macro, since the rightclick fires the event (Worksheet_BeforeRightClick)the ability to...

I have what I think is an interesting little conundrum. I have an Excel spreadsheet with multiple sheets. On any given sheet in column 1 is a number that potentially represents another sheets name or an entry on a "master list" sheet. In a column next the first is an another set of numbers...

Here is an interesting one. I create a menu bar with the code below. It works fine. When I run one of the menu selections that opens a modeless dialog from this menu bar after the box is dismissed the menu bar resets its position up at the top vs. where I last left it. Any thoughts? Sub...

I have been adding custom menus and submenus with calls like: MenuBars(xlWorksheet).Menus("Data Management").MenuItems.Add Caption:="Get 4D Costs", OnAction:="GetCosts" I noticed that to the left of the submenu (the gray area) many of Excel's default menus have icons (like the File menu, Save...

I bet this is an easy one, however damned if I can figure it. I have the following code to add menus to a workbook upon opening it. From time to time, multiple versions of the same file are opened resulting in redundant menus. How can I check for a menus existence and not recreate it. Guy Sub...

Hi, I am adding commandbuttons and other controls at runtime to a userform in Excel. Once added the buttons do not work based on the subroutine that should catch the event. Example below: Sub PushButton_click() Beep End Sub Private Sub UserForm_Click() Beep End Sub Private Sub...

I have a NT Doman server running Xitami. I have a Linksys BEFSX41 router/firewall. Port 80 and 8080 are forwarded to the NT server IP(has single NIC with fixed IP). Disabled ignore ping from outside on router. DHCP is running on router. Range of handed addressed is outside fixed IP of server...

[sadeyes] Okay, My head hurts! I am getting ready to set up a new 2003 Small Business Server Premium Edtion. In an effort to teach myself web serving basics I am working with my current NT server and a MAC OS X machine to test serve a few simple web pages. I have Verizon DSL (dynamic IP, I use...

[sadeyes] Okay, My head hurts! I am getting ready to set up a new 2003 Small Business Server Premium Edtion. In an effort to teach myself web serving basics I am working with my current NT server and a MAC OS X machine to test serve a few simple web pages. I have Verizon DSL (dynamic IP, I use...

I have a CAD package (SolidWorks) in which I have created a series of menu choices. As part of the CAD package boot process it starts another VB program that I have created. From the menus I created in the CAD package I would like to execute functions/routines of the VB program that is now...

I have created this macro and it fails in Word. It will not run and complains about the xlToRight in the insert command and then all the sort functions it complains about too, i.e Range, xlAscending, etc. Yet it works in Excel. Is there some limit to calls made to Excel from other applications...

Just wondering if anyone here uses 4th Dimension from ACI, it's a RDBMS that is vastly superior to Access and has one of the best database language structures I have seen.