Search results for query: *

Hi, I would like to know how to get the print status for Excel? For word, the application object has "BackGroundPrintingStatus" property using which i am able to wait till the word document is printed. How do i do the same with Excel? Thanks in Advance. Veera.

Thank You Very much. I was under the assumption that when we say Sheets(1).select it will select the sheet named sheet1. Its working fine. Veera

Hi, ActiveSheet has properties to go to the next sheet or the previous sheet ActiveSheet.Previous.Select ActiveSheet.Next.Select Like this, is there any property to go to the First sheet or the last sheet. We want something like a navigation tool. Thanks Veera

Hi, I have a workbook which will be used in both office 2000 and XP. the workbook developed in 2000 and has a reference to Word 9.0 object library(MSWORD9.OLB). I add this reference automatically when the WB opens. But in office XP the Word object library version as changed and it shows an...

Hi, I would like to know how is Richtext Box Installed or available in a system. I am using a richtext box in an Excel form. When i try to open the Excel in a different machine it gives a Error. The reason being the version of Richtext (richtx32.ocx) is old. Both systems have the same versions...

Hi, I found out what was creating the problem. The version of the Richtext OCX control in the testing laptops/pc were of older version. I changed them and it worked fine. Also look into the article Q181854 in Microsoft Knowledge Base. This contains the fix for some Controll Installation...

Hi, I have an excel application which contains a form which has RichTextbox in it. I have created a Template from which Workbooks will be created for users. I have a situation where in the workbook works fine in all machines except one laptop. All the machines have the same configuration...

Hi, I am having an VBA application in which i am using Word objects to save documents and print from excel. I add the reference to MSWord9.OLB(2000) on workbook load. But when the same workbook is loaded on a 97 or an XP m/c it fails b'cos the .OLB file for the other versions of the OS r...

Hi , I am having an update statement with the value to be updated is obtained using a select stmt as shown below. UPDATE employee SET cmpny = (SELECT distinct cmpny FROM company_detail WHERE COUNTRY_NAME = 'Albania') WHERE COUNTRY_NAME = 'Albania' When i try to execute the stmt in Access i...

Thank You very much. The users will not be having VB installed on their systems. So i will just give them the forms with passwords set to prevent them from viewing the Codes and other sheets. Thanks Veera

Hi, I have a VBA application in Microsoft Excel. I would like to know how i can create a standalone executable from the excel application. Thanks Veera

Thanks for the reply. The DataObject can be used for copying and pasting only text data and not Images etc., This is my requirement. I have a richtext box which will contain data to be printed. While printing i should add logo's in the richtext and print. The logos r present as an Image...

Hi, I would like to know how i can get access to the Clipboard object. It is available in VB6. But i would like to know if it is available as separate dll or activex control which can be used instead of having VB installed on the system. I need the Clipboard to copy and paste images in a...

Hi, I am trying to insert an Image in richtextfile by using the loadfrom file method. But is it possible to load the image from a image control which contains the image. I found that it can be done by copying the image to the Clipboard and pasting into the richtext using the SendMessage API...

Hi, I found the answer. I will have to set the Locked property of the TextArea to be true so that the TextArea becomes non-editable but scrollable. Thanks Veera

Hi, I have a form which contains a scrollable TextArea. I am to disable the Textarea, but when i disable them i am not able to scroll. I would like to know how i can make a TextArea non-editable but should be able to Scroll so that user see the contents in the TextArea. The way i do now is i...

What i meant by screens is actually VBA Forms. I can change the title for the forms. Is it possible to add an Icon to the form along with the title? Thanks Veera

Hi, I would like to know whether it is possible to set an icon for the screens created in Excel using VBA. Thanks Veera

Thank You guys for your suggestions. Even though i set Options.PrintBackground = True, it still gave me the message when i try to quit. But i found an Application property called BackgroundPrintingStatus. Which returns the number of print jobs in the background printing queue for the...

Hi, I am opening a Rich Text document using a Word application to print. Once the document is called i open the PrintDialog and when the user selects the printer and clicks okay i close the Word Application. But when i close the word application i get the following message "Word is...