Search results for query: *

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...

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

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?

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...

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...

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...

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...

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...

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...

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...

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?