Microsoft ISV

Page 103




  • Topics
    Replies
    Last post
  • Code to save Office 2007 Word or Powerpoint as Office 2003
    by jchau
    1 Replies
    Last post by Andy Pope
      • How can I use vba to save Office 2007 Word or Powerpoint as Office 2003 counterparts
  • ComboBox listing on Startup
    by Philsophaie
    8 Replies
    Last post by Philsophaie
      • The ComboBox1 doesn't initialize the list automatically. It only puts up a blank ComboBox . Here is the code I am using: Private Sub Form1_Load() ComboBox1.Items.Add ("Open App1") ComboBox1.Items.Add ("Open App2") ComboBox1.Items.Add ("Open App3") ComboBox1.Items.Add ("Open App4") End Sub
  • Creating new table in Access 2003
    by Tantani
    2 Replies
    Last post by Tantani
      • Dear, I would like to pick up few rows from existing table in Access 2003 and put them into new table via VBA. Any solution Thank you in advance!
  • VBA call to managed C++ dll
    by TU71
    0 Replies
    Last post by TU71
      • I am trying to call into managed C++ dll passing the ActiveWorkbook property of the Application object as a parameter. I am receiving the following excpetion: System.InvalidCastException was unhandled Message: Unable to cast object of type 'System.__ComObject' to type 'Microsoft.Office.Tools.Excel.Workbook'. My C++ function is defined as follows: void __clrcall ConnectToDatabase(Mi
  • Check if an Excel workbook is opened and in use by somebody else
    by Perwel
    3 Replies
    Last post by Andy Pope
      • Hi, I need to check if a workbook is opened and in use by someone else. workbooks.open does not return a trappable error
  • this problem is also troubling me now!! :(
    by Moim Hossain
    14 Replies
    Last post by WebDev2000
      • Hello everybody, I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int
  • Compatibility Issue Excel 2000 and Excel 2003
    by rcash864
    11 Replies
    Last post by Jon Peltier
      • I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I liv
  • Move sheet to end
    by J&#248
    1 Replies
    Last post by Andy Pope
      • What command do I use to move a sheet so that it comes last
  • Implementing time synchronization through VBA
    by mnptl
    1 Replies
    Last post by mnptl
      • I am developing a small application that needs to include an audit trail function, with date and time stamping. To ensure that the time stamp is valid, I would like to either (1) force the local machine to synchronize with an external, trusted site (such as time-a.nist.gov), or (2) go and grab the time directly from an external, trusted site. How on earth can I do this with VBA S
  • 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.
  • 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.
  • In VBA, putting formula on spreadsheet
    by KenCubs
    1 Replies
    Last post by Ben McBen
      • I have a VBA variable, x, whose value is the address I want to put in an Excel spreadsheet formula. Does anyone know how to do this Thanks, Ken
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • Quit excel
    by une
    2 Replies
    Last post by magicalclick
      • I have a Sub in which there is an If statement. If a certain condition is found to be false in this If statement, I want Excel to display a message and then have Excel close down immediately. Here is the code; If validName = False Then MsgBox ("Sorry, I do not know you. Please complete a voucher manually.") Application.DisplayAlerts = False Application.Quit MsgBox ("Test for
  • Question about VBA and Office 2007
    by loganscott2000
    5 Replies
    Last post by magicalclick
      • Hey, everyone. We have several (dozen!) Word template files that contain a LOT of VBA code. We are evaluating the benefits/risks of converting these docs to Office 2007. That said, my questions are: 1. Are there any known issues with converting them to 2007 Specifically, if I just open the file (and convert it) to 2007, is my code going to *** out on me 2. Do I have to convert (or
  • Projects, objects & modules
    by une
    14 Replies
    Last post by une
      • I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named
  • Vba Excel - Get Workbook Author
    by ajliaks
    3 Replies
    Last post by Shasur
      • Hi guys, The code below makes an excel spreadsheet wich retrieves the names and details of the files contained into a specific folder. Does anyone knows how to get name (author) of the file Thanks in advance, Aldo. Function GetListOfFilesInspecifiedFolder() Dim oFSO As Object, Folder As Object, File As Object Set oFSO = CreateObject("Scripting.FileSystemObject"
  • setting up pet shop 4.0
    by swawin
    1 Replies
    Last post by Nathan Anderson - MSFT
      • Hi I am a .NET newbie here. I have downloaded petshhop 4.0 from MSDN. How can I get it working please I want to take a look at how the application works My machine is win2k3 with SQL 2005, VS2005 and framework 2.0. I realised that if I use 3.0, it will work straight away but it only works with SQL 2k. I would like to try with SQL 2005, hence I am looking at 4.0. Do I have to rebuild to see the
  • Word: Normal.dot template menu bar
    by amc
    9 Replies
    Last post by jason7005
      • I have programmatically modified the Normal.dot menubar (adding more dummy options), and I want to get rid of all of them, permanently, to return to the original state and appearance of Normal. dot.... How can I achieve that, please thanks
  • asynchronous communications
    by elephantwalker
    1 Replies
    Last post by elephantwalker
      • Group, I need to be able to have a top level gui in excel make calls asynchronously to another excel where I am doing my modeling. During this calls, I need to keep the gui alive and well for interaction. I can't find much info on this. I am an experienced multi-thread programer in C++ and Java, but I need to do this in VBA. Can you point me to some examples in Visual Basic for Appli
  • DBGrid not working in VBA
    by JorgeFF
    2 Replies
    Last post by LuiggiMallorca
      • I'm working on a machine with Windows XP SP2 and MS Word 2003 SP 2. There's NO Visual Basic installed. I open Word, then VBA, open a form, and try to create a DBGrid control. I get a Microsoft Visual Basic error message (in Spanish): "No se puede crear el control porque carece de la licencia adecuada." In English, it's something like: "Cannot create the control because you do not ha
  • 2005 Analysis Services Cubes - KPIs
    by goonfro
    1 Replies
    Last post by MS ISV Buddy Team
      • I'm new to using Analysis Services, and am having trouble creating a simple cube and associated KPIs. My date source view is very simple...an ID (primary key) field, a sales type column, a projection column, and a sales column. I want to set up KPIs to show a projection and sales comparison for each sales type field. I am currently only able to set up the KPI to show the totals for all projections
  • Exception Occured
    by CN1973
    3 Replies
    Last post by CN1973
      • Can someone please help me with an error that keeps coming up on my computer. Details are: Line : 180 Error: Settings Closed is undefined An exception occured. Address is 00413E6C Runtime error occured in script. No debuggers registered. Unable to jit debug. Thanks Chris
  • Setting Chart Title through VBA sometimes works sometimes doesn't.
    by Derek Smyth
    11 Replies
    Last post by Jon Peltier
      • Hello folks, Wonder if anyone has the solution to the following problem. Got an Excel addin that the user can use to generate Charts. The users are very lazy and want the addin to set the titles for the chart as well as for the axis. When I tested the code everything works fine and the charts including it's titles are set. Everyone is happy. However in certain spreadsheets the code throws
  • Outlook macro for subject modification
    by blackmamba
    3 Replies
    Last post by blackmamba
      • Hey guys, Do you know how can i make a macro to change the subject for each mail i send. It helps others to create rules based on the subject. Basically i need to take the existing string in the subject and add some text like "funny:" before. This may be easy but I only made excel macros so far. How do i store the macro What if i close the outlook, can i use add-ins like in excel Thanks