Search results for query: *

that did not work: here is what I am working with: Private Sub Workbook_BeforeClose(Cancel As Boolean) If ActiveWorkbook.Saved = True Then With ThisWorkbook .HasRoutingSlip = True With .RoutingSlip .Delivery = xlOneAfterAnother .Recipients =...

Geff and all! How do you check if a workbook has been changed/updated. I am writing a procedure, but it's based on whether the workbook has been changed or not....I just can not seem to get that if condition statement right...any idea! thanx

Well- i guess a router it is! btw, the win 2k is always on...does that change anything? i did not think so! so it was easier with win 98 and tel modem? that sucks.... thanx all!!

James- actually one pc is working fine..it's the other one that's killing me. this should be simple, but somehow it got screwed up. i plug both pcs to the hub and the bub to the modem. both lite are on on the hub and the nic...so there is a connection somewhere. but not the internet!

i got the hub installed. I installed the hub modem software on both pcs already. the network was working fine when i had win 98...so was i able to share the internal modem on the main pc. now i have 2000 and a cable modem and it went crazy.

Hi, Can anybody help with this. I need to share my modem with two pcs on my network...one using win 2k (the main Pc) the other (win ME). I do have a nic installed on both....but nothing seems to work. I also need to be able to see both PC on the lan! Help!

Hey Geoff - it did not work for me. where i would write this function? the goal is to populate a msgbox that tells me who was the last person to have modified that workbook! THe function below did not work for me either: Sub ShowFileAccessInfo(filespec) Dim fs, f, s Set fs =...

I would go with joegz' suggestion. but make sure you know what your domain name is before you change the password setting.....

This is a good one: How do you use VB to capture a "username" that can be used in an excell worksheet via a messagebox or when opening a spreadsheet? Any one???!!!Ferris...Any body!!?? Thanx

Geoff- thanx....it was fun! stay tuned for my next topic...(username)! Frantz

Thanx Peter! Geoff-your logic is my dilema. I was shooting for more basic or standarg function without regard to race creed or sex...you know the basic holidays....I guess the problem is : basic can be interpreted in so many ways by so many people! Oh well, can't have it all! Thanks man! ~Frantz

Hey Meintsi! I tried the that function...i was hoping for another option whereby I did not have to type the holidays and stuff like that! any suggestion! Thanx

Hi all! Does anyone knows how to use the date funtions in excell to calculate how many workday in any particular month by simply imputing the month: Example.....July has 22 workdays... Thanx

Can anybody else? I have tried almost everything but bying a new hard drive. Scandisk is fixing the whole drive because there is too many files. I got no response when I try to reformat the c drive....there is a partition with a funny label that i can not delete...i need to install window and...

I have a MS excell file that requires a password to open the file. Need to know how to remove and reset that feature. The file won't open without typing the password first! Help!!