$$Excel-Macros$$ Need some vba code to copy and paste automatically when the file is opened, only last day of month

2015-09-25 Thread Justin Pulley
the data I am copying always lies in A1:F5 On the last day of the month I need to copy B1:F5 to B10:F15 and put the month name in B9; after that it would go to the next empty column (in this case E) and paste again for the next month. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

$$Excel-Macros$$ Re: Continuation of VBA for Excel to Word

2013-10-22 Thread Justin Pulley
Still getting error 462 every other time I run the macro. not sure how to beat this error. On Monday, October 21, 2013 8:21:02 AM UTC-7, Justin Pulley wrote: > > I don't know how to mark something uncompleted. > > The code works every other time. > > > > Sub Cre

$$Excel-Macros$$ Continuation of VBA for Excel to Word

2013-10-21 Thread Justin Pulley
I don't know how to mark something uncompleted. The code works every other time. Sub CreateReportPDF() Dim wdapp As Word.Application Dim wddoc As Word.Document Run CopyData Set wdapp = Word.Application Set wddoc = wdapp.documents.Add Application.ScreenUpdating = False wdapp.Visible = True

Re: $$Excel-Macros$$ VBA for Excel to Word

2013-10-18 Thread Justin Pulley
Nevermind, I got it. For some reason there was a bunch of used rows in there. On Friday, October 18, 2013 7:21:50 AM UTC-7, Justin Pulley wrote: > > So I am going to have to upload the entire sheet I guess because when I > run your code in the full workbook I end up with 5 blank pages

Re: $$Excel-Macros$$ VBA for Excel to Word

2013-10-17 Thread Justin Pulley
e (coding). > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Justin Pulley > *Sent:* Thursday, October 17, 2013 12:02 AM > *To:* excel-...@googlegroups.com > *Cc:* koul@gmail.com > *Subject:* Re: $$Excel-Macros$$ VBA

Re: $$Excel-Macros$$ VBA for Excel to Word

2013-10-17 Thread Justin Pulley
ps.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Justin Pulley > *Sent:* Thursday, October 17, 2013 12:02 AM > *To:* excel-...@googlegroups.com > *Cc:* koul@gmail.com > *Subject:* Re: $$Excel-Macros$$ VBA for Excel to Word > > > > I have manually move

$$Excel-Macros$$ VBA for Excel to Word

2013-10-16 Thread Justin Pulley
Is it possible to write a macro that exports two worksheets out of a workbook to Word? currently I export to .pdf which I thought was fine, but my boss asked for an export to word. The challenge is one of the worksheets contains charts that need to go with it. current code ThisWorkbook.Shee

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 > > > wrote: > &

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

2013-10-11 Thread Justin Pulley
I guess what I am asking is way more complex than I thought, I can't seem to get a push in the right direction anywhere. -- 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 forum @ https://www.facebook.com/discu

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

2013-10-10 Thread Justin Pulley
Was the attached file what you were looking for? On Thursday, October 10, 2013 8:44:55 AM UTC-7, ashish wrote: > > can u pls share a sample workbook? > > > On Thu, Oct 10, 2013 at 9:05 PM, Justin Pulley > > > wrote: > >> Here is my current code: >> >

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

2013-10-10 Thread Justin Pulley
Here is my current code: Code: Dim sh As Worksheet, sh2 As Worksheet Dim LastRow As Integer Dim LastRow2 As Integer Set sh = Sheets("Raw ATS Data") Set sh2 = Sheets("ATS Data") With sh2 Range("A2:H" & Rows.Count).Clear End With LastRow = sh.Range("A1").End(xlDown).Row sh.Range("A1:H" & La