$$Excel-Macros$$ VBA event to stop on a word page an resume

2013-10-14 Thread Amit Kumar
Hi Folks, The situation is - When we start the server, bmp images and text is downloaded dynamically(run time) to a folder, and are pasted to microsoft word. This is a continuous proces, which means the bmps and text gets downloaded from another server and is continuously pasted in the Word.

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 1 Message in 1 Topic

2013-10-14 Thread Samuel laryea
I need help on excel On Oct 13, 2013 11:34 PM, excel-macros@googlegroups.com wrote: Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics - Excel to OpenOffice? #141b42bd163b3328_group_thread_0 [1 Update] Excel to

$$Excel-Macros$$ MS Excel 2003 to 2010

2013-10-14 Thread Prashant Pednekar
Dear friends We are migrating from MS Excel 2003 to Excel 2010 Dose any one of you has Menu and commond by command comparion in both version.s i.e. 2003 2010 Data Validation ??? Else is anyone has related material. Regards Prashant -- Are you

RE: $$Excel-Macros$$ Two spreadsheets , compare and produce a 'difference' spreadsheet

2013-10-14 Thread Ravinder
Give some example..with xlsx file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of garfin.in...@gmail.com Sent: Monday, October 14, 2013 11:09 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Two spreadsheets , compare and produce a

Re: $$Excel-Macros$$ Need some help modifying a copy and paste routine

2013-10-14 Thread Justin Pulley
It is somehow attached to the first post in the thread, you'd have to expand all threads to see it. On Saturday, October 12, 2013 7:36:09 AM UTC-7, ashish wrote: attachment is missing On Fri, Oct 11, 2013 at 3:48 AM, Justin Pulley maveric...@gmail.comjavascript: wrote: Was the

Re: $$Excel-Macros$$ Need some help modifying a copy and paste routine

2013-10-14 Thread ashish koul
try this Sub cop_dates() On Error Resume Next Sheets(ATS Data).UsedRange.Clear Dim i As Long Dim dt As Date dt = #4/16/2013# Sheets(Raw ATS Data).Range(a1:s1).Copy Destination:=Sheets(ATS Data).Range(a1) For i = 2 To Sheets(Raw ATS Data).Range(a1048576).End(xlUp).Row If Sheets(Raw ATS

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 1 Message in 1 Topic

2013-10-14 Thread ashish koul
can u please post ur query with sample file On Mon, Oct 14, 2013 at 12:32 PM, Samuel laryea heavenslar...@gmail.comwrote: I need help on excel On Oct 13, 2013 11:34 PM, excel-macros@googlegroups.com wrote: Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics

Re: $$Excel-Macros$$ Two spreadsheets , compare and produce a 'difference' spreadsheet

2013-10-14 Thread garfin . inbox
Oops sorry.. A small cut-down example , along with the manually created 3.xlsx output that i'd like to have automated has been added to my original post. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-14 Thread Bill Q
My apologies Basole, I was out of town for a few days. I will try out your recommendations tomorrow as it appears that you have been successful. I will keep you posted. Thanks again. On Tuesday, October 8, 2013 5:03:54 PM UTC-4, Basole wrote: Bill, enable reference, as indicated Ashish

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-14 Thread Basole
Ok Bill, any questions let me know ... Em domingo, 6 de outubro de 2013 17h34min31s UTC-3, Bill Q escreveu: Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever x amount of

Fwd: $$Excel-Macros$$ MS Excel 2003 to 2010

2013-10-14 Thread Prashant Pednekar
Good morning all. Sorry ! I did not used *Please help.* in my earlier mail. Request you to help me. Thanks Prashant. -- Forwarded message -- From: Prashant Pednekar prashant...@gmail.com Date: Mon, Oct 14, 2013 at 3:21 PM Subject: $$Excel-Macros$$ MS Excel 2003 to 2010 To:

$$Excel-Macros$$ daily data into weekly data

2013-10-14 Thread asdhhc
Columns(1).Insert With Range(b2, Range(b Rows.Count).End(xlUp)).Offset(, -1) .Formula = =if(and(weekday(b2,2)weekday(b3,2),b3),1,) .Value = .Value On Error Resume Next .SpecialCells(2, 1).Offset(0, 1).Delete Shift:=xlUp .SpecialCells(2,