Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. danomaniac

    MS Word - Add recipient without warning

    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...
  2. danomaniac

    Create Links?

    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...
  3. danomaniac

    Create Links?

    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."
  4. danomaniac

    Create Links?

    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...
  5. danomaniac

    Outlook vba test for excel already open

    Thanks Tony - Worked perfectly - "It's more like it is now, than it ever has been."
  6. danomaniac

    Outlook vba test for excel already open

    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...
  7. danomaniac

    Office 2003 - workbook doesn't remember recipients when saved.

    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...
  8. danomaniac

    For Each Copies Only Last Row

    ..Formal Training?" What's that? :) "It's more like it is now, than it ever has been."
  9. danomaniac

    send a worksheet and allow user to choose recipient...

    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."
  10. danomaniac

    For Each Copies Only Last Row

    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")...
  11. danomaniac

    send a worksheet and allow user to choose recipient...

    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...
  12. danomaniac

    Adding a Help Icon to the title bar of my userform

    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...
  13. danomaniac

    Open/print web page

    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...
  14. danomaniac

    Excel: value from between two dates

    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...
  15. danomaniac

    Trouble with variable range names in excel vba

    Thanks, Both ways work great. I appreciate it. &quot;It's more like it is now, than it ever has been.&quot;
  16. danomaniac

    Trouble with variable range names in excel vba

    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...
  17. danomaniac

    How do I sort variables in VBA?

    PHV, Thanks - That was exactly what I needed - works great! Thanks again. &quot;It's more like it is now, than it ever has been.&quot;
  18. danomaniac

    How do I sort variables in VBA?

    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...
  19. danomaniac

    Excel Image Array?

    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...
  20. danomaniac

    create table from listbox

    Excellent! Thanks very much! Works perfectly. Have a great holiday! &quot;It's more like it is now, than it ever has been.&quot;

Part and Inventory Search

Back
Top