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.

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 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...

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

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 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...

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

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...

Hi, I am using ADO and DAO objects in my Excel Application. To use them i add the references "msado21.tlb" for ADO from c:\Program Files\Common Files\System\ado\ directory and "dao360.dll" for DAO from c:\Program Files\Common Files\Microsoft Shared\DAO\ directory. I...

Hi, I would like to know how i can get the current directory from where an Excel Application is Executed (Excel File location). The "CurDir" function returns the current working directory set, which could be other than the location where the file is. But i would like to know where...

Hi, I would like to know how i can Change the Thousands Separator for Numerics in VBA. The application can be used in both Europe where it is "'" and other locations where it is ",". So i would like to make it standard across all locations...

Hi, I am Lotus Domino objects to send mail from VBA thru' Notes. I am successfull in sending mails if i have a Lotus Client installed on my local machine. Is it possible to open a Lotus Session in a different machine which is accessible from the m/c where the VBA application is executed...

Hi, I would like to know if there is any in-built API in Excel/Access to zip a file. Currently i use the Shell API to open a Winzip session and zip the file. This requires manual intervention. I would like to know if it is possible zip the file programatically. Thanks Veera

Hi, I would like to know how i can prevent MS Access (2K) from saving auotmatically when user closes the DB. What i need is that, Access should ask user confirmation before Saving the DB. Thanks Veera

Hi, I would like to know how we use Lotus Notes Server to send mails from Excel or Access. Thanks Veera