Microsoft ISV

Page 135




  • Topics
    Replies
    Last post
  • How to read the value of a non-linked to a cell control from an Excel Sheet?
    by av197
    5 Replies
    Last post by av197
      • I am building a Visual Basic program that has to read an Excel SpreadSheet and get the values of unprotected cells as well as the values of any control (placed anywhere from the spreadsheet creator), use them somewhere else and vice versa, i.e. open a preconstructed Excel spreadsheet and place values in cells but also in the controls. I've found more than one ways to read and modify the cells. I'v
  • Two column's types on one excel chart.
    by JoannaM
    2 Replies
    Last post by JoannaM
      • Hi all, I'd like to create one chart with two different types (xlColumnClustered and xlColumnStacked) of column. I'd like to present the information from charts below on one chart. http://img215.imageshack.us/img215/7103/pict1oe5.jpg Is there a way to achieve that Thanks Joanna.
  • How to copy combobox value to active cell in excel worksheet Automaticaly vba
    by abkarino
    5 Replies
    Last post by abkarino
      • Thanks for help . I Make a userform with combobox and make the row source but How do I get the highlight value from my combobox to active cell in excel worksheet automatically. Using Excel 2003. Pls.help me thanks
  • WinQual bucket ID meaning
    by YCY
    5 Replies
    Last post by B. Ward
      • How does the WinQual generate the bucket ID What's the meaning of the bucket ID Does it represent the stack info Could someone give me an example about this When there is a crash, what files (info) get send to WinQual I am new to the WER and WinQual.Thanks.
  • reading the data from a table and inserting into code
    by todd.k
    1 Replies
    Last post by SkiGeek
      • I'm writing in broad strokes because my knowledge is extremely limited. What I have is a table in Access with the field headings X, Y, and Z. I would like to take the string from field Y in the first record, bring it into VBA, and run my module. What my module will do is simply paste the string from my table into another application when needed. Then I would like this process repeated for
  • Beginner in VBA
    by VBNewby
    2 Replies
    Last post by VBNewby
      • I'm using a macro that runs before saving the workbook and allows the user to spell check each individual protected worksheet. How do I also allow the user to be able to format cells, format rows and insert rows while still doing what it is already doing Please see the code below that I am currently using...I can't figure out how to modify as stated above.... Private Sub Workbook_BeforeSav
  • Pasting Formula with ""
    by Joe Dawson
    2 Replies
    Last post by Joe Dawson
      • How can I paste a formula that contains "" For example, I get an error when I run the following: Sub Test() Range("c1") = "=IF(ISERROR(VLOOKUP(A1, $A$10:$B$20, 2, FALSE)), "", VLOOKUP(A1, $A$10:$B$20, 2, FALSE))" End Sub Thanks, Joe
  • Running VBA/Forms causing the workbook to corrupt on save.
    by Billvoorhees
    3 Replies
    Last post by Billvoorhees
      • Hello, I'm having a serious issue with an Excel application using VBA (class modules, forms, etc) on the MAC. The code works great on the PC and in fact works fine on the MAC until somebody saves their work. After saving, the workbook becomes corrupt and will only open on the PC. After I open the workbook on the PC and save it, I can open it again on the MAC. But the same pattern occurs w
  • WinAPI in Excel using VBA
    by Shuvro Basu
    2 Replies
    Last post by Shuvro Basu
      • Hello Everyone, I need to do the following and would appreciate help from any direction. 1) I would like to select a window (either hidden, child, parent or from the taskbar), 2) Get the window title 3) Save the title in a text box 4) Change the window title and send a mouse click to a specific button on the window if the button is present 5) Change the opacity of the
  • Searching / Hilighting OCR text in Office Document and Imaging
    by wajhi
    14 Replies
    Last post by Prathap
      • Hi, I have been given following Tasks using MS Document Imaging 11.0 API        Read TIF perform OCR on it        Show it in AxMODI.AxMiDocView    Searching / highlighting text in AxMODI.AxMiDocView using MODI.MiDocSearch class in TIFF file and Highlight search result i
  • Shell command not working on some computers?
    by Josh Lindenmuth
    1 Replies
    Last post by bi-lya
      • I feel like I'm losing my mind here. I have a simple subroutine in Excel 2003, and on some computers it works, on others it doesn't: Code Snippet Sub test() retval = Shell("c:\windows\notepad.exe", vbMaximizedFocus) MsgBox retval End Sub In particular, the computers at work do nothing (retval = 0 with no program launched), while other computers return the process ID and
  • Number formatting
    by Unbroken73
    3 Replies
    Last post by NickUk
      • Hello, I have a program that inserts data into Excel via a form made in VBA... Everything works great, however, it inserts the data as Text and i need it inserted as currency. I tried creating a variable as currency and setting the range needed to be currency, however that did not work. I also tried creating a macro, however, that did not work. Does anyone have any suggestions as to what code i ca
  • ExOleDB in Exchange Server 2007
    by Alexander Basyuk
    2 Replies
    Last post by Young Developer
      • I have developed an agent for Exchange Server. It use exoledb and event sinks for interacting with Exchange. For registration we use RegEvent.vbs (from Exchange Server 2007 SDK). It works fine on 2000/2003 versions. But on Exchange 2007 even RegEvent.vbs script doesn¡¯t work. It shows ¡° Error Opening Connection : 3706 Provider cannot be found. It may not be properly installed. ¡± I use
  • Some problem in CRM 3.0
    by tadriant
    3 Replies
    Last post by tadriant
      • Hello, I don't know if this is the right place to write, but i'm having an enoying problem. I'm trying to delete an invoice in CRM and i can't do this at all. Everytime i try to delete it, a window "Internet Explorer Script Error" pops up and the message is this: An error has occured in the script on this page. Line: 253 Char: 1 Error: Object doesn't support tis proporty
  • Adding groups as contacts in LCS
    by Pancamo
    1 Replies
    Last post by MS ISV Buddy Team
      • Hi A quick query regarding LCS.... Let's assume that I work in an organisation of 50 users, and I would like all 50 staff to be added as contacts on each other's Live Communicator. All 50 users are in the 'Company-All' security group/ distribution list (whichever is applicable). Instead of having each user manually add 49 other LCS accounts to enable communication with every single other
  • vlookup
    by Namrata Prashar
    14 Replies
    Last post by Namrata Prashar
      • Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata
  • Excel - CheckBox Tick Color
    by suznal
    4 Replies
    Last post by suznal
      • Is there a way to change the color of the tick mark in a checkbox without changing the default color of the box itself in VBA I want the default black checkbox, but when selected I want a red checkmark in the black box. I found that I could change the color of everything (box and checkmark) in the properties window of the checkbox, but it's not what I'm after. I also could not not find a proper
  • Assigning keyboard shortcut to VBA macro programmatically
    by Ad Brandt
    3 Replies
    Last post by Ad Brandt
      • Using OLE, I create an Excel sheet with graphs and some macros to manipulate them. I'd like to assign keyboard shotcuts to the macros, so that the user has easy access to them. I can't figure out - however - how to do that. Any suggestions Thanks in advance.
  • Does Winqual accept WER reports from Vista systems?
    by Claus Brod
    14 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
  • Unbound Calendar Control
    by Rob585721
    1 Replies
    Last post by ADG
      • Ok...I have read the Access Help on this topic and to make an unbound calendar control open in a form with the current date the help file says this: To do this Use this code Result Make the calendar display today's date. EndDateCalendar.Value = Date The calendar displays today's date; the current month and year will be selected in the combo boxes at the top of the
  • How to get Images from databsase into EXCEL
    by Ajaysandhir
    0 Replies
    Last post by Ajaysandhir
      • I need to get images stored in a sql server table and bring them to a cell in excel using VBA any help is appreciated, Pls cc reply t o asandhir@jny.com
  • ado recordset problem
    by leeshade
    2 Replies
    Last post by leeshade
      • i am using the following code and am getting the structure of customers structure returned to my application recordset rs - but there are no records being produced >>> what am i missing (the access table set is not empty) cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\lee\Northwind.mdb;Persist Security Info=False" cn.Open rs.Open "select * from cust
  • Future of VBA (and VBScript)?
    by fiatlux
    28 Replies
    Last post by fiatlux
      • We developped a number of tools in VBA or VBScript, sometimes using COM objects, and the large compatibility of VB, VBA and VBScript was certainly nice. We would no mind moving to .NET (the framework API being quite interesting), but it is not clear what is going to be the future for VBA and VBScript. Can we expect a VB.NET"A" and a VB.NET"Script"
  • gifs appear fuzzy in ie. zoom change doesn't help.
    by dylaphyte
    0 Replies
    Last post by dylaphyte
      • had this problem since i got comp in jan. gifs appear with rough edges on all web pages. tried different browser and everything apears fine. rest of comp everything appears fine. have latest drivers, etc. i think it's some setting on ie that's doing it. an ideas thanks!
  • Error message on startup of WindowsXP-SP2
    by allie922
    3 Replies
    Last post by Claus Brod
      • Every couple weeks when I startup my computer, I get a BLUE SCREEN with the error message in white text relating to the driver vsdatant.sys device driver. It also says something about physical memory dump and if I continuously get this message there could be a problem. But I just restart the computer and it startups up fine. I get error message that my computer has recovered from a serious error.