Microsoft ISV

Page 12




  • Topics
    Replies
    Last post
  • How to activate a listbox selection using Excel VBA?
    by Kven
    14 Replies
    Last post by Andy Pope
      • Hi, I am very new to VBA Progamming. I have created a tool which checks for error in excel file. The below is my problem. First i will select a file using Openfile method. Then the combobox will display all the sheets which are present in the selected excel file. Here i will select a excel sheet and run a code to check errors. The procedure will check the errors and shows how many errors
  • Macro - Replacing Contents of Cells
    by rachel777
    1 Replies
    Last post by Shasur
      • When dealing with the a spreadsheet, is there a macro code that would replace the contents of a cell with a "0" for all of the cells in each column in the Questions worksheet that do not match the criteria from a specific cell in the Solutions worksheet I received wonderful help for a similar question on the same worksheet with the following original question: I am trying
  • Length
    by DESSCI
    1 Replies
    Last post by Jason Hardester - MSFT
      • For what period of time does WER keep traking hits on an event Collecting cab files How long do the cab file stay avaialbe on the rollout page Thanks, Roberto
  • Problem with TableDef.RefershLink when changing from odbc back to fs
    by entrylevel26
    0 Replies
    Last post by entrylevel26
      • Whne I change the "connect" property to point from a database in the file system to sql server it works fine: Sub execute() Dim tdf As TableDef, db As Database Set db = CurrentDb db.TableDefs.Refresh 'Debug.Print ("----------") For Each tdf In db.TableDefs With tdf If Left$(.Connect, Len(";DATABASE=")) = ";DATABASE=" Then 'checks if th
  • Multiple Excel Sheets to PDF
    by Dave.Punk.Emo
    0 Replies
    Last post by Dave.Punk.Emo
      • Hey all, I'm trying to get multiple excel sheets and two embedded Word files in the excel Workbook to print to a single PDF file. I'm using Office 2003 and VBA/6 that comes with it, and Adobe Standard 6.0. I've tried using the Sheet10.PrintOut and the ActivePrinter varient to select Adobe PDF, but I can't get it to work, I've tried Sheet10.PrintOut (,,,,Adobe PDF,,,) Sheet10.Pr
  • Office Communicator 2005 sign-in name, auto populate after install somehow?
    by markm75c
    14 Replies
    Last post by Mike@ALS
      • Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users prob
  • calculate_worksheet event
    by Jonas.S
    2 Replies
    Last post by Jonas.S
      •   I have solved this in another way but if someone knows how to do it with calculate_worksheet event I would appreciate the knowledge!   Hi All, How can I use calculate_worksheet event just for checking some certain cells on a sheet I want it to check E45:G45 which are updated from other cells. When the range E45:G45 change I want to run a macro. Thankful for help
  • Minimize Outlook in Notification Area
    by thides
    0 Replies
    Last post by thides
      • I have just started to work on minimizing Outlook to the Notification Area of the Task Bar. At the moment I use Outlook for day planning, email, notes, etc. I would like the application to run in the background/Notification Area when the minimize button is clicked in the application. When I recieve email the icon in the Notification Area flashes. When I click on the Outlook icon in the Notificatio
  • VBA Macro created in Word Template not running when template is launched in Internet Explorer
    by S Prasad
    6 Replies
    Last post by S Prasad
      • Hello: I have a Word template that contains a VBA application. This application is launched through a macro and runs fine when I double click and open the template using MS Word. However, when I tried to open the same WORD template file in Internet Explorer (this is the final requirement), it fails to launch the application or run the macro. I am already using the following code in the ThisDoc
  • Convert Query SQL view into vba string
    by todd.k
    1 Replies
    Last post by Luiz Cláudio - MVP
      • How can I convert the SQL view of a query into the correct format for a VBA string This is what my query looks like in SQL view: SELECT tblOutput.Ticker, tblOutput.Asset, tblOutput.FundtimeID FROM tblOutput WHERE (((tblOutput.FundtimeID)=[Forms]![frmSweepFund]![List0])); And this is how I want to use it in VBA SQL = "String" Set Rec1 = db.openrecordset(SQL)
  • CRM 3.0 "Server might be unavailable".
    by trep
    4 Replies
    Last post by DavidJennaway
      • Hi, I'm having an issue with CRM 3.0 Clients get this error message where it says "Server might be unavailable". Server is running, services are running, everything looks fine, so i started the Environment Diagnostics Wizard and i get the following: Some of the domain controllers do not appear to be running. The following list of servers should be checked. PrivUserGroup {9cd76ed6-ec49-4e
  • Microsoft Office Document Imagiung
    by vrobertson
    0 Replies
    Last post by vrobertson
      • Hello all! I hope I'm in the right place here. My problem is that when the image is printed, all pages after the first page is very small, about 1x1.5. If I went and opened the image up myself, it opens with the correct dimensions on every page, so I know it's not a problem with the image itself. Is there a glitch in the modi.document class that does this I've tried changing arguments in the print
  • 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
  • Multiple Record Selection/Manipulation in Access 2003
    by Anonymous566796
    0 Replies
    Last post by Anonymous566796
      • Hi, I'm developing an application in Access 2003 with a VBA form front-end and an SQL backend. I'm using continuous forms as the view type in my form that is bound to a table containing data. I want to select multiple records and make global changes to all of the selected records. For example, let's say I have a table named Table with fields field1 (yes/no), field2(text) and field3(combo box wi
  • Making a Automatic Updatable Hyperlink List
    by Clarence j
    7 Replies
    Last post by MyLady
      • Yes Hello Everyone and thanks for looking at my Thread I am currently trying to Develope a Small Database of Student and Would like After I make a New Worksheet Named After Each Student Example "Sarah Lee" "Michael Jordan" "Bill Cosby" That on the Worsheet Named "Student List" which is in the same workbook Will Make a List of all the w
  • Adding Outlook signature using OLE automation.
    by jpas
    5 Replies
    Last post by jpas
      • Is it possible to add a signature to an Outlook message using OLE automation Outlook is configured to automatically add a signature to outgoing e-mails. If I don't try to set objMailItem.HTMLBody to any value after creating the Mail Item object, the signature is in the e-mail as expected. If the HTMLBody is set to a value, the signature is lost. Trying to pre-pend the application data to t
  • Assign an array to .values and .Xvalues in an excel chart
    by Jonas.S
    6 Replies
    Last post by Jonas.S
      • Hi, I'm having trouble with assigning arrays to a chart. Below is how I done. Anyone nowing how to make this work     Set MyDispl = Application.InputBox(Prompt:="Select displ.", Type:=8)     Set MyForce = Application.InputBox(Prompt:="Select force.", Type:=8)     Do '''Collects Displ data         
  • Microsoft Office Document Image Writer -- partial print
    by EKorzon
    1 Replies
    Last post by MS ISV Buddy Team
      • Hello, I couldn't find this on the forum, so I'm hoping someone can help. I have a Publisher document that I'm merging with an excel mailing list. My printing-guy likes to use .mdi files, so usually I just do the merge, print to .mdi, and e-mail him the resulting document. For some reason, when I'm writing the .mdi file, it won't save the whole big merge into one document -- instead it wants
  • Access - Microsoft Forms V2.0 Spin Button bug?
    by JohnBournemouth
    0 Replies
    Last post by JohnBournemouth
      • Hi, I've written some code to select 2 fonts in an access form. I also have a link button which, when pressed, will link the secondary font to the first, but will allow the user to select the font size independantly of the first. I.e. the primary font could be Windings size 12, the secondary could be Times New Roman size 16. When the link button is pressed, the sencondary font would become W
  • Excel Application.Calculation in Excel 2003
    by GaneshSharma
    2 Replies
    Last post by GaneshSharma
      • Hi, http://support.microsoft.com/kb/918621/en-us My workbook which is a add-in gets calculated everytime even when the add-in is not used. This is affecting the performance of the other add-ins badly. Is there a way to convert all the formulas in a workbook to values & then convert it back to formulas later. thanks Ganesh
  • 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
  • Automate the Excel Camera Tool
    by jrc1378
    2 Replies
    Last post by jrc1378
      • I'm dashboarding with Excel and have everything finished except for programmatic placement of camera objects. Here's the gist: My dashboard selects an image to copy with the camera tool based on the results of various lookup and choose functions applied to data pulled from an ODBC query embedded in a worksheet. The Camera object is placed on a display worksheet so that the dashboard is noth
  • Excel - Resize image to specified target cells' dimensions
    by suznal
    4 Replies
    Last post by suznal
      • I have a command button on a worksheet that calls up the ¡®getsaveasfilename¡¯ dialog, and inserts the selected image file into a merged range of cells. The images are automatically re-sized to fit into the cell (aspect ratio maintained). Everything works well, but I ran into a problem. There are about 70 sheets in the workbook, and this command button can be found about 250 times throughout the
  • Excel 2000, MSAA, Firefox
    by curiousNovice
    0 Replies
    Last post by curiousNovice
      • Hi, I am trying to write a macro to copy data from Mozilla Firefox on to an excel worksheet. I am using MSAA. I find the root UI of firefox and then try to get the child interfaces using AccessibleChildren. The children array has seven elements. All except one, the one I need, returns an IAccessible. The one I need is an empty object and the execution stops at the "case object" bit of t
  • Searching for a string value and copying the first row and colum entries.
    by NeilNeil
    3 Replies
    Last post by AussieJames
      • I have a spread sheet that gets data from a data logging software and puts it into my spread sheet. The first colum contains the name of the tags for the data ("On" or "Off"), the top row contains the time when the data was sampled. What I am trying to do is write a macro to search the data for "On" entries and if it finds a cell that contains "On" it will t