Microsoft ISV

Page 149




  • Topics
    Replies
    Last post
  • Excel & VB
    by Anonymous556067
    0 Replies
    Last post by Anonymous556067
      • I have written some code in vb to open an Ascii file and create an excel workbook, when it saves the book and closes it is fine but next time on the same machine it gives the error code 1004 cannot find file name:.. a reboot of the machine does not help. sample code below, any help appreciated, its excel 2003 Sub Extract_Monitor() ' ' Upload_Monitor Macro ' Macro recorded 09/11/20
  • Macro for Word problems: Find/Replace style
    by Tim McLaren
    3 Replies
    Last post by bi-lya
      • Im trying to develop a simple Macro that will find text in my document that is Italic and replace it with a character style... However it seems that when I record the process it omits the point where I select the formating of the font (italic). I don't understand VB and entering what logically should work into the code didn't work. The code I get from recording is: Sub FindReplace() ' ' FindReplac
  • Narrowing a query
    by ram121
    3 Replies
    Last post by ram121
      • The query displays several records with several fields. How can I narrow the query down to pull a single record of multiple records in which the account number occurrs more than once. (It is the account number that I'm trying to get to pull just once for an entire record.) The catch is, there is one work order for in-State, and one work order for out-of-State. However the in-State one sometimes mu
  • # recipients, subject, body of a Mail not recognised
    by Bajrang
    0 Replies
    Last post by Bajrang
      • HiAll I have added a control to the new mail window. Problem is, is in my code (vb6,outlook XP) i have the following code My problem is that I doesn't recognise the recipients as well other fields of mail (subject, body). and MsgBox ("To= " & mTo & " Cc=" & mCc & " Bcc=" & mBcc) shows nothing in TO,CC,BCC etc. Please have a look at mycode & suggest me what is wrong there T
  • Display default values from a function
    by DeathSurfer
    2 Replies
    Last post by DeathSurfer
      • Duuuuudes: I have a question I'm not sure how to ask but here goes, I was wondering how can I get those pretty default values that get returned when calling a standard method in vba, for example, in excel's vba when you call the pastespecial method it gives you those nice drop downs to choose from for each argument you can pass. I have some functions I have written that can only except cer
  • Using VBA to open .zip files
    by Jrc3
    2 Replies
    Last post by Jrc3
      • Hi, I need to open a zipped .xls files as part of a VBA process. I'm using the generic windows unzip untility (don't have winzip or winrar) - is there any code I can use to do this Any help would be appreciated. Thank you, J
  • WSS 3.0 "This stock feature has been retired."
    by bafadam
    14 Replies
    Last post by cis365
      • What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently. Anyone have any clue with this could possibly be referencing
  • Different classes in one collection
    by wlwlz
    6 Replies
    Last post by Cringing Dragon
      • Hello Everyone, I just recently started to learn VBA so there are quite a few things I'm having trouble with. When I tried to put multiple classes in a collection and later use For Each <Class> to access them by each class, it would result in an error stating object type does not match. Just wondering is there a way to implement what I'm trying to do here in VBA Namely,
  • Removing Custom Toolbars in Access
    by IceBower
    1 Replies
    Last post by João Rodrigues
      • Hi, Im developing an access database that checks the users windows log in details then sets up diffrent toolbars depending on the username. Iv got the adding bit sorted. The problem is when you open the database the old toolbars from previous logins remain and the new ones are added aswell! Anyone know a way i can reset the toolbars to default whenever the first form loads
  • Validation list macro
    by hysenlici
    4 Replies
    Last post by srinivasanng
      • Hi I need help... In my drop-down validation list when I select let's say "Apple", I want a message box to come out, only for "Apple", let's say" Attention: You selected apple. We remind you that this item..." If I select, let¡¯s say "Onion" nothing should be came out. Could someone help me with this, I think by runnin
  • VB Script to add modem
    by murali_kbhat
    0 Replies
    Last post by murali_kbhat
      • Hi, I need a VB Script to add 56k modem to a COM port. Can anybody help me on this Thanks, Murali
  • DDEPoke
    by COON
    0 Replies
    Last post by COON
      • hey guys...i hv a problem with the DDEPoke order hope u can help me with it.....well i'm making a simulator using VB 6 throough which i need to read data from other pogram and change some variables in it (Poke). the issue of reading is done successfully but the problem now is with the POKING here wut happens...when i type: DDEPOKE (channel,item,data) it gives me a Compile error that there is
  • Connect to sql data base
    by mjven
    1 Replies
    Last post by MS ISV Buddy Team
      • I would like to be able to have a web page on my share point 2007 site that allows me to query information out of an sql database. How do I do this
  • Access 2007 - "Save as PDF" from VBA / automation
    by fagster
    1 Replies
    Last post by Ekky
      • Hi there, I would like to render a particular access Report in my MDB as a PDF - either by automation from VB6 or from Access VBA. I have downloaded the "Save as PDF / XPS" add-on for Office 2007, so can manually save a report as PDF from Access now. However, attempts to work out how to do this in code have so far drawn a blank. RunCommand does not seem to be able to access this particul
  • ArcSin for Excel Macro
    by Le Phare Rouge
    1 Replies
    Last post by Peter Mo.
      • How do I implement an arcSin function for an Excel macro. thanks,
  • Launching Text files or PDF's from VBA in Excel
    by GLFilkins
    1 Replies
    Last post by Cringing Dragon
      • Hello ... I've been using a macro-application written in VBA for Excel that occasionally needs to open text files, PDF's and/or other Excel sheets to present the user with various related information. All has been well using ShellExecute up till I tried working on it at home on a newer PC running Windows Vista Home Premium -- now it fails to open anything and if I capture the error code ret
  • changing settings in adobe?
    by mr4100
    1 Replies
    Last post by mr4100
      • Does anyone know how to change the adobe output folder using vba code I have the pdf created by code but just can't specify where to save it w/o the adobe prompt. Thanks,
  • Importing and Accessing Excel tables in MS Word
    by LeVraiNinjaneer
    2 Replies
    Last post by Feng Chen - MSFT
      • Hi I am involoved in programming a program where the user enters a number of people(pax), this value is then placed in a cell in excell, simply by the use of the following code xlws.Range( "pax" ).Value = pax.Value And then the worksheet in excell calculates values for number of plates = pax * 1 tables = pax / 5 glasses = pax / 2.3 However, my clien
  • 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
  • Execute a Macro at Print Event in a Mail Merged Document. (New instance named Letter1 gets creted)
    by doshivinod
    3 Replies
    Last post by Valery01
      • Hello All, I want to execute a macro on a mail merged document at a Print Event . Some Info reg my dev. My program is in SAP-ABAP. It transfers its data to word file in a mail merged manner. In this process it creates a new instance of a document and this is "Letter" document. Through ABAP i can print the whole "Letter Document" but no
  • sending automatic email reminders without user intervention
    by shurmoore
    2 Replies
    Last post by shurmoore
      • I would like to have emails sent to remind the recipient of a certain date or event. I don't know exactly what method i should use. Should I use a script (asp/vb), or should i use the database In any event if someone have any example that could help me resolve this would be great. I am using access 2003 with classic asp for my application. The application should look in the database for users who'
  • Elegance (and performance) Problem
    by Douglas Penna
    5 Replies
    Last post by magicalclick
      • Hello, I developed a class (class CMatrix, that holds a lot of functions not really related to the other class) to use in another class. Currently, it's working real fine, but I don't know if there's a better way to handle with this. What I do today is, in the main class: Dim Matrix As CMatrix ... somewhere in a sub or property Matrix = CMatrix.MergeSort(Matrix) ... rest of the code
  • Subscript out of range with a simple sql :-( [newbie to VBA]
    by Maximus
    14 Replies
    Last post by Andy Pope
      • Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers! Code Snippet Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
  • visual basic macros in excel
    by Maddenjd
    2 Replies
    Last post by Maddenjd
      • Is there any wayto compile excel macros and make them dll's for addin's to excel
  • Need info on Hits vs Cad ID's
    by DESSCI
    2 Replies
    Last post by Jason Hardester - MSFT
      • Can I get information on why the total hits on an event would say 2 and when clicking the CABS link to download, it shows more than two CABs to download What is the difference between the total hits for the event and amount of CAB ID's avaialble to download What does each CAB ID represent Just need info on how this whole WER reports work. New at the whole process. Thanks,