Search results for query: *

The object I would like to paste data is MailItem created by: Set ol = CreateObject("Outlook.Application") Set MailItem = ol.CreateItem(olMailItem) Unfortunalety, this method isn't working for e-mails.

Runtime error appears at: MailItem.SetFocus :(

I don't know where to put it exactly :( Set ol = CreateObject("Outlook.Application") Set MailItem = ol.CreateItem(olMailItem) With MailItem .To = "Angelika.Bogumil@thomson.net" .CC = "Tomasz.Skura@thomson.net" '.To = "Danuta.Pawlowska@thomson.net" '.CC =...

Thanks! I already knew this solution but I want the data to be pasted exactly as they are in the sheet, i.e. borders, fonts so I mean to paste 'screenshot' from the certain cell range.

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 know it know! ActiveCell.NumberFormat :)

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

but I need to have it as a VB macro because I need to switch through all values in this autofilter and print a sheet with each autofilter criteria...

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?

many thanks! I will see it tomorrow as I have to check it in my company! :)

there is no possibility to have the same SO and CODE_ID so there is no problem!

vongrunt: what is "min" in your query for?

does each value of ID exist? Each from 1 to 3000000...

SQl Denis: I wrote that we could assume we have only two value to be easier. CODE_ID my have values from 1 to 25 (each value is a separate text comment line). But only the first two lines are concerned.

For some reason code_id can have 25 values :)

SQL Denis: sorry for this "excel sql query" :) I meant that this query returns data to excel :) gmmastros: Let's assume that CODE_Id may take only two values: 1 or 2.

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

But is it possible to insert this time repeated macro into my excel workbook (it would run some sql queries) and run other macros in excel? Or only time repeated macro in VB as exe file and macros in excel?

thanks a lot! But this macro to be run repeatedly in the background, that means that other macros can be run by a user and this macro to be run repeatedly is running irrespective of the others. Is it possible to run 2 macros in the same time?

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