Re: $$Excel-Macros$$ Macro to clean up file

2010-07-24 Thread JD
How do I attach? I placed in file section of MS EXCEL AND VBA MACROS. On Jul 24, 5:35 am, Sandeep Kumar Maurya wrote: > Hi JD, > > You forgot to attach file. > > Thanks & Regards > Sandeep > > On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote: &

$$Excel-Macros$$ Macro to clean up file

2010-07-23 Thread JD
I am looking to clean up a file that gets sent to me weekly see "example file.xlsx" on file page. The file may look like the first tab the 1st week it is sent to me and like the second tab the 2nd week it is sent to me but I need it to look like the 3rd tab all the time for import into database. Ca

$$Excel-Macros$$ Re: Shortcut for trace dependents

2009-07-09 Thread JD
gt; opening brackets" > > Regards, > Vivek Agrawal > Contact No. +91--154-077 > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com  - Saving energy-Save Earth > > On Thu, Jul 9, 2009 at 11:29 AM, JD wrote: > > > Can anyone tell me a short cut key for &#

$$Excel-Macros$$ Shortcut for trace dependents

2009-07-08 Thread JD
Can anyone tell me a short cut key for 'trace dependents'?? The shortcut key for 'trace precedents' is cntrl + [ for those who don't know. Look forward for a shortcut.. :-) Thanks and regards, Jaydeep --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Macro to print sheets to different printers

2008-11-10 Thread JD
er name >     Sheets("Sheet 2").PrintOut Copies:=1 > >      Application.ActivePrinter = "Lexmark 615" >      Sheets("Sheet 3").PrintOut Copies:=1 >      Sheets("Sheet 4").PrintOut Copies:=1 > End Sub > > On Sat, Nov 8, 2008 at 12:08 P

$$Excel-Macros$$ Macro to print sheets to different printers

2008-11-08 Thread JD
I would like to print sheet2 to one printer and sheet3 and 4 to a different printer. Using a macro how would I go about doing this? Can it be done with one macro or do I need to setup different macros. Neither of these printers are the default printer on the computer. --~--~-~--~~