Microsoft ISV

Page 105




  • Topics
    Replies
    Last post
  • XP style in VBA excel
    by Doyster
    0 Replies
    Last post by Doyster
      • hi, How can i use the xp theme for controls (buttons etc.) in my VBA excel I`m new in using VBA so if only possible, procedures would be greatly appreciated. thanks
  • MS Word Macro Help
    by spphat
    2 Replies
    Last post by Shasur
      • Hi Everyone: I did a search before asking this, but could not find anything, so I apologize if this has already been asked. I am creating a macro in Word, but I only want the Macro to run on the text that I select within Word - how would you do this Thank you very much to anyone that can help!
  • Problem: Macro not deleting columns I select
    by Donaghy
    6 Replies
    Last post by Donaghy
      • Hi all, I have a section of code in my macro which tells it to delete a selection of columns: Columns("C:F").Select Selection.Delete Shift:=xlToLeft this is the first bit of code in my macro but isn't working correctly. Instead of deleting columns C to F its deleting columns A to H. Any ideas why this could be happening
  • Playing .wav files in Windows Vista with winmm.dll gets unexpected results.
    by Dick Ainsworth
    1 Replies
    Last post by Stano
      • Using winmm.dll to play .wav files with VB6 works great in all Windows platforms except Vista. In Vista, the same code generates delays, distorted sound, etc. Is there a simple fix for this Both 1 and 0 values for DWFlags produce similar problems. Code I'm using is: Declare Function playsound Lib "wimnn.dll" Alias "PlaySoundA" (ByVal lpszname As String, ByVal Hmodule
  • 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
  • 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
  • Saving a pic
    by Edday
    7 Replies
    Last post by Andy Pope
      • hey i really need help with this, i have posted in tons of forums and the descussion groups, no replies! gar lol, well i have this macro in excel 2003 and it has a userform and there are a few elements (3 pictures, 3 text boxes) that get modified during the macro then i need to kinda merge them and save it as one picture, can a macro do that any help would be great thx
  • Setting a header to all pages except the cover sheet
    by Megaman1982
    6 Replies
    Last post by Megaman1982
      • Hi all, i'm pretty new to Excell in the workplace and would really love it if you lot could help me with this difficult (TO ME) macro i'm struggling with. I'm trying to finish off this macro, or mod it so that i get the page number, tab number, a cell reference in the respective headers and footers as explained in the macro below. only thing is i don't really want the tab label, cell refere
  • Possible to run code after Word closes?
    by saep
    5 Replies
    Last post by saep
      • Hello, I have a macro that saves the current word document on the users c:\ and then emails it to me. I am aware of the kill function to delete a file, but I would need to close the file first in order to delete it - which can easily be done in the macro. But it appears that once Word closes the macro stops running. Thanks for any help!
  • Bucket ID 8
    by Claus Brod
    14 Replies
    Last post by DHON
      • Hi all, on my Vista system, I generated a lot of crash reports using WER-aware code (i.e. code which explicitly uses WerReportCreate() and WerReportSubmit()). When I look at those crash reports in the Problem History window, I find that many of those crash reports have a bucket ID of 8. This doesn't look like a bucket ID as it would be assigned for a crash report which makes it to the Winqual site
  • ISV application supported by vista
    by ramkasarla
    2 Replies
    Last post by ramkasarla
      • Hi i want to know the list of LOB's, ISV applications or third party applications which runs on VISTA with out any compatible issues.
  • runtime 2465 can't find field "|" referred to in your expression
    by Seabass
    4 Replies
    Last post by Seabass
      • runtime 2465 can't find field "|" referred to in your expression. Here is the code. I know that the fields exists in the table and the object exists on the form. Private Sub Command32_Click() Dim db As Database, Tools As Recordset Set db = CurrentDb() Set Tools = db.OpenRecordset("tblCodedCuttingTool", dbOpenDynaset) Do Until [tblCodedCuttingTool]![ToolCode] = Forms![frmCodedC
  • 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
  • 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
  • Mouseover event on shapes (Excel 2003)
    by jrc1378
    1 Replies
    Last post by Jon Peltier
      • Can I set a mouseover event in VBA on a shape (copied picture) I have a module that copies an inserted image from one sheet to another sheet based on cell values denoting the placement of the copied image. The copy is then handled as a shape to set Name, Alt Text, and so on and the sheet is saved as a web page for browser viewing. Is there a way to set a mouseover event for a
  • VBA ADO Error Handling Method
    by Fred Smith
    2 Replies
    Last post by Fred Smith
      • I am using VBA in Excel to take the information in Excel, place it in an array, and insert it into a database. The operation completes successfully, however, I'd like to record any ADO errors that come up in the operation. The code is shown below. It first opens the database connection, then it creates a worksheet to add any errors that come up during the add new operation (errors if a reco
  • text parsing in excel
    by Derek at Potters Clay
    3 Replies
    Last post by Anonymous
      • I am collecting data that another person has done in excel to be used in a access database. The problem is that a lot of the cells have 5 spaces before the actual text. how do i write a macro to first check if there is a space at the beginning and then to delete the spaces. If there is a space, it is always 5 spaces.
  • Combobox behaving oddly!
    by Keithyboy1
    3 Replies
    Last post by Keithyboy1
      • I have a combobox embedded in an Excel worksheet, who's source is a named range. The named range is dynamic and can change in size if data changes. I have set my combobox to pick up this range by setting its ListFillRange property to the range name. This is done at design time, rather than in code. It has been working fine up until the range changed size. At this point, the values in the co
  • Possible to run code after Word closes?
    by saep
    5 Replies
    Last post by saep
      • Hello, I have a macro that saves the current word document on the users c:\ and then emails it to me. I am aware of the kill function to delete a file, but I would need to close the file first in order to delete it - which can easily be done in the macro. But it appears that once Word closes the macro stops running. Thanks for any help!
  • how to get the hyperlink value from an excel sheet cell
    by Awsok
    10 Replies
    Last post by Duane in Japan
      • hi All I have an excel sheet that have some cells with text and under the text there is a hyperlink to another files to the network driver Does any one knows how to extact the value of the hyperlink (not the text value that how up). I tried many variations like =CONCATENATE("link ",T(HYPERLINK(A1))) but it didnt help !! Thanks for participating Aws
  • Printing using the Microsoft Office Document Image Writer printer and C#
    by humble.apprentice
    0 Replies
    Last post by humble.apprentice
      • Hi all, I am trying to print, without user interaction, a PDF file to the Microsoft Office Document Image Writer. If use System.Drawing,Printing.PrintDocument, I'm able to set the destination file but when it gets to printing the file, I can't since it has to know how to render the PDF file. Now, I tried using the print command in the command prompt but when I want to specify the Microsoft
  • Complex report generation from datatable..challenging one plz help
    by sdubey86
    0 Replies
    Last post by sdubey86
      • I have created datable which normally has 5000 records upto 1 lakh records depending on runtime value....i want to display rows of datatable to user in particular format... 1] odd rows with yellow back ground 2] even rows with green back ground 3] if value of cell in odd rows is not eqaul with value of cell in even row then both cells's text should be bold and with red color given pic
  • importing data from an ODBC datasource using a filter
    by ntownsend
    0 Replies
    Last post by ntownsend
      • How can I use a filter on an import table into my Access database Do I use SQL statements in a module or VBA
  • VBA help with a conditional Subscript out of Range
    by Robbie Deal
    2 Replies
    Last post by Robbie Deal
      • Hey everyone, Hopefully this one will be an easy one. I am asking VBA to pull information from an access 2003 database, and place it in an array. There are cases when I know that I will get a "Subscript out of Range" Error, and have to ask for a different set of values, due to having 0 values in the database for the parameters I asked for. IE no values in this table for that date r
  • 2 Small Macro problems.
    by GB Allan
    6 Replies
    Last post by GB Allan
      • Hi all, Problem 1: I am trying to delete a sheet within a workbook, as part of macro. Here's the code: Sub DeleteInstructions() ' ' DeleteInstructions Macro ' Macro recorded 3/13/2007 by Gary Beckwith ' ' Sheets("INSTRUCTIONS").Select ActiveWindow.SelectedSheets.Delete Sheets("DATA").Select End Sub When I run it, I get the prompt "Data may exist in the