Microsoft ISV

Page 107




  • Topics
    Replies
    Last post
  • macro for automatically creating data labels in excel chart
    by Erik Houtriet
    8 Replies
    Last post by hysenlici
      • Hi all, I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field. I use the following code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C
  • Visual Studio Installation Problem
    by Ron Hall
    2 Replies
    Last post by MS ISV Buddy Team
      • I got my new ISV software bundle just in time to load it on my new computer. Office went on without a hitch, but when I tried to load Visual Studio I had a problem. I am running Vista Ultimate. The DVD has a Disk 1, Disk 2 and Setup Directories. I tried running the setup from the setup directory. It gets started and asks for Disk 1 to be inserted and doesn't allow any navigational ai
  • How to rename worksheet without installed Excel?
    by Perry Choy
    5 Replies
    Last post by Andy Pope
      • I want to rename worksheet but haven't installed Excel
  • MODI Port
    by riph
    4 Replies
    Last post by semsem2005
      • I have some questions: 1.- How to distribute MODI Port with my application 2.- Found MSM (module merge) 3.- How to install "Microsoft Document Imaging Writer Port", without CD office 4.- That files use the MODI 5.- The files .MDI is better of PDF ! Tks a lot,
  • Enable and Disable text boxes on a sub-form
    by ADG
    1 Replies
    Last post by ADG
      • Hi I am trying to enable and disable textbox controls on a subform when a field on my parent form changes. It appears that the subform textboxes are not visible to VBA when I am trying to write the code. Can anyone give me an example of enabling and disabling controls on a subform Regards ADG
  • Linked Tables
    by entrylevel26
    1 Replies
    Last post by entrylevel26
      • I want to write a vba script to change all the links in the linked tables in an mdb file to link sql server database. Also, if you think of a better way to do this than writing a vba script, tell me. If you know how to do this using the upsize wizard (which mean using the same data that in the mdb files) , I will be interested to hear too. I think this is similar to the question here htt
  • VBA - Accessing files in a folder
    by raja.rkannan
    3 Replies
    Last post by raja.rkannan
      • Evening Ppl, I am working on a Excel VBA assignment which involves accessing a directory which has around 2500 files and displaying the filename, date created & date modified based on a search criteria. To be more clear, i have well formed file names in that folder and the last 4 characters in the file name are DDMM (date and month) TEST0806.csv TEST0803.csv TEST
  • Auto code indent tidying
    by une
    3 Replies
    Last post by une
      • I have finished a large program and the indentation is a little messy and is too aligned vertically, its a big rectangular block. Is there tool on VBA under MSWord 2002 that will automatically indent all statements nicely in a chunk of code For example, nested loops will be progressively indented and then "outdented" so vertical alignment of related statements is attained and the nesting
  • Getting Access Data into Excel
    by TwoHoot
    1 Replies
    Last post by TwoHoot
      • I need to get a large number of Access 2000 Recordsets into Excel 2000 for evaluation. I have no problem setting up the connection and getting the entire table into Excel for testing by modifying the examples at   http://support.microsoft.com/kb/247412/EN-US/ using either the QueryTable or ADO code outlined there. The tables I need to access have over 200,000 records so ge
  • Associated Toolbar Button with Add-In
    by PSandekian
    1 Replies
    Last post by Cringing Dragon
      • I have created an Excel 2000 VBA project that I need to distribute to others. I would like it to have a toolbar button linked to it. I was thinking an Add-In would be an easy way to go for distribution. I can get it to work with a shortcut key but the button doesn't appear on the toolbar when the Add-In is selected. Does anyone know how I can do this The code is specific to Office 2000 Excel.
  • Searching down a column?
    by Blinocac
    1 Replies
    Last post by Shasur
      • I have created an inventory spreadsheet, and want to be able to search down a particular column to match up part numbers. Once I have found the correct cell, I want to edit the value of the corresponding cell in the next column. I'd really like to find a good tutorial for using VBA in Excel, but barring that, a push in the right direction for this code would be handy.
  • Display a TextBox or Non-modal Message Box
    by sg549
    6 Replies
    Last post by Andy Pope
      • Hi all. What I'm trying to do is put up a user form with a text box while a process is running. I don't need a progress bar, as the process is not that long. I have created a userform that includes a textbox, but only the userform comes up when I ".show" it. Why won't the text box portion of the userform show Alternatively, is it possible to put up a "non-modal" system
  • Easy msgbox Query
    by jaxgev
    8 Replies
    Last post by Andy Pope
      • Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
  • 1004 Runtime error/Password Protected
    by NWPaco
    1 Replies
    Last post by ke wenzel
      • Sorry - I'm relatively new to this but here's the situation. I have a macro that works without the sheet being password protected, but once I protect the sheet, it does not work. Any ideas on how to fix this The highlighted area is what seems to be causing the problem. Range("A9:U10").Select Selection.Copy ActiveWindow.ScrollColumn = 10 ActiveWindow.ScrollCol
  • 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
  • extract pivot table data
    by NICOBASE
    1 Replies
    Last post by Swade
      • Hello, I have a pivot table in Excel and I want to extract the data in it. I need the source tables, the tables that where used to create the pivot table. Help
  • Vlookup in VBA
    by crainsworth
    3 Replies
    Last post by mnptl
      • Hey eveyone, I'm have a lot of difficulty using a vlookup in a macro I'm creating. If anyone could help it would be greatly appreciated. Here is the code: '********************************************************************** Sub proScoreCard1() Dim rng As Range Dim tradeDate As Date Dim confirmDate As Date Dim t1mDate As Date Set rng = Range(
  • Problem passing a range as argument
    by Douglas Penna
    3 Replies
    Last post by Douglas Penna
      • Hello there, I'm developing a macro do do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function. My code is simple, and here it is: Sub Main()     Dim Range_do_Comeco As Range     Set Range_do_Comeco = Worksheets("Plan1").Range("AD2")     MyFunc(Range_do_Comeco ) End Sub Sub MyFunc(ByR
  • Order by in select statement not working
    by RhysDavies
    5 Replies
    Last post by RhysDavies
      • Hi there - i have a select statement that runs on form load that allows selection of appropriate company names from a combo box based on if the user is the owner of a company, which works great, syntax is below; Me.companyname.RowSource = "SELECT [companyname] FROM [qryactivity] WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'" However i want to sort them alphabetically by
  • DoCmd.OpenReport for report based on a query
    by starspike
    2 Replies
    Last post by starspike
      • I've used the DoCmd.OPenReport with the WHERE-clause for some time now. My reports where all based upon a table in my database. But now I have a report that's not based on a table but on a query. The problem is that my report opens, but it just doens't seem to hold my WHERE-clause in account. For example: I have two (linked) tables: Locations (two fields: LocationID & LocationName) Transaction
  • 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
  • SaveAs
    by jwp3
    0 Replies
    Last post by jwp3
      • Hi, I can't resolve problem how to save spreadsheet in any format: xls or xlsx. I use office2007, but some of people in my office still use excel2003. They must decide in which format save excel. I wrote: Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet ... and ... xlApp.Dialogs(Excel.XlBuiltInDialog.xlDialogSaveAs).Show("xxx") all is ok, d
  • Is there a way to abort during runtime
    by ke wenzel
    5 Replies
    Last post by JoAnNaT
      • Hi, If I am running a VBA program in MS Access 2003 that has a programming error such as an infinite loop, is there a way to abort the program without killing Access from the task manager (and losing any unsaved changes) KW
  • 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
  • Changing the color of cells in a worksheet using VBA
    by brt1980
    3 Replies
    Last post by MyLady
      • I need some help with some code to select cells in a worksheet that have a certain color, and change only those cells to a different color. The key problem I'm having is that I don't want it to matter which cells I've colored, I would like the code to select any such colored cells and change the color. I'm not a programmer, so I don't really know how to write the code. As an example, if I