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 derfloh 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. Baggie

    Want to open a file on a network via a hyperlink in a cell and passing in a password

    Hi Skip, Finally got back to this and glad to say it worked like a charm. Just had to add the cancel = True part inside the If statement. Wish I could change the title of this thread in case anyone else is looking for a solution like this. Thanks so much for your help. A star for you! Baggie
  2. Baggie

    Want to open a file on a network via a hyperlink in a cell and passing in a password

    Hi Skip, Thanks for your response. I will give this a try and let you know how it goes. As far as the workbook object is concerned I chalk that up to inexperience. Are you saying that I don't need to assign it to anything? I can just use the workbook.open...etc without setting it to wkb1...
  3. Baggie

    Want to open a file on a network via a hyperlink in a cell and passing in a password

    I have continued researching and now I have found the workbook doubleclick event. I'm thinking that this may be better. However, now I need to limit the range to just the column with the network file pathways so if they double click on any other area it wont' fire off the event. Anyone have an...
  4. Baggie

    Want to open a file on a network via a hyperlink in a cell and passing in a password

    Hi, I have been searching for awhile but cannot find what I am trying to perform. I haven't programmed in VBA in awhile and never in Excel VBA, so I'm not handy with the objects, events etc. in it. I have a spreadsheet with a bunch of summary information (about 500 rows) in it that some auditors...
  5. Baggie

    Obtaining Latest Entry in Employee History Table

    Hi Charliy, Thanks for your response. First thing I need to do is get the last termination date out of the History table. There can be multiple termination dates for some employees and I need to find the last entry (and it should match the term date in the Employee table). SO, I want to know if...
  6. Baggie

    Obtaining Latest Entry in Employee History Table

    Hi, I'm relatively new to Crystal Reports. I have an issue I'm hoping someone can advise me on. I did search around on this site to try to find an answer but didn't see one that helped. So, first of all, I am on CR Version 12 SP 2. I work for a hospital HR department. I am trying to find the...
  7. Baggie

    Wondering About Compatibility Problems With Access XP and Excel 2007

    MajP Thanks for your response and the link to the article. I got it resolved by upgrading to Access 2007 and the program works fine now.
  8. Baggie

    Wondering About Compatibility Problems With Access XP and Excel 2007

    Hello all, Just wondering if anyone has experienced anything like this. I have an XP database where I have written some VBA code to create, manipulate and then send out (via Outlook) some Excel spreadsheets. It worked perfectly last month when our company had Excel XP. This month we have been...
  9. Baggie

    How to read a Word file into outlook email body via access vba

    Greg, That did it! Thanks so much!
  10. Baggie

    How to read a Word file into outlook email body via access vba

    Hello all, I have borrowed some code from thread 705-1367295 which shows how to send an email via Outlook from Access. I am having trouble with one item so far and that is where the program declares this variable: Dim fso As FileSystemObject I get a compile error: User-defined type not...
  11. Baggie

    What's a Data Analyst

    To all: Thanks for your input regarding my question. Sounds like this job may just be the same Excel sheet, different data. Ha! Ok, bad pun. I still haven't received any description on the job so I think they just think I'm going to take this on faith. Well, I'm starting to circulate my resume...
  12. Baggie

    What's a Data Analyst

    Hi all, I am working at an organization as an HRIS (Human Resource Information Systems) Analyst for some time now. The company has just asked me to move to the Finance area in about a month and be a "Data Analyst". They haven't supplied any job description yet so I've been out on the net and...
  13. Baggie

    Combination Chart (Bar and Scatter)?

    Thanks Skip, I'll give it a try!
  14. Baggie

    Combination Chart (Bar and Scatter)?

    Hi, I've looked around on this site and haven't seen this question posed. So, I'm going to pose it. I'd like to impose a scatter chart over a bar chart. Is that possible? Here's a bit of the detail. I have pay range data on a bar chart (actually a stock chart) So say the pay range starts at $5...
  15. Baggie

    How to open an excel file (7.0) from access 97

    FortisDragon Try this: Dim appUserFile As New Excel.Application appUserFile.Workbooks.Open ("C:\YourExcelFilename") appUserFile.Visible = True Set appUserFile = Nothing HTH
  16. Baggie

    Trouble with Access to Excel Automation

    PROBLEM SOLVED! It turns out that the CopyFromRecordset method will only work with an ADO recordset even though the help file includes DAO. In case anyone is interested here is a copy of the code that now works for me. The Access Cookbook was my major source of inspiration. I highly recommend...
  17. Baggie

    Trouble with Access to Excel Automation

    Rob, Skip I bought a book called "Access Cookbook" chock full of sample code. It has a demonstration of a problem similar to mine here. I have to go to a meeting now for the rest of the day, but I'll start banging away again tomorrow. I'll let you know what happens if you're...
  18. Baggie

    Trouble with Access to Excel Automation

    Skip, Thanks for your reply. Unfortunately I'm still getting Error '430' Class does not support Automation or does not support expected interface. I'm still not sure if I'm setting the range object correctly (How can I tell?, it doesn't give an error at that line.) But the error occurs on the...
  19. Baggie

    Trouble with Access to Excel Automation

    Dear Forum members: I'm having some trouble with Access to Excel automation. This site has been extremely helpful. I've searched for many a solution on this site and found many answers. Now I need to ask a specific question. I'll be as brief and to the point as possible. Objective: Create a...
  20. Baggie

    want to create a scoreboard in excel

    Mudstuffin, Much obliged! I look forward to seeing it. My e-mail is steve.haackABC123@target.com Take out the ABC123 and that is my e-mail address. Thanks again!

Part and Inventory Search

Back
Top