Microsoft ISV

Page 64




  • Topics
    Replies
    Last post
  • VBA Merge question
    by Janfry
    3 Replies
    Last post by Peter Mo.
      • Hi (my English is not very good but i'll try it). When I link the datasource to the document, appears a dialog to select the text encoding. The Document.Open method has a parameter to specify the Encoding, but MailMerge.OpenDataSource does not include it. Is there any way to not appear that dialog Thanks, Janfry
  • some mp3 play some others don't
    by moisesvallejos
    5 Replies
    Last post by moisesvallejos
      • I have a powerpoint presentation and inserting an mp3 files to play across the slide, but for some reason my mp3 file would not play at all. that mp3 was created by a windos media player and will not play in powerpoint at all, but play just fine in my windows media player. if I create the file with soundforge then that mp3 will play fine in powerpoint. can anybody tell me, what I'm doing wrong
  • Live Communications Server Archive service "Retrieving data failed" om Status tab in console
    by Jenny L
    0 Replies
    Last post by Jenny L
      • We have deployed Standard Edition LCS 2005 for client with Archive service enabled and installed on a separate server. It's been working fine from day 1 and l just noticed it within recent few days that in management console, under Archiving Services folder, when I expand the archive server, it shows "Retrieving data failed" for archiving service (SQL instance, Database name and Message
  • Inserting Object in Excel using VB
    by Lance Clark
    1 Replies
    Last post by Shasur
      • I have a command button within a userform I am developing, which will automatically take the user to the Excel Insert Object function Private Sub CommandButton2_Click() Application.Dialogs(xlDialogInsertObject).Show End Sub What I need to understand is how, using VB script, once the user has selected the file and clicks on OK within the Insert Object function, that the selected file
  • Insert Into Oracle Table from Excel
    by Naveen24
    1 Replies
    Last post by Luiz Claudio - MVP
      • Hi All, I am trying to write VBA code in Excel to insert Data from Excel Rows(4 columns) into Oracle10g database using OO4O. I Have created ODBC connection I am able to get connection, however i am not able to make a successful insert into Table when i hit a save button... The following is the code i have written...if any one can input where i am doing wrong then it would be great... I am tryin
  • Event Procedure
    by Access Keen User
    4 Replies
    Last post by Access Keen User
      • I want to set [Event Procedure] as I have set so many Event but one of my form, shows me following message. Code is simple DoCmd.OpenForm"My Form Name" Where is the fault, if some one help me. The expression On Click you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure ha
  • Dynamically add controls with events at runtime
    by LSF
    6 Replies
    Last post by Anonymous3461
      • Hello, I want to add new buttons to an existing userform at runtime and link event handler to them so that the buttons do something. I've tried several ways that I've found online and managed to create the button and to programmatically add the code for the click event but when i click the button nothing happens. The button and click event sub code is created fine. I have adde
  • How to delete a connection?
    by gein
    5 Replies
    Last post by JohanBark
      • Hi, this is my first post here. I'm having some difficulties with Excel 2007. I'm creating Connections (URL based) on the fly in VBA. The code for that looks like this: fId = Trim(Str(Target.Value)) Set QT = ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://here-the-address-to-the-location/ id=" & fId _ , Destination:=Target.Offset(-1, 2))
  • How to check if contacts are already in outlook public folder and disregard
    by RhysDavies
    2 Replies
    Last post by Cringing Dragon
      • Hi i posted this code previously - it imports contacts from an accessquery into an exchange public folder for people to use - i import the unique contact ID from the access dbase into the job title field - i want to add code that will check the job title field against the ID in the query and if it is already there i do not want it to create a duplicate contact as it presently does, but i do want i
  • Vba Excel 2003 - Prompt Message Box with timer
    by ajliaks
    2 Replies
    Last post by ajliaks
      • Hi guys, I need to prompt a mesage box telling "XYZ" and automatically close it after 3 minutes. Thanks in advance for any help. Aldo.
  • Newline in TextBox
    by une
    3 Replies
    Last post by Andy Pope
      • I tried to put some text in a TextBox as follows; TextBox1.Text = "Text = " & vbNewLine & testtext However when executed this code diplays the symbol for a newLine character (reversed bold "P" like symbol) between the two strings rather than actually placing the second string on a new line. This method of adding new lines works in a MsgBox, why not in a Te
  • CRM 3.0 doesnĄ¯t save my settings
    by SisMng
    13 Replies
    Last post by MS ISV Buddy Team
      • Hi, IĄ¯m having another problem in CRM 3.0. When I change any setting in the CRM system, everytime that I clicked in the OK button it should save my new settings and thatĄ¯s not happening. How can I solve this Thanks,
  • troubleshooting saving versions with macro in Word
    by nin_a
    1 Replies
    Last post by Victor Bello - VBDOTNET
      • Hi, a while back I asked how I could save a version of the document automatically every 15mins. I managed to write a macro to do this and it worked for most documents. However, for some documents the versions were saved but when I open any of them they appear identical to the current document. Also, in a couple of cases I had this problem initially and then after a few attempts it sorted itself ou
  • Copying and Deleting the duplicate records in an excel sheet and Copying the same Deleted records into another sheet
    by bharat baradia
    4 Replies
    Last post by magicalclick
      • hi, i want to delete the duplicate rows in the excel sheet and copy the same deleted records into another excel sheet by using Macro's . This should be possible even when i am selecting two columns for checking duplicates and even if one of the column is repeated ( is duplicate) it should be considered as a duplicate.
  • API and OpenGL in VBA for Excel
    by Spinor
    7 Replies
    Last post by @sanya
      • How to use in VBA for Excel such API functions like, SetPixel, GetPixel, LineTo, PolyLine or ArcTo acting on the new created standard UserForm or in the special new window opened by appropriate API function. I know that it is trivial within VB applications, whereas VBA makes troubles (handle address of UserForm). I would be grateful for some simple examples (which have been tested and work well).
  • Locate variable in worksheet using with VBA
    by DKChua
    2 Replies
    Last post by DKChua
      • Hi, I need to locate if a variable at cell Sheet1!R5C6 exist in sheet2 or sheet3 and so on. Can anyone help with a valid VBA code that can perform this function DK
  • Round a Value to Specified Number
    by Tantani
    2 Replies
    Last post by Tantani
      • Hello Guys, I am working in Access VBA 2003. And now I am working on Recordsets. I have a table named "Book" and within this table I have the attribute named "Quantity". The quantities of the books are defined in fraction numbers and I would to convert them to integer. I would like to defind a method to check and do the following thing: If i = 0.01 To 0.99 Then i = 0 OR If
  • Microsoft Authenticode Code Signing, Vista, and IE7
    by PismoPat
    3 Replies
    Last post by orcmid
      • I just wasted 2 hours trying to renew our code signing certificate on Verisign because I happen to be running IE7 on Vista. It turns out that their web site will not function with that combination, so it cannot send the PVK encryption key file. Verisign is the ONLY souce for these certificates. You'd think that, since it's a Microsoft required certificate, that they would work with Microsof
  • Routine to open file/point to url
    by GB Allan
    4 Replies
    Last post by GB Allan
      • Hi, I have the following routine as part of a larger macro, to open and work with a file: MsgBox ("Please open the new ABC File.") ABCFile = Application.GetOpenFilename("Excel Files (*.xls), *.xls") Workbooks.Open Filename:=ABCFile ABCFile = ActiveWindow.Caption Right now, I ask the operator to save this file on their computer, then open it when promp
  • when to call Uniscribe api??
    by VNAHATA
    2 Replies
    Last post by VNAHATA
      • Hi, While reading GDI commands from an emf file,when should we be calling Uniscribe functions.Is it for every ExtTextOut command or just when we see the ETO_GLYPH_INDEX set in ExtTextOut.Is ETO_GLYPH_INDEX the only indication that the text'll contain complex scripts or with other options too,we may require to call Uniscribe Itemize function Please help. Regards, Vinay
  • Is it possible to use a word macro to execute an .exe file?
    by vincent90152900
    2 Replies
    Last post by vincent90152900
      • Is it possible to use a word macro to execute an .exe file How to do that This is discussion is open to suggestions. Many thanks for your replying.
  • 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
  • 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
  • How to configure CER with no dialog?
    by John Brown
    14 Replies
    Last post by Claus Brod
      • I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
  • Unable to start debugging In VS2005
    by Gnanaprakash
    5 Replies
    Last post by JOHNHALDI
      • I have a sample which I was able to run in VS2003 but running the same sample in VS2005 giving me debugg error. Unable to start debugging. Iam getting the error message as given below.   1. The application you are trying to debug uses a version of the Microsoft .NET Framework that is not supposed by the debugger. 2. The debugger has made an incorrect assumption about the