Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 03021979
  • Content: Threads
  • Order by date
  1. 03021979

    pasting values from range into e-mail

    I have a code to send en email: Application.DisplayAlerts = False Set ol = CreateObject("Outlook.Application") Set MailItem = ol.CreateItem(olMailItem) My_File1 = "C:\aaa.txt" Dim Msg As Variant ThisRecipient = "Tomasz.Skura@thomson.net" Msg = "Witam," & Chr(10) & Chr(13) & "Nast?puj?ce...
  2. 03021979

    how to determine cell format?

    I need to write VB code to determine the format of a certain cell and display it with MSGBOX. Anybody?
  3. 03021979

    AutoFilter macro

    Let's assume that a certain range is with autofilter option on. There can be many values (the number of these values may change). How to write a code to go through each value in this autofilter?
  4. 03021979

    sql query - needs transposing a column

    Hi, here is a part of database: SO CODE_ID EXT_TEXT 1251111 1 aaaa 1251111 2 bbbb 1251113 1 cccc 1251113 2 dddd I need to write excel sql query to get something like this SO EXT_TEXT_LINE_1 EXT_TEXT_LINE_2 1251111 aaaa...
  5. 03021979

    VB code to be run repeatedly

    Let me explain what the matter is. I have a workbook with lots of macros. I work in logistics department and we send dvd films. Every title has its own Work Order Number. We have some Work Orders not finished or not started at the moment of sending others. The problem is to write a code which...
  6. 03021979

    sql query problem - how to add "if - then" clause?

    This is the query: SELECT MSORNSTD.CONO40, MSORNSTD.WORD40, PARTS.PGMN35, MSORNSTD.ITEM40, PARTS.PDES35, MSORNSTD.WOOQ40, MSORNSTD.WQCM40, MSORNSTD.wOOQ40-MSORNSTD.wQCM40, MSORNSTD.WCOQ40, PARTS.DSFC35, PARTS.PGMJ35 FROM EUROPEAN.TVSPF00.MSORNSTD MSORNSTD, EUROPEAN.TVSPF00.PARTS PARTS WHERE...
  7. 03021979

    formulas do not work sometimes...

    I have a spreadsheet with formulas and macros. Sometimes when a certain user opens it, the formulas are not updated but cells contain these formulas.(this is not the matter of automatic recalculation - I've already checked this) This happens only in my company when some users use this sheet...
  8. 03021979

    SQL query and error

    I have sql query like this: StrSqlTest = "SELECT OEP65.CUSN65,OEP65.DTIN65,OEP845L2.TENT45,OEP45.ONAM45, OEP45.OAD445, OEP45.OAD545,OEP040.SVIA40, OEP65.INVN65,OEP65.CUSO65, SQP608.ICAT08,OEP040.CORD40,OEP65.ORDN65,INP40.TLIN40,OEP70.LQTY70,OEP70.DGRP70,OEP70.DGRP70, PARTS.PGMN35,PARTS.PDES35...
  9. 03021979

    file error: data may have been los

    I have a huge xls spreadsheet with almost a thousand macros, and when I open it using office 2000 in windows 2000, save it and try to open in windows XP using Office 2003, there appears : "file error: data may have been lost" and ALL BUTTONS ARE INACCESIBLE :( I know this has to do with buttons...
  10. 03021979

    file error: data may have been lost

    I have a huge xls spreadsheet with almost a thousand macros, and when I open it using office 2000 in windows 2000, save it and try to open in windows XP using Office 2003, there appears : "file error: data may have been lost" and ALL BUTTONS ARE INACCESIBLE :( I know this has to do with buttons...
  11. 03021979

    getting rid of zeros from the beginning of numbers

    I have to get rid of all zeros from the beginning of numbers, i.e. if the number is 0005678, I have to have 5678 as a result. The number of zeros may change. Is there any chance to make VB do this?

Part and Inventory Search

Back
Top