MS Office document and image writer print driver Hello,
I have the opposite problem. I have users who have had the icon for the Office Document Image Writer deleted under Printers and Faxes. You mention above that it is easy to reinstall the virtual printer. Could you point me to the directions for reinstallation please
Thanks for your help. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

New to Visual Basic Hi Dear,
The simplest way to perform this task will be to save the each button value in a single string and whenever you want its integer or float representation cast it into the integer.
eg.
Code Snippet
Dim str As String
Dim Number As Integer
str = ""
str = str + "1" ' On Button 1 Press
str = str + "2" ' On Button 2 Press
'and when u want integer representation of the string cast the string into integer
Number = CInt (str)
Happy Programming! Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

CD Key/Part # trouble I have a similar kind of problem. I was organizing an action pack and I separated the sleeves that had cd keys on them from the cds that they went with. My question is, do the part numbers on the plastic sleeves, that came with the action pack binder, match up with part numbers that can be found on the cds. I just hope that there is an easier way to solve my problem than manually installing all of the cds and trying every cd key until they all match. That would take for ever and my boss would kill me. Help me, please!!! Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

OCS 2007-communicator 2007 advanced server settings and others greyed out.. gpo issue? I'm not sure what is going on here.. though perhaps i should.. on a machine with communicator 2005.. If i goto the same advanced section.. i see the ip address of my ocs server listed, along with tcp selected..
Now.. i've install OCS 2007, removed 2005, removed 2005 communicator.. installed 2007 communicator.. I also imported the new communicator.adm file.. and set things in there.. for whatever reason in 2007 communicator.. the advanced server settings are greyed out, consistent with a gpo override.. but the values are blank, not consistent with the new adm.. i'm not sure why.. it also wont let me browse to select a different folder for received files..
any thoughts on this one
Thanks in advance. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

How to automate a dialog? [The message filter indicated that the application is busy error.] Hello. When an automated Office application throws some dialog box, the server refuses any subsequent RPC call returning an error "The message filter indicated that the application is busy." Is there still any possibility to noninteractively press some button of the thrown dialog through the VBA (or by other means) to go on Thank you, P. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

this problem is also troubling me now!! :( Hi!
I have the same problem. My web page running on the same web server with WSS v3.0 beta2 and trying to use the WSS OM to retrieve some data from root site. But it fails with the message:
The Web Application at could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.
I worte simple console application. It runs Ok without any problems and failures. It seems that this problem is accuring only in web applications. I have hard coded IP on my computer and I've done all stuff, discribed in that MSDN article with mapping virtual server name to IP. It doesn't seem that problem with users rights and impersonation.
Does anybody knows how to fix it Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Current user Thank you Joao for the quick answer.
However, this is not the right one.
I should describe the situation in more detail:
Let's say the user 'N' had open the 'L:\SomeFolder\ABC.xls' file from the shared folder in his/her PC.
At the same time I want to save my 'C:\EFG.xls' file as 'L:\SomeFolder\ABC.xls' file.
I know the way how to find out if the 'L:\SomeFolder\ABC.xls' file is open.
Now I need to know BY WHOM the 'L:\SomeFolder\ABC.xls' file is open.
For example, If you will try to save any Excel file as the file that is open by 'someuserlanid' you will get the "File in Use" message.
That message will display the following information:
"ABC.xls is locked for editing
by 'someuserlanid'
Open 'Read-Only' or, click 'Notify' to open read-only and receive
notification when the document is no longer in use."
So, the words " by 'someuserlanid'" is a part of the message I think is created by some API call.
The only parameter that is available for me is the PATH to the file which I am trying to replace.
Thanks again, Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

email using CDO (Collaboration Data Objects)? Hey Andy
Thanks for your reply and the link, I found a solution to my question there!
I just wonder why it takes so long time before the recipient gets the mail. Is there anything to do to shorten this time
Cath Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

How do I find the next calendar day after a specified number of workdays? Hi there,
How do I find a calendar day a specified number of workdays from start date taking into account of holidays This is similar to the Workday function in Excel except I want it to return the next calendar day after a workday rather than the next workday after a workday.
Thanks in advance Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

VBA excel outlook / A program is trying to send mail using Item.Send cath, tks a lot! i bypassed the problem launching a vbscript just before to send the mail, which waits for the warning windows, waits 5 seconds, and "press" left + enter. i took the idea from the article http://www.itoc.usma.edu/Workshop/2001/Authors/Submitted_Abstracts/paperT1B1(24).pdf tks for ur help! Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Failure Using VxD loader Thanks to the other person that suggested that I phone Dell. I did and they walked me throught the following process (keep in mind that my memory is a little faulty). Unplug the computer from the internet, restart the computer, hit F8 many times while the computer is rebooting, choose 'repare computer', then choose the last option 'Restore from an image', the other steps are easy to follow. This will erase all of your data, and you will have to load all of your programs again, which took me 6 hours, but the problem was solved. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Counting words Thanks, I am using MS Word 2002. I am still trying to decipher the code you posted, but is seems that you can make use of the MS Word "Word Count" tool within a VBA procedure. This tool is invoked a different way than one would invoke a pre-defined VBA function. Is this correct
I would like to apply the MS Word "Word Count" tool to Selection (text highlighted by user) within a VBA procedure. Is this possible
PS - what are vbLf and vbInformation and why did you use them Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

iexplore.exe - Application Error I also get error message with my explorer.
It says "0x00139ae5" referenced memory at "0x00139ae5". The memory could not be "written".
It happened when I installed and used IE 7 beta.
Already getting frustrated with this. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

How can I print only items marked with Check boxes? Hi
If you have Access then this might be the best tool to use. You can update the elements of your BOM in a form which has your checkbox for completion. You can then use the reports / query functions / filters etc to only print he checked elements Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Validation with List drop down? I'm not sure if you get what i'm trying to do... I want it so that if 'No' is selected from the list the user is forced to input text into the column 'D'. Does this macro do this Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

FindNext returns "Nothing" when doing iterative lookups, though data to find is in the cells Hi,
thanks for your response. So it confirms that the logic of the code is correct.
I am using a system with VB 63. and XL 2003 SP2.
Knowing that the Search function of XL does work and find both occurences in this example, I would suspect a configuration issue. Any idea which obscure parameter could control the behavior - I have already tried all optional parameters from the Find Method
Damien Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Excel Time Help If you place this calculation in column F it will calculate the time difference between start time, Previous Cell in column D and finish time, Previous Cell in column E. Once you do this and have your group of 3 calculating cells that you can then copy and paste to any location on the spreadsheet and Excel will automatically adjust for the changed position. Times are entered as hours (24 hour clock) seperated by a decimal point for the minutes which should only be in 15 minute increments. (.00, .15, .30, .45) The diagram at the bottom shows the form that mine takes.
=IF((INT(E1)+(E1-INT(E1))*100/60)-(INT(D1)+(D1-INT(D1))*100/60)<0,(INT(E1)+(E1-INT(E1))*100/60)-(INT(D1)+(D1-INT(D1))*100/60)+24,(INT(E1)+(E1-INT(E1))*100/60)-(INT(D1)+(D1-INT(D1))*100/60))
23.00
6.00
7.00 Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Tabbing between text boxes To add to Peter's answer. In design mode you can right click on the userform and select Tab Order. This displays your controls in an ordered listbox. Changing the order within the listbox will change the tab index value of the controls. Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Scripts Object in Excel I want to know up to how much data/Scipt can be storted into Script in Excel This sentence returns ScriptText from script Object Sheet1.Scripts(1).ScriptText I want to know up to how much character It Can store Data Thnxs Viren Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

.mdmp files not being created Claus, thank you so much. I set the ForceQueue and now the minidump is saved! I really appreciate it. I had seen doc of the ForceQueue but did not think it had anything to do with whether minidumps were created.
Cheers,
David
http://www.dcsoft.com Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Combobox Userform Code Good Morning
I was hoping someone could perhaps assist I am really overlooking something I am currently creating a second userform (combobox) in my word document. (Reason i am using the user form is due to the fact that I have more than 25 items listed in my combo box.) I have A skills Selection part in my word doc
This Selction consist of a variety of 20 different fields to choose from The bookmark name Start Skill 1 Thru to 20
I then created a userfrom wich will have 20 comboboxes on it, To fill bookmarks 1 -20
I have used the following code to upon clicking on bookmark one open my userform
and then select from the comoboxes but i just dont get any information in my dropdown at all
A module to open the form
**********************************
Sub gocombobox()
SkillForm.Show
End Sub ***************************************
Code on Combobox 1 (Skill1) ******************************************** Private Sub CmdSkills1_Change() ActiveDocument.FormFields("Skill1").Result = CmdSkills1.Value End Sub Private Sub SkillForm_Initialize() CmdSkills1.ColumnCount = 1 CmdSkills1.List() = Array("Eod", "Eod2", "etc", "etc1") End Sub Private Sub CmdCloseSF_Click() Unload Me End Sub ************************************ This code is exactly the same (except for names) as my first user form to open another individual combobox, and it works perfectly fine. Is there maybe something i am not putting in due to the fact that i am maybe repeating something,
I would really appreciate any assitance or advise Kind regards Natural
(I am using Word 2003) Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out

Listing of files in intranet with VBA Hello there
Up to now we have all our templates (xlt, dot, pot) in a standard folder on a server. The access is via a suite of macros which incorporate a search function for a document. (sample: docis = Dir("P:\templates\*expenses*.*").
The templates will now be transferred to our intranet. Now my problem is to implement the search function for templates on the server, that is something like docis = Dir ("http://templates/*expenses*.*").
The code should run in Excel, Word and Powerpoint 2003.
Any suggestions
regards Jurgen Tag: Excel CheckBox - Enabled "False" but I don't want it grayed out