Recent content by nja5150

I'm running server 2003 with terminal services, active directory, and DNS installed. I've confirmed the DNS portion is working properly from the client XP machines. My active directory is setup as follows: Forest: mb.s Domains mb.s ->Default Domain Policy <block inheritance>...

Thanks for the additional info GVF and Harley! I've learned so much from all the help -- this site is incredible!

Everyone thanks for your input. I think I can work with other posts on char codes and the like to get what I want. I appreciate all the help! Stars all around! :)

Sounds like I can use both recommendations to get what I want. Skip...can you be a little more specific? Maybe I need to play with something else besides Sheets(1).Name for the input box -- then set valid input to Sheets(1).Name. Would I do something like... fourscore: myvar =...

Hi guys and gals! I hope this might be something someone can shed some light on for me! I've got an input box that opens up to rename an excel sheet. The trouble is...I get a run-time error if the user clicks cancel before entering in a name. The second message box (which verifies the users...

Hey guys- I was wondering if anyone had any ideas. I have set up VPN tunnels for two BEFVP41's. Subnets 192.168.3.0 and 2.0. My machines are all configured static, with the gateways on x.1. I wanted to selectively use IP ranges for my local and remote groups. However; unless I use the...

How do I modify this code to take the first 5 sheets in the workbook, or alternatively only use the worksheet names I specify. Thanks for any help!

This is a web driven report site. I do have to log in, and I do have full access to what I see on the screen. Yes my goal is to put this information into a database. If that means two separate excel files--- transaction list, and transaction details for each transaction then that is okay. I...

Hello- I have access to a web driven report site that has a list of transactions. Each transaction has a detail link associated with it. The site has a built in export to excel for the list of transactions....but not for the extra detail you can link to on each transaction. I need to pull...

This works great as long as the referenced workbooks are opened. Is there any way for the cell references to be assigned .xls files that are not currrently opened? I am aware of the links command in the edit menu. I'd like to be able to simply type a name of the file rather than drill through...

PVH - Works perfectly thanks! BobStubbs - Great robust example...nice to have something that is easily modified for other uses! Thanks for all of the help guys! I think I can put this one to bed now. :)

I would like to use something typed into a cell within excel to update other formulas within the spreadsheet. Basically I want to be able to update a group of formulas by changing a single cell. Is this assigning a variable or defining a name? This is probably really simple. I have one...

Would a simple redraw or refresh form command solve the problem?

I'm not sure of any DOS program that can directly open up Access files...but that doesn't mean it doesn't exist I'm using a DOS program now that was developed with Visual FoxPro. The data is stored in .DBF files. Access can link/create/edit these files with an ODBC driver found at Microsofts...

Not sure this solves your problem...would an IF statement that returns what you want if the field is NULL work?