I have a input box as follows:
Public ClientNumber As String
ClientNumber = Application.InputBox("Enter A/R Client
Number in 4 digits (ex: 0195): ")
What is the proper syntax to get the ClientNumber entered in the input box to work in a file name to be retrieved?
(the following will not...
WHEN I ENTER THE FOLLOWING IN CELL C1,
=IF(AND(A1>0,A1-B1,"")
THEN IN CELL C10 I ENTER
=C1*5.10, I GET #VALUE! RATHER THAN ZERO.
THE REASON I AM USING "" IN THE FORMULA IS I WANT C1 TO SHOW AS BLANK NOT WITH 0 (ZERO) AS 0 WOULD DO. BUT THE "" IN THE FORMULA CAUSES THE #VALUE!.
HOW CAN I GET...
How do you set a macro to run when a word document is word document is opened? The macro is only for that particular document.
I know how in excell, I merely name the macro auto_open. Doing so is not working in MS Word.
Mike
mikeburg@gower.net
How do you e-mail a .pdf document as the e-mail message itself instead of as a .pdf attachment?
In other words, when the receiver opens the e-mail, they see the document as the message rather than having to open an attachement which requires Adobe Reader to open it.
New to Adobe Acrobat.
Mike...
Is there a way to set a network drive so it shows as merely a local drive letter rather than as Network Drive c$ on'server2001'(z:)?
mikeburg@gower.net
My computer has Windows 2000 Professional. I have it set to where "Users must enter a user name and password to use this computer".
When another user logs on they have their own desktop.
How do I prevent other users from being able to use the internet from my computer?
I tried...
I am having trouble creating a macro for MSWord to fax a document using control + F.
I do use application.sendfax in the macro, but I have to click thru a series of screens. I need it more automated where after control + F, it will prompt for the fax number. After entering the fax number, I...
I am needing a business contact mailing list data entry program written in ActiveX Data Objects (ADO).
The access data base fields are:
PHONE (primary key)
BUS_NAME
OWNER_MGR
ADDRESS
CITY_STATE
ZIP_CD
CATEG (category code)
UPDA (update code)
CNTC (contact code)
PHONE_2
PHONE_3...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.