I have a Word 2003 document (form letter) that we have people open, fill out, then email to a specific list of people. I have code in the document open event that expands the envelope header and populates the recipients with the list of people. Problem is, I get the warning message that a...
Thanks everyone for your help. I've realized this is far too difficult for such a simple application. I merely like links on my desktop more than icons, so I thought it would be nice to be able to add them dynamically - I guess I'll just continue to edit the html and add the links that way...
Because I don't have a server. This is just a simple html page that I am using for my active desktop with links to documents on my computer instead of shortcuts (icons).
"It's more like it is now, than it ever has been."
Hello - I'm a vba guy, don't know javascript very well so I need some help. I have a simple page with a table that has three columns. Each cell in the right column has a hyperlink. I want to be able to type a url in a text box, hit submit, and the script would then add a row to the table...
I have an Outlook macro that opens an excel workbook when an email arrives to a specific folder - but if excel is already open it opens another instance - also if the desired workbook is already opened, it opens a read-only copy.
This is what I have:
Dim xlApp As Excel.Application
Dim wb As...
Hey all,
We just upgraded to office 2003. I had several excel 2000 workbooks/sheets that I sent out every day. I'd saved them with the recipients in the 'To:' field and then when I reopened them, the recipients were already there. Now with 2003, I can't do it. What's up?
Thanks...
Thanks Geoff,
I tried that, but it sends it as an attachment..I want it embedded in the email.
"It's more like it is now, than it ever has been."
Your code works fine, it just overwrites the previous data each time it goes through the IF..Then statement making it look as though it only works on the last one... Just add a line incrementing your variable 'pstRow' by one just before the 'End If'...
"For Each accRow In Range("C10:C14")...
I have a worksheet that is emailed by many to many daily. Many people still send it as an attachment rather than just the sheet. I've instructed till I'm blue in the face. I want a button that invokes the 'send to' command and allows the user to choose the recipient from their address book...
Try looking at the form's 'WhatsThisButton' property. Setting it to True will make the Question Mark appear next to the X on the title bar - but it seems like a task to get it to work - need to make help files...here's a link that kind of explains it... good luck...
I have a daily report in excel that needs data from web pages. I currently open/print the web pages, then enter the needed data in the report. I'd like to (at least) open and print the web pages for now...I don't really know where to start. Any help would be appreciated...
Thanks...
I think this will help..
=IF(A2>=$E$1+(A2<=$F$1),1999,IF(A2>=$G$1+(A2<=$H$1),2002,IF(A2>=$I$1+(A2<=$J$1),2004,"date not in range")))
Put your low and hi criteria dates in cells in say, E1 & F1 for 1999, G1 & H1 for 2002, and I1 and J1 for 2004 - (or wherever you want, but change the references...
I'm having trouble referencing range names in my code..
I have several ranges named "range01", "range02", "range03" etc.
I want to clear the contents of all the ranges and this is what I have, and it gives me an error 1004 'Method range of object _worksheet failed"
dim rname as string
For i...
Question:
I'm trying to load a variable array with numbers, say 100, then sort them, and load a second array with the lowest, next lowest, etc.
something like
load a variable array:
for n = 1 to 100
variable1(n) = rnd(1000)
next
Then sort them and load another variable so that...
Hi - I have an excel sheet with 5 image controls -
I'm loading pictures using the loadpicture method which works fine - however I have to send the pictures with the workbook - I'd like to have all the pictures on a seperate sheet in image controls, i.e. sheet2.image1, sheet2.image2, etc - then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.