Search results for query: *

Check the virus software to see if they have been quarantined.

If you only have one spread sheet open this should work. Sub aTest() UserForm1.Show vbModeless AppActivate "Microsoft Excel" End Sub

TeeJayWA, I would talk to the service provider (I assume you have a PRI) and see if they are able/ willing to block calls from toll free area codes. The other option would be to route the calls to an answering machine connected to a 500 set line located in the basement somewhere.

How dumb of me. For some reason I thought TeeJayWA was talking about a cell phone. A few thoughts that will hopefully make sense. Toll free numbers (800, 866, 877) are incoming only. As manfmmd has stated, the caller ID number has been manipulated. There is no reason to believe that the number...

Have you answered the phone when that number called you? It might be useful to answer and inform them that it is a violation of Federal law for telemarketers to call cell phones using automatic dialing system.

The Set statement sets a reference to an object. In your case Set mydict sets a reference to firstdict. Whatever you change in 'mydict' will be changed in 'firstdict'.

I believe you can just dial the Call Pilot extension number to access the voice mail. I know for certain that will work at the local switch.

808user, See my post 16 Jan 07 19:56. Specifically the 3rd quote. The PrivNet ID for the switch with DN's starting with 5 should be 5, the switch with DN's starting with 2 should be 2. I am assuming that you are set up with 4 digit extensions. Also, the protocol on the PRI is SL-1.

I usually construct the path and file name as a string to allow flexability. sFileName = "personal.xls" sPath = "H:\personal\" & sFileName ActiveWorkbook.SaveAs Filename:= _ sPath, FileFormat _

Your limitation is going to be the lowest data rate. Keep in mind that the lowest rate is only an average. You also need to know if the provider supports QoS.

Since you were going to try different options we kind of need to know how you configured it.

We have a winner! Have a star macropod.

For the preceding Monday: =ROUND((TEXT(A1,"?"))/7,0)*7-5 For the following Monday =ROUND((TEXT(A1,"?"))/7,0)*7+2 Make sure you format the cell for dates.

Is that minimum the download speed?

NP Steve, I didn't read it that way.

Steve, I wasn't suggesting anything specific, they were just examples. I find it quite useful to distinguish what type a variable is declared as I don't have to scroll up to find out.

A quick check of file size for Access with no tables is 96kb, Excel with 3 pages is 16kb. Size alone is reason enough not to email a database. Avoid VBA code as some users will have security set to high.

DTI card is not an option on the CICS. You may however be able to use a couple of BRI cards.

Establish consistent conventions for declaration types. For example: CONSTANT – CAPITOL iSomeVariable – integer sSomeVariable – string