Microsoft ISV

Page 174




  • Topics
    Replies
    Last post
  • Connecting to Access Database via ADO from Excel
    by JezLisle
    6 Replies
    Last post by JezLisle
      • Hi, I am new to this ADO querying.... Basically what I am trying to do is take a range of data from a defined Range on an excel sheet and import that into a table already set up in a Access Database. From reading some details on this I understand that an ADO Connection is the way to go. My problem now is understanding what I need to write as my VBA code to do this. Can anyo
  • Beginner problem
    by JAndreassen
    4 Replies
    Last post by Jørgen
      • I need a macro in Excel that starts in for instance cell A1 and then checks the whole B-column if the same value is present there, if not continue to A2 and check whole B-column again. I've figured I may use For/next, but I'm kinda stuck. Thanks for help.
  • (newbie) How can I flag multiple values in a column?
    by Dave Navarro
    1 Replies
    Last post by Shasur
      • Hello all - I'm trying to create an Excel VBA macro (my first one!) that will do the following: Search a column, and for any duplicate values in that column, turn those cells red Move to the next column and repeat (flagging values that are duplicates *only* in that column). (Preferably) Quit when it comes to an empty column. The XLS in question is a scheduler where the columns represen
  • Visual basic training
    by Judy40la
    2 Replies
    Last post by JohnWein
      • Hello, I am new to visual Basic we used it in our Access Database for work. Is there a training program that I could take online to learn it fairly quickly for Access I downloaded VB 2005 at home and would like to use it to learn the total concepts of VB for access. Can anyone point me in the right direction Judy
  • 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
  • Using VB in MS Access
    by elitts
    2 Replies
    Last post by Toblerone
      • Ok, I have no knowledge of VB. I am attempting to co-opt a bit of someone elses database. I am using 2 combo boxs in a form header to search for a specific record using 2 different fields. If the record exists than the fields in the detail section of the form are filled in. If it isn't located then nothing happens. One of the two fields is a key field with a numberic autonumber. This search works
  • Searching / Hilighting OCR text in Office Document and Imaging
    by wajhi
    14 Replies
    Last post by Prathap
      • Hi, I have been given following Tasks using MS Document Imaging 11.0 API        Read TIF perform OCR on it        Show it in AxMODI.AxMiDocView    Searching / highlighting text in AxMODI.AxMiDocView using MODI.MiDocSearch class in TIFF file and Highlight search result i
  • Showing the printing window in Excel to print a spreadsheet.
    by foid025
    2 Replies
    Last post by foid025
      • Hello all, I am trying to get a macro done that prints a sheet in a workbook. Up till now, I have been using the ActiveSheet.PrintOut function to do this. However, I want to give the user printing options. So the best thing I could do was use ActiveSheet.PrintOut Preview:=True, which at least allows the user to manipulate the page formatting and zooming. However, this doesn't allow the user to ch
  • How do I deal with files of more than 65k rows?
    by chilehed
    8 Replies
    Last post by chilehed
      • I need my code to be able to deal with .csv files of well over 65k rows, but haven't the slightest idea how to do it. I've heard of a technique called "paging", which distributes the data over more than one sheet but processes it as if it's on one. How is this done Thanks.
  • Certification of Web Application?
    by Draok
    2 Replies
    Last post by marceloshb
      • I am a developer of a web based medical application that is viewed in a web browser. It is developed using asp.net and is hosted from an IIS server. There seems to be some confusion in my company regarding the type of Windows Logo certification that can be applied and tested for with ths type of applicaiton. I have always thought this kind of application was only available for the Windows Server 2
  • Loop Without Do
    by NutoVBA
    1 Replies
    Last post by Peter Mo.
      • Please could you take a look at the code below and advise why the second loop returns a complie error - "Loop without Do" The first loop works, but for some reason, the second loop does not work. Any help will be appreciated. Sub Create_TXT() Application.DisplayAlerts = False For Each sh In Worksheets If sh.Name = "TXT" Then sh.Delete Next Sheets.A
  • Macro for Custom Filter - Today's Date
    by GB Allan
    4 Replies
    Last post by GB Allan
      • Hi all, I have 2 similar macros to write - one is to custom filter in a column all dates less than or equal to today's date. The other macro is to to filter in a column all dates greater than today's date, but less than or equal to 2 calendar weeks from today's date. So if today is 7/3/07, the first would filter all dates up to and including 7/3/07, the second would give me all dates 7/4/0
  • Position a Cell at the top left conrner of the window
    by John in HK
    3 Replies
    Last post by Andy Pope
      • I'm writing a routine to process a series of tables with user input. The user needs to be able to see the table, as well as the UserForm which gets his input, so I need to move the window so that a particular cell is at the top left hand corner of the window - is there a way to do this in VBA Thanks
  • 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
  • New to Visual Basic
    by darnold
    5 Replies
    Last post by darnold
      • Im trying to do the following: I created some command buttons that has the number 1, 2, 3, 4 on it, like a keypad or a calculator. When I press the button I want it to give a value (variable) of 1, 2, 3, 4, etc. At the same time if I press 1 and 4 on the keypad, Id like it to indicate 14 or 9 and 8 I would get 98. What I'm trying to do is: Button 1 = 10 * (number pad syst
  • Macro to parse emails then paste email body into word doc's
    by DRW1978
    2 Replies
    Last post by DRW1978
      • Hello! Wondering if someone could point me in the right direction I recieve around 15 emails into a specific mailbox. A certain section of each email body needs to copied and pasted into a specific section of its relevant word file. The word files are within a specific folder/directory. I'm thinking access could handle the emails and maybe this is where the macro should be placed Can anyone prov
  • CD Key/Part # trouble
    by john doe smith
    1 Replies
    Last post by MS ISV Buddy Team
      • I have a similar kind of problem. I was organizing an action pack and I separated the sleeves that had cd keys on them from the cds that they went with. My question is, do the part numbers on the plastic sleeves, that came with the action pack binder, match up with part numbers that can be found on the cds. I just hope that there is an easier way to solve my problem than manually installing all of
  • OCS 2007-communicator 2007 advanced server settings and others greyed out.. gpo issue?
    by markm75c
    0 Replies
    Last post by markm75c
      • I'm not sure what is going on here.. though perhaps i should.. on a machine with communicator 2005.. If i goto the same advanced section.. i see the ip address of my ocs server listed, along with tcp selected.. Now.. i've install OCS 2007, removed 2005, removed 2005 communicator.. installed 2007 communicator.. I also imported the new communicator.adm file.. and set things in there.. for whateve
  • How to automate a dialog? [The message filter indicated that the application is busy error.]
    by poiuytre
    0 Replies
    Last post by poiuytre
      • Hello. When an automated Office application throws some dialog box, the server refuses any subsequent RPC call returning an error "The message filter indicated that the application is busy." Is there still any possibility to noninteractively press some button of the thrown dialog through the VBA (or by other means) to go on Thank you, P.
  • 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
  • Current user
    by avilik
    4 Replies
    Last post by avilik
      • How can I determine (in VBA) who the current user of the open Excel file on the network is
  • email using CDO (Collaboration Data Objects)?
    by MyLady
    3 Replies
    Last post by Andy Pope
      • Hey, How do I, from Excel, send email using CDO (Collaboration Data Objects) Best Regards Cathrine
  • How do I find the next calendar day after a specified number of workdays?
    by Roops1
    0 Replies
    Last post by Roops1
      • Hi there, How do I find a calendar day a specified number of workdays from start date taking into account of holidays This is similar to the Workday function in Excel except I want it to return the next calendar day after a workday rather than the next workday after a workday. Thanks in advance
  • VBA excel outlook / A program is trying to send mail using Item.Send
    by rhXX
    14 Replies
    Last post by rhXX
      • hi, i am trying to send an automatic mail from excel VBA to the outlook outbox, when i send the mail i obtain this security warning: A progam is trying to automatically send e-mail on your behalf. the help buttom says: A program is trying to send mail using Item.Send A program is trying to automatically send e-mail using a Microsoft Outlook Visual Basic Application command, Item.Send. If you want
  • IE 7 Application Error: "the instruction @ 0x66869bc7 referenced memory @ 0x00000018...
    by Bob567367
    2 Replies
    Last post by MS ISV Buddy Team
      • I have been running IE7 since it 1st came out. Last night I could receive audio/video streaming (e.g via msnbc, CNN, etc.) Today I can no longer receive it. I have read other related threads but am not sure my problem is the same. No one seems to have a solution. Should I just uninstall IE7 and Reinstall I am running MS XP Pro. RE: (IE 7) Application Error: "the instruction