Microsoft ISV

Page 207




  • Topics
    Replies
    Last post
  • Using VBA to send an MSN instant message
    by Shelto
    3 Replies
    Last post by renealejandrov
      • Hi I have written some VBA in Access 2003 to bring up an MSN instant message window and send a message to that contact. The only problem is, I seem to be able to do everything except actually send the message! I think this feature may have been removed from the API. Anyway, here's the code: - Private Sub SendIM()      Dim header As String Dim objmsgr As MessengerAPI.Messe
  • Imprting text file with no delimiters into excel file
    by Peck Chun Hua
    8 Replies
    Last post by Mezhick
      • hi anyone, i have a problem in creating a macros that will import an txt file into an excel file, the text file has no delimiters but every single different characters will have to be in a specific cell. For example in the first line, first 2 character belongs to excel cell A!, then next 10 characters is B1, then next 8 Character C1 and last 3 character is D1. Regards P.Chun
  • Delete Unwanted rows based on value in cell
    by Donaghy
    7 Replies
    Last post by magicalclick
      • Hi all, I have to loop through a range of rows with an excel sheet and delete unwanted data. To identify the rows to be deleted I have to do the following: Firstly I must start at A1 and check if it contains the value "Product", if not i go to the next row but if it does i must then delete this row and go to the next. I must then check that the next cell contains the value "
  • How can I see the stack trace from the .mdmp file?
    by Vedratna
    14 Replies
    Last post by Vedratna
      • hi, everbody we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i
  • Macro print actice charts
    by hysenlici
    2 Replies
    Last post by hysenlici
      • I think it would be very simple to set up that macro, but I have no idea in this filed. This is the problem: My workbook contains 10 charts and 6 of them are UNHIDDEN. The rest is hidden. My macro should print ONLY THE ACTIVE (open) CHARTS. Thank you in advance
  • 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
  • Can you use VBA to access a spread sheet embedded in a word doc?
    by Trisped
    13 Replies
    Last post by Trisped
      • I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
  • 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(
  • iexplore.exe - Application Error
    by bennett1016
    14 Replies
    Last post by rreynard
      • I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this
  • 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
  • Timer on macro execution run time
    by une
    8 Replies
    Last post by Andy Pope
      • I have written some text analysing code that takes a long time to execute if the text selection made by the user for analysis by the macro is too large. Therefore I would like to add the following functionality to the macro; If after 15 seconds of execution the macro has not completed, I would like execution to halt and output a message to the user asking them to reduce the size of the sele
  • I've received empower, but where are serial numbers???
    by Ihor Bobak
    6 Replies
    Last post by orcmid
      • Last year I ordered Action Pack - I received disks and serial numbers sticked on disk folders. This year I ordered Empower. I received many disks, many papers (license agreement and advertisement materials), but where are serial numbers I don't see them neither sticked on disk folders, nor among all papers. I cannot install Windows Vista... Can anyone give me a hint - where can I get my serial nu
  • Open PDF file
    by sweet-66
    5 Replies
    Last post by RhysDavies
      • Hi everybody, I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba) thanks in advance. :-)
  • How to adress a single cell in a named area
    by Tsrwebman
    2 Replies
    Last post by Tsrwebman
      • I have a named area "Stock" on a spreadsheet (Office XP), the range is defined as follows: =OFFSET('Stock List'!$K$1,0,0,COUNTA('Stock List'!$F:$F),4) ie it starts at K1, is 4 cols wide and as deep as the number of used cells in Col F I want to access this in an array format using VBA, ie using variables to define the position of a single cell within the array and to either r
  • Validation with List drop down?
    by Scott Boyd
    8 Replies
    Last post by Handyman_994
      • Hi I want to add some simple validation to my Excel sheet but can not for the life of me remember how to do it! Basically i have a drop down list as in the image below and want so that when 'No' is selected, the user is forced to enter the reason in the next cell http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_list.jpg I can remember doing this before and used some VBA code but c
  • how to use variable to automate selection of a worksheet
    by sree
    6 Replies
    Last post by sree
      • Hi all!!!!!! Thank you in advance for helping me with this. I need to know how can i use a variable in VBA to read data in a cell which should be the worksheet name of one of diffrent worksheets in a diffrent workbook. To simplify- i have two workbooks [Book1.xls and Book2.xls] i need to run a macro to read A3 in sheet 1 of Book1 and store it in a variable A.
  • IF statement
    by DinnerPlates
    3 Replies
    Last post by Andy Pope
      • Hi all, I am trying to write an IF statement that will affect two cells. So, for example: - In cell A1, I have the value 10 - In cell A2, I have the value 5 - In cell A3, I have the IF statement "=IF(A2<A1,"Order","Do Not Order") Easy enough. But, my problem lies because I have a cell next to A3 with text in it that needs to be cleared once the value is false. Does anyo
  • Run-time error '3705'
    by ISRI
    4 Replies
    Last post by ISRI
      • I am trying to run this VB function in Access which will delete records from my table based on the criteria of another table. The code looks like this: Function deleteDuplicates() Dim FHA_Case As String Dim SeqNumber As String Dim SQL1, SQL2 As String Dim rs1 As New ADODB.Recordset Set rs1 = New ADODB.Recordset Dim rs2 As New ADODB.Recordset Set
  • Automating PowerPoint
    by Jenise
    4 Replies
    Last post by Andy Pope
      • I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday. Can you please suggest how I can automically execute my vba code to run thank You!
  • calling sub within function. works fine as sub, but not in function
    by pacificwaters
    11 Replies
    Last post by pacificwaters
      • Using VB 6.3. Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work. But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
  • Question: How do I hide the Title Bar?
    by UA Jeremy
    3 Replies
    Last post by Andy Pope
      • Howdy... I'm writing a program in Excel and I was wondering how to hide the Title Bar. The one with "Microsoft Excel" and the min., restore, and close button. If that's not possible, is it possible to deactivate the close button
  • 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
  • what hour of the shift is it?
    by Maddenjd
    1 Replies
    Last post by Jay Vora
      • I'm writing an excel application to xtract external data for a report every hour. Each hour has a row for data, and based on what hour in the shift it is determines what the row is used (new report for each shift). 1st 07:00:00 - 15:30:00 2nd 15:30:00 - 24:00:00 3rd 12:00:00 - 07:00:00 shift1 = month(now()) & "/" & day(now()) "/" & year(now()) & &quo
  • Is Office2003 still does not support passing command line arguments to VBA?
    by Aleksey Nagoga.
    2 Replies
    Last post by Aleksey Nagoga.
      • Hi All, Back in the Office 97 days I tried passing command line arguments to VBA code within a doc file and it didn't work. In the end I found a workaround that was a bit of a hassle to implement but did what I needed. Today, I found myself in a need of accomplishing a similar task in the Office 2003, plus the solution must also work in the Office 2007. I was wondering if MSFT finally a
  • Remove pages from a Word Macro
    by Anonymous556056
    0 Replies
    Last post by Anonymous556056
      • Hi! I am struggling with a MS-Word Macro where I would like to remove the first 5 pages from a 10 page document and send or save the remaining document as a word file. However it is indeed very difficult since it doesnĄ¯t seem possible to define a range using pages. I also tried the printout function(write to file) but the document is saved as a postscript file. Does anyone know if this is possi