Microsoft ISV

Page 212




  • Topics
    Replies
    Last post
  • wlanapi.dll
    by petrov98
    0 Replies
    Last post by petrov98
  • Calling a function from a DLL
    by Douglas Penna
    6 Replies
    Last post by Mezhick
      • Hello there, I wrote a DLL in C++, and I'm trying to use it in Excel. When calling the the function, I used the code, at the begginning of the module: Option Explicit Public Declare Function preco _ Lib "OpcAmericanaDll.dll" _ (ByVal Spot As Double, ByVal strike As Double, ByVal Ks_fixados As Double, ByVal t_dos_strikes As Double, ByVal t_final As Double, ByVal t_inicial As
  • VBA EXCEL: How do I subtract two cell values
    by UH60
    2 Replies
    Last post by magicalclick
      • I want to subtract value in A1 from A2 in VBA. This is what I thought, but it doesn't work Val (Range("A1").Value) - Val(Range("A2").Value) I hope someone can help Thanks
  • Error 216 at 0001D61B
    by Dale Tonge
    2 Replies
    Last post by Cringing Dragon
      • I have a terminal server which has many software packages installed. All of the software packages work fine when you are sat infront of the server. However i have a problem with one application when i am connecting to the terminal server via microsofts remote access tool. What happens is when i try to connect via remote access and try and run the application they gat an error Error 2
  • Failure Using VxD loader
    by Thisorthat
    6 Replies
    Last post by lumpy55
      • I am using Vista Premium on a brand new Dell computer and I ran the Reliability and Performance Monitor. The following messages appeared: A device has a configuration problem that prevents it from working properly. The device, Microsoft Tun Miniport Adaptor, is reporting "tv_ConfigMgrErr19". This device will not be available untill the issue is resolved. The Plug and Play ID for t
  • MS Office document and image writer print driver
    by GTH
    14 Replies
    Last post by Mary3480
      • Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to
  • error 1004 - unable to get insert property of the pictures class
    by suznal
    2 Replies
    Last post by suznal
      • I have some code that works behind a command button to insert a selected image file into a cell on a worksheet. If the user clicks the 'Cancel' button on the 'getfilenamesaveas' window an error message displays... "Error 1004 - Unable to get Insert Propeerty of the Pictures Class" Am I missing something in the code (see below) Private Sub CommandButton1_Click() Range("A
  • How do we close all background threads in an application
    by Amit Kumar Garg
    0 Replies
    Last post by Amit Kumar Garg
      • Hi, I have an C# windows application. I want to abort all background threads when i click 'abort' button. Is there a way that i find all the active threads in the application and abort them when i want. Thanks amit
  • I need to take two strings from two different cells and combine them into one cell
    by JGttttt
    1 Replies
    Last post by Andy Pope
      • I need two take two separate strings and join them into one string in excel. I preferably want to dump the combination string into a separate cell. What code or method will I need to accomplish this in VBA Excel I need to combine them into multiple rows within one column. Taking rows one through 30 within columns one and two and outputting the two strings from those two columns into rows 1 through
  • Looping the Find Function using VBA
    by maverick_abhi
    1 Replies
    Last post by Andy Pope
      • Hello, I am in a tricky situation. I have two sheets. I want look for each cell in a range of cells in Sheet1(The no of cells may vary each time) in Sheet2. The cells are spread across in Sheet2 and may be followed by comments, "/" and etc. So using Vlookup is ruled out. So am trying to use the find function. If the cell is found in sheet2 I want to be able to probably change the backgro
  • Excel TextBox - do not print if empty
    by suznal
    1 Replies
    Last post by MyLady
      • I have a TextBox on a worksheet that does not always contain data. What I would like to do is insert some code that would set print to false if the box does not contain any data, but would be true once a user enters some text. Can someone help this newbie out
  • 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
  • Importing Flat file into Excel Spreadsheet
    by Peck Chun Hua
    2 Replies
    Last post by Mezhick
      • Is there a way to transfer a flat file into Excel Spreadsheet using VBA codes Example of flat file is: mmccccc aaaaaaaaaabbb zz4444444 4 44444444444 For 1st line mm goes to cell a1 For 1st line ccccc goes to cell b1 Fore 1st line aaaaaaaa goes to cell c1 For 1st line bbb goes to cell d1 For 2nd line zz goes to a2 For 2nd line 4444444 goes to b2 For 2nd
  • Can't remember the purpose of these lines of code in my project?
    by Scott Boyd
    2 Replies
    Last post by Scott Boyd
      • Hi, I just can't remember what the following lines of code are here for! Please put me out of my misery... Code Snippet Private glb_count As Integer Public Property Get GlobalCount() As Variant GlobalCount = glb_count End Property Public Property Let GlobalCount(ByVal vNewValue As Variant) glb_count = vNewValue End Property
  • Accidentally hid the VBA IDE menu...
    by AnonymousRD
    1 Replies
    Last post by Andy Pope
      • And now I can't get it back. Can't find anything in the local help with a keyboard shortcut to bring it back. Help! -RD
  • Out of Memory
    by James Simm
    4 Replies
    Last post by Jamie Bates
      • Hi there, I'm working with an Excel application, and I've written a .Net C# wrapper to it, to allow me to interact with an Oracle DB. Whenever I run the following code, I get the error "Out of Memory": Code Snippet Public Function Create(ByVal marketID As Long, ByVal ws As Worksheet) as Boolean Dim colDetails As Collection Dim xlName As Excel.Name Dim iRow%, iRow1% Dim iCol%
  • sending emails from MS Word with variable subject line
    by gve2002
    9 Replies
    Last post by Andy_F
      • Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code (    .Subject = "New subject"   ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
  • Subscript out of range with a simple sql :-( [newbie to VBA]
    by Maximus
    14 Replies
    Last post by Andy Pope
      • Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers! Code Snippet Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
  • VBA Skipping over code
    by JarodJohnson
    0 Replies
    Last post by JarodJohnson
      • I'm running some VBA code that takes data from an Excel spreadsheet, and populates that data in another Excel spreadsheet that's been formatted, then prints the formatted spreadsheet to a PDF document. Recently, I noticed that some of my code was being skipped over. I have been running this macro quarterly for a year and a half, and haven't had this issue before. However, when I put break points
  • Empower to certified looking for assistance
    by Voast Dev
    1 Replies
    Last post by MS ISV Buddy Team
      • I enrolled in the empower program, and used those tools to get an application tested and ceritified. My company is now a certified partner and I need some assistance with developing a POS application. In the partner portal I am having difficulty locating this assistance. A lot of links talk about empower and how I should re-enroll. How can it be that the empower program, which has a two year max,
  • Comparing two word documents
    by SurajJaldu
    4 Replies
    Last post by kannaiah
      • Hi All, I have to compare the text of two word documents using VBA. These word documents contain images and tables also. But I just wanted to compare the text. Can anybody please let me know how to do this Thanks, Suraj
  • Can you use VBA to access a spread sheet embedded in a word doc?
    by Trisped
    13 Replies
    Last post by Trisped
      • I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
  • Variable - VBA Excel
    by VBAuser
    2 Replies
    Last post by VBAuser
      • Hello! I have something like that: Sub teste() Dim count As Integer count = 2 Rows("2:count").Select End Sub This is giving me an error: "Type mismatch" How can I pass a value throw a variable How can I fix this
  • Macro To Delete Spreadsheet Columns if no data in column
    by GB Allan
    8 Replies
    Last post by AussieJames
      • Hi, I need a routine that will go across and delete any columns in a spreadsheet that don't contain any data. The spreadsheet will always be from columns A:BB. There are column headings on row 1 going across. Thanks for your help - I very much appreciate this forum. It has helped me out greatly! Gary
  • Macro to delete entire row that contain a specified value in a chosen column
    by sree
    2 Replies
    Last post by sree
      • Hello, I need help to write a macro where i could delete the entire row if it contains "Financials" in column D. Is it possible to record a macro. or should i have VB programming skills. Thank you in advance Sree