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!

Register Log in
  • Congratulations Chriss Miller 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. haeddy

    Excel Question

    I think the reason it wasn't working is because they were separate workbooks. When I figured out I had to add the data as a sheet to the form workbook it worked. And yes - he deserves a big star!
  2. haeddy

    Excel Question

    Thank you for all your patience and assistance. One last question - is it possible to have it sent to a file instead of the printer?
  3. haeddy

    Excel Question

    I swear the error was on that statement and I do Debug. I don't know what happened because it's on another one now and I didn't change anything. When I put the SET ws Form in front of the Set wsdata it says subscript out of range.
  4. haeddy

    Excel Question

    Function RangeName(sName As String) As String RangeName = Application.Substitute(sName, " ", "_") End Function Sub MergePrint() Dim wsForm As Worksheet, wsData As Worksheet Dim sRngName As String, r As Long, c As Integer Set wsData = Workbooks("Total Compensation...
  5. haeddy

    Excel Question

    Ok - got through that one. Now it says "Run time error 91: object variable or with block variable not set" on With wsdata.cells (1,1).current region.
  6. haeddy

    Excel Question

    I already had it in the letter but maybe I had something typed wrong. I copied and pasted it again and now it's giving me "run-time error '9': Supscript out of range". UGH! This is what I put in the letter: Function RangeName(sName As String) As String RangeName =...
  7. haeddy

    Excel Question

    I couldn't find the RangeName function in the FAQ - I just googled it. Can you help me with that? 1) Where do I put that code? 2) I removed the EMP_ID column. The reference from wsdata in that statement needs the .Value property, yielding the value 6133 - I have no idea what you're...
  8. haeddy

    Excel Question

    Yes. They're in the data file and the letter.
  9. haeddy

    Excel Question

    I already did the range names in my data file. I highlighted the column and clicked on Define Name and typed in a name. I double checked and they're all still there and there are no spaces in them. Holly
  10. haeddy

    Excel Question

    Thanks Skip. I got that one fixed. Now I'm getting: Compile error: sub or function not defined and it's highlighting RangeName.
  11. haeddy

    Excel Question

    Compile error: Ambiguous name detected: Mergeprint
  12. haeddy

    Excel Question

    I'm getting an ambiguous name error on MergePrint. Below is what I put in Visual. https://res.cloudinary.com/engineering-com/raw/upload/v1464192687/tips/Doc5_ib0bh8.docx
  13. haeddy

    Excel Question

    I'm trying to do total compensation report for our employees. I've created a database in Excel and I created the letter in excel. How can I merge the two files to create the letters? I have Excel 2013.
  14. haeddy

    Mail Merge 2 Excel Files

    I'm trying to do total compensation report for our employees. I've created a database in Excel and I created the letter in excel. How can I merge the two files to create the letters? I have Excel 2013.
  15. haeddy

    Null Value for Date Field

    This is the Select Expert Record formula I'm using. {PS_HEALTH_BENEFIT.COVERAGE_ELECT} = "E" and {PS_ALL_EMPLOYEES.AL_EMPL_STATUS} = "A" and isnull({PS_HEALTH_BENEFIT.COVERAGE_END_DT})
  16. haeddy

    Null Value for Date Field

    Yes SkipVought. I have an Employee Status in the table.
  17. haeddy

    Null Value for Date Field

    I'm trying to create a report that will show the most current health and dental insurance coverage our employees have. The report is perfect except it is showing employees that no longer have coverage and I can't get it to eliminate these employees. I have a Database Field called Coverage End...
  18. haeddy

    Crystal Report Question

    Hope someone out there can help me with this report. I'm trying to create a report that will show the most current health and dental insurance coverage our employees have. The report is ommitting coverage when there are diffferent effective dates i.e. when the health and dental insurance...
  19. haeddy

    Reportsmith Question

    It worked!! You're wonderful!! Thank you soooooo much!!
  20. haeddy

    Reportsmith Question

    Thank you soooo much for your help! It would have taken me three lifetimes to come up with that! I'm having a slight problem though. When I go into the Selection Criteria and change the criteria from data field to formula, it wants another field. It says "formula _____ is equal to text...

Part and Inventory Search

Back
Top