Answer Questions

• Gaukulius After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. With SaveAsUi value...Can I determine if the SaveAs dialog is shown Can I get the file path Sorry, but this is my first project with VBA Thanks This tells you if the dialog will be ...Show All

• zomi_ds passing data from a form to a module

  I have the following module Option Explicit Public Currency_Sold As String Sub AutoShape1_Click() UserForm1.Show Cells(10, 11) = Currency_Sold End Sub In UserForm1 I have Public Sub OK_Click() Currency_Sold = Currency_Sold_Code.Value MsgBox (Currency_Sold) Unload Me End Sub When I clik on the AutoShape1 button in the spreadsheet I do get the correct value of Currency_Sold in the MsgBox, but it i ...Show All

• kishore_golla About Jet WorkSpace

  Started by ranero at 05-13-2005 9:47 AM. Topic has 0 replies. 05-13-2005, 9:47 AM ranero Joined on 05-13-2005 Posts 1 About Jet WorkSpace I am new to VBA. I am trying to Clone a table and I need the Jet WorkSpace but I don't know wich Library I have to load for have it available. I try a lot of them but it doesn't work. Does anybody know thanks F ...Show All

• binuka SQL Server 2005 Resourse Kit exception

  Hi, When i try to view any of the webcasts by clicking "play", i get the following Visual Studio just in time debugger error: An unhandled win32 exception occured in iexplore.exe[4624]. I can also see the following error in the winnt application error log. I am running winxp with sp2. Event Type: Error Event Source: Application Hang Event Category: (101) Event ID: 1002 Date:  25/08/2005 Time:  7:08:50 ...Show All

• pcboy VBA How to cope with unicode strings

  Hi, I've done an example of what I met when trying to pass Russian character to a string or to a message box. I expect the message box contains "abcde" in Cyrillic alphabet but the result of that are just fancy characters instead. Any help I also changed the regional and language system setting but nothing changed. Many Thanks ********************************* Sub test() Dim strRuss2 As Variant Dim strRuss3 As String ...Show All

• sriesch Problem with Microsoft CRM 3.0 Outlook Client

  Hi, I’m having a problem with my MSCRM 3.0. When I install the Outlook Desktop Client, on my computer, everytime I that I log on to the CRM application (on my web browser), the SETTINGS folder is no longer available. If I unnistall the Desktop Outlook Client, when I log on to the application trough the web browser, the SETTINGS folder shows up gain. How can I solve this problem I need them both working. Thanks, Hi, ...Show All

• MSDN Sealevel User-defined Excel Input Thoughts?

  Well all, I've got a problem with an excel macro.  I have two seperate data sets that are recorded into basic worksheets on excel. However, I need the text in the first row of cells changed to a user defined name, and I need a description or units for that name in the cell below it. It would be helpful if the user didn't have to change this data in the code itself each time different data is recorded. For ex: Have a list whe ...Show All

• sgopus my buddy

  I love the buddy program. I think it is a great idea. I love microsoft products, and with the help of my buddy, I am learning more about my microsoft software. I have one problem. Even though I have tryed and she has tryed, I can't get her to show up on my instant messenger list, so I can talk to her in my messenger. We are still working on that one. But, my buddie is perfect for me. When I have a question, she is very help ...Show All

• Eddie Deyo Trouble creating an Add-in for Excel with vb.net

  I am using VB.net 2003, and I am trying to make a COM object that makes some classes and methods available in Excel (2000). Right now I don't intend for any of them to be GUI driven. Based on the KB articles http://support.microsoft.com/default.aspx scid=kb;EN-US;q302896 and http://support.microsoft.com/default.aspx scid=kb;en-us;256624 , I wrote the code below in VB.net: Imports Microsoft.Office.Core imports Extensibility ...Show All

• YOUR-Mark How do I avoid multiple instances of Excel

  Hi We're running Office Professional 2003. I've written a quotation system in VBA with an Excel user interface. Each quotation is a separate workbook. The pricing information is also in other workbooks. The application creates its own commandbar that enables users to easily transfer data from the pricing workbooks to the quotation workbooks. All this works fine as long as all the workbooks are under one instance of Excel. However, the q ...Show All

• redshock Questions on ISV's and regarding end users

  1) Are there different types of ISV programs If so, what are the differences between the programs   2) How does the Royalty program differ from other ISV programs 3) Does each program offer different benefits to the end customer   4) How does the Royalty program differ from other ISV programs to the end customer     5) Does Microsoft have a brochure or a list of the benefits for the end c ...Show All

• MarkBeau Scroll Events of mouse

  Hi,  i am imtiyaz thange. i am working on excel vba, i have used the combo control of vb on excel application, when the combo conrol is activated during the runtime and when i scroll the mouse the combo control also scrolls, i want that only the combo contents only to be scrolled and not the page to be scrolled when the control is activated Here's the response from one of our support engineers: I repro t ...Show All

• Ignus Embed fonts

  We have created a logo for our Company using Goudy fonts. The problem is that most computers do not have this font. Is there some way to embed these fonts into the document so they can be e-mailed with the document. Or is there another way to pull a text box with Goudy fonts into a document where it will be not changed if pulled onto a computer without the Goudy font Any suggestions are appreciated. LV Brenda ...Show All

• Aaron Engel Open an excel file

  Hope you will help a beginner .. Here's what I want to do:  In a VBA subroutine, try to open an excel file with a particular name say, P01GAB.xls.  It may not be in the diretory, if not, wait for 10 seconds and try again.  If so, open it and go on to the next thing.  (Eventually, it will be in the directory...)  So, I take it, I need some sort of error trap on the Workbooks.Open command... Thanks much.   ...Show All

• Veena Access and DWGs

  Hi, Is there anyway to display DWG files in MS Access I can get it to show DWFs. Thanks Lewis Per one of our support engineers: Can I know how you display DWFs As I know, DWG is an AutoCAD file type, which is a file type generated by third-party manufacturers (which is out of Microsoft control). Therefore, the built-in controls, e.g. Image control, Bound Object Frame, etc.. cannot render it correctly.   To display DWG file ...Show All