--
From: vivek agrawal vivek.agrawa...@gmail.com
Date: Tue, Jul 21, 2009 at 3:41 PM
Subject: Re: $$Excel-Macros$$ Re: Fill In Rows - Efficiency
IssueTo:excel-macros@googlegroups.com
Hi Dustin
I didnt go through your code but given below is the code which i feel does
the required work
reference.
Granted, using the IE workaround, one cannot control the file /
application being opened (I believe?), but its a fine workaround if
all you need to do is open it.
Dustin
Dear Group,
I currently have an excel spreadsheet that is used as an invoice
template. A loop goes through each customer and the invoice reflects
their customer specific information.
I am looking to move over to a mail-merge solution for this, and I
need to convert my excel worksheet to a word
No thoughts on this at all?
On Jul 2, 12:54 pm, Dustin dustin.ho...@gmail.com wrote:
Hi Everyone!
The following code works (not the best), but is inefficient, in my
opinion. It takes a few minutes to run, which is unacceptable. I am
looking for a re-think about how this can be done in order
Hi Everyone!
The following code works (not the best), but is inefficient, in my
opinion. It takes a few minutes to run, which is unacceptable. I am
looking for a re-think about how this can be done in order to make it
run faster.
The code looks at a table that is in order chronologically, but
I was not able to get this to work. I have heard that PDF creator has
hooks in it for this kind of thing, but I have not investigated that
yet.
On May 21, 11:05 am, Dustin dustin.ho...@gmail.com wrote:
I'll try that out and get back to you.
For this example, creating multiple print jobs
cannot seem to get this reference to read correctly though. Any
Thoughts? Thank you!!
Dustin
code:
Sub MoveColumns()
Dim countnonblank As Integer, myRange As Range
Set myRange = Columns(G:G)
countnonblank
print jobs (in your example).
Akhilesh Kumar Karna
On Thu, May 21, 2009 at 2:08 AM, Dustin dustin.ho...@gmail.com wrote:
Akhilesh,
Thank you for your response. Though that line is helpful, it is not
what I need. Maybe this simple example will help clarify:
Sub test()
For i = 0
the invoice is now a picture
instead of a table which can be edited.
I am certainly open to any other way to accomplish this as well.
What are your thoughts on this?
MUCH appreciated =] ... I love this group.
Dustin
away, my friends! lol.
On Apr 24, 7:31 am, Paul Schreiner schreiner_p...@att.net wrote:
Dustin,
it looks like you've had several replies to your question.
I tested it, and it looks like Habeeb's answer works just fine
(except for needing a couple of spaces:
Worksheets(RAW).Range(A3:CE4900
number for verification
End If
Loop
End If
End Sub
On Apr 21, 6:20 am, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Dustin,
Paste the following code into a module.
Sub InsertMissing()
Do Until ActiveCell.Value =
A = ActiveCell.Value
B
11 matches
Mail list logo