Search results for query: *

ShackDaddy, Thanks for the tips! I currently have a router acting as the DHCP server but I think your idea of DNS and DHCP looks like it would be the best. I have read through various books and understand dynamic updates. No need for WINS as I run XP on all the clients.... well I have some...

Great!!! But what is broadcast and where can I find out more about it? Nice web site too. Guy

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

Okay gentlemen, Here is the skinny to date. All the help is great and in the end the thing that did it was putting quotes around the entire output string and now it works just great with one exception. The logfile is created, but the VB code is getting to the logfile to early by the looks of...

Man this is frustrating! Still no luck. Here are a couple pieces of info. The VB program I have attempts to read the log file after the Shell is run. The log file is not created so that fails, that tells me the shell command is not understanding the redirect at the very least. However it more...

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

Gentlemen, That did it! I think I am all set! Thanks for the nice finish to the week. I will sleep a little more peacefully this weekend. Guy

Hugh, Tried the above and a few other options. Its weird that I cannot get it to run. Guy

Well, I am stcuk again. I have created a command in VB that yeilds the following output to the Immediate window. "c:\Program Files\EDS\Unigraphics NX 2.0\UGII\ug_convert_part.exe" -in C:\Temp\3_1.prt -o C:\Temp\convert > c:\temp\log.txt It will not work from within VB but if I cut and paste...

Hugh, Great! The idea worked. One last thing, the command line I send would normally return to the command window the result of its action, i.e. Parts Converted 1, etc. etc. Is there any way to capture this message and return it to the VB user? Thanks!

Not sure how to use just the Shell command, i.e. to hand in all the parameters I need to. I need to run the command line: ug_convert_part -mm -d n:\thisistheobject.prt -o c:\temp. This needs to be run from a particular program file dir as it has pathing issues with supporting .dll's. Thxs

Not sure how to use just the Shell command, i.e. to hand in all the parameters I need to. I need to run the command line: ug_convert_part -mm -d n:\thisistheobject.prt -o c:\temp. This needs to be run from a particular program file dir as it has pathing issues with supporting .dll's. Thxs

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

Sorry Figured it out , was recreating the menu by accident on window activate!!

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