Microsoft ISV

Page 1




  • Topics
    Replies
    Last post
  • Why does (VBA Excel) Solver becomes slower when executed in a for next loop more than 1000X?
    by jenskkk
    0 Replies
    Last post by jenskkk
      • Problem: Solving problems becomes slower the more often I call the SolverOK function in a VBA Excel 2002 code. I am using the solver add in my program and I was wondering if that will use up a lot of memory and I want to make sure that I release the memory properly. The solver is called several 1000 times in this routine and it could possibly produce a big mess if it does release the memory cor
  • 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
  • What is the VBA code to insert an Object into an Excel File
    by amanda_m_wilson
    8 Replies
    Last post by amanda_m_wilson
      • Hi, I have recently been requested to create a button on an Excel spreadsheet that will insert an Object (usually a MS Word Document but not always) into the Spreadsheet as as Object. The user would need to browse for the document and select the file, then the file would attach and be displayed as an icon. In short, the smae as using the Insert > Object >Create From File (Display a
  • Excel VBA open/select text in Word?
    by sdbenner
    1 Replies
    Last post by Peter Mo.
      • I'm trying to use Excel VBA and open a word document and select a few fields of a table to paste into Excel. Is there a way to search for a certain string and copy the adjacent table fields in Word so I can assign them to a variable for pasting into Excel
  • Read data from excel through VB.NET
    by Prasanth.P.P
    12 Replies
    Last post by Srini111
      • Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim
  • Vba - Directories / Folder tree
    by ajliaks
    1 Replies
    Last post by João Rodrigues
      • Hi, Is there any way to show a directory / folder tree In order to move a file from "myFolder01" to "myFolder02" I need to let the user to select the folders myFolder01 and myFolder02. Thanks in advance, Aldo.
  • Null Value Error in recordset
    by Roborean
    2 Replies
    Last post by Roborean
      • I have encountered a problem when returning a record set which contains a Null value. Please can any one help I am trying to determine if a date field against a client is empty but if it is empty, when I try to get the value, I get an error message when it gets to dteDateCreated - "Invalid Use Of Null" Dim SQLText As String Dim rs As Recordset Dim strClientCode Dim
  • LCS 2005 SP1 Server-Side Contact Lists Not Populating within Communicator 2005
    by KCrockett
    1 Replies
    Last post by MS ISV Buddy Team
      • I am having trouble creating server-side contact lists for my employees using Communicator 2005. We have an LCS 2005 SP1 SE virtual test environment. All my users are LCS enabled (right-clicked on OU within AD to enable). Background knowledge... Contacts.txt looks like... msRTCSIP-PrimaryUserAddress sip:u ser1 @domain.local sip:u ser2 @domain.local sip:u ser3 @domain.local ACESFile l
  • run an exe file in excel using VB
    by mambo5
    5 Replies
    Last post by mambo5
      • Hi, I want to run an exe file in excel using VB, any simple coding for that Thanks.
  • Some questions about WER
    by Nikolai Bochkarev
    5 Replies
    Last post by Jason Hardester - MSFT
      • Hi! I'm integrated WER support in my Delphi 7 Application and now get some results 1) I'm register winqual account 2) Integrate WERAPI support in my application (Delphi program has own exception processing) 3) Map my .exe and upload xml file procedure TForm1.ApplicationEvents1Exception(Sender: TObject;E: Exception); var eventType : PWideChar; begin if
  • public variable between sheet code and userform
    by class11
    1 Replies
    Last post by Andy Pope
      • Hey, I created a public variable in sheet code and assigned a value to it. Now I want to be able to call a userform from the sheet code and use the value I established in the Userform code. Is there a way to do this
  • Help Deploying VBA changes across hundreds of Word Temlates
    by SiobhanO
    1 Replies
    Last post by Derek Smyth
      • I have been asked to "clean up" existing Word templates that have VBA code in them. Basically what I need to do is to remove the old code that is currently in the ThisDocument class module of the template and replace it with the new code. I've exported the "good" code to a .bas file and I have worked out how to import it back into the Word Template but the only problem I hav
  • A question from a beginner...
    by meisaka
    6 Replies
    Last post by meisaka
      • Hi all: I am new to the programming world, and I am interested in learning VBA. So, please provide some tips where should I start Thanks in advance.
  • About iexplorer 7 error.
    by Gilga.
    2 Replies
    Last post by MS ISV Buddy Team
      • "The instruction at 0x66869bc7 referenced memory at 0x00000050 . The memory could not be read." I keep getting this message whenever I close the internet explorer 7. Can anyone help me out on this matter
  • Excel Pivot Table
    by Vamsi025
    0 Replies
    Last post by Vamsi025
      • Hi, I am populating the Excel Pivot table from the sql OLAP cubes . I am having 2 items in the Data Field list and I dragged and droped those two in the pivot table and every thing is working fine .But the problem is when i am selecting two rows and asking to group by right clicking the Data field , It is grouping the rows but it is showing only one column insted of two and the 2nd column i
  • VBA Word Can't find project or library
    by Paulnz
    5 Replies
    Last post by Andy Pope
      • I have wrote a VBA macro and in the macro I use visual basic functions such as "RTRIM$( )" and "STR$( )". When running the macro on a client's computer the error "Compile error Can't find project or library" comes up and it stops at the "Rtrim$( )" function. What is missing on the client's computer. Please help Thanks Paul Seo
  • Excel: Public variable doesn't work
    by My_Head_Hurts
    2 Replies
    Last post by My_Head_Hurts
      • I have a routine that needs to sometimes display a form to get user input, then hand the result back to the caller. I use a Global variable to do this but the value is not returned. When I use Option Explicit, I get a run-time error, "Variable Not Defined" in the form. The code is like this: In the calling module... Code Snippet Public PsResult as String private sub Module
  • Inserting Comments in Excel...from a Beginner
    by sg549
    5 Replies
    Last post by Keithyboy1
      • Hello everyone. I'm new to VBA programming, but I have done a little. I have a new project at work that I'm trying to accomplish via VBA, but I'm not sure how to get it done. Thanks in advance for your feedback. My goal is to take data from a cell on Sheet2 of a workbook, and place that data in a comment field in the exact cell on Sheet1 in the same workbook (data in A10 on sheet 2 will be
  • Time Addition
    by MoPatel
    1 Replies
    Last post by sjoo
      • Hi all, I am facing such a horrible problem, i have tried everything and cannot find a way to solve it and it is now driving me insane. What i am trying to do is to calculate the amount of hours a member of staff has worked for the whole week, this is done through VBA on a userform and i just cannot do it. the main problem i am facing is how to add hour and minutes together to give me a val
  • Excel/Word VBA IDE - Additional Controls Dialog Box refuses to display
    by Herbert Schroder
    0 Replies
    Last post by Herbert Schroder
      • I have a problem trying to add additional controls to the Controls toolbox The two methods I've tried 1. Right click on the controls toolbox , click Additional controls 2. Menu, Tools, Additional controls Neither of the above produce a dialog box containing the list of additional controls to choose from. Things I have tried so far.... Office Update, Reinstalling Office 2000, uninsta
  • Excel Time Help
    by MoPatel
    6 Replies
    Last post by MoPatel
      • Hi all, This is my first time posting here , hope i will be able to find the answer i am looking for. I'm very new to vba so please bear with me. Here goes, this is the problem i'm having at the moment with my formulas and vba. I am currently desinging a roster for my workplace and the problem i am having is to work out the night shifts. these night shift start at 23:00:00 and end at 06:0
  • Excel import
    by Rod Wing
    3 Replies
    Last post by Rod Wing
      • I have a working Excel vba that imports about 50,000 cell values from a variety of different text files into numerous worksheets. The problem is it is painfully slow, taking over an hour to run. The main time killer is populating each individual cell using the format: Worksheet.Cells(row,col).Value = strValue Commenting out these lines of code the program runs in under a minute. I've
  • Use of InStr() function
    by une
    3 Replies
    Last post by Andy Pope
      • Can you use InStr() to determine the position of the next character in a string that is not equal to one of a number of options. If so, how For example, what would be the syntax of an expression that returned the position of the next character that was not either a "t", space, tab or return character Would you have to use ascii representations of some or all of these characters in th
  • iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
    by sapphireoceans
    14 Replies
    Last post by Jillytodd
      • Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
  • Importing excel spreadsheets over time into Access using a module in Access
    by Nakli
    1 Replies
    Last post by Bruno Yu - MSFT
      • Hi, I am trying to create an access database that will allow to import excel spreadsheets at the click of the button on a switchboard. I have been trying for hours to create a module in access that will import excel spreadsheets that contains a table with 12 columns and a different amount of rows for each spreadsheet. I was able to create an almost complete macro in excel that