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

    Need to Learn all About SQL

    Wow, thanks for the responses. I'll check them all out and see what works best for me. Baldy McFatfat "If at first you don't succeed, skydiving is not for you.
  2. BaldyMcFatFat

    Need to Learn all About SQL

    My company is wanting me to learn SQL language. I have a very minimal (and probably incorrect) knowledge of even basic programming; I have tinkered with VBA for excel and that is about it. What I have learned of VBA, I learned on my own while flipping through a 'For Dummies' book and...
  3. BaldyMcFatFat

    MS 2003 to 2007 Migration

    I have heard it said several times and places not to use ACTIVE____ at all. Is there a specific reason for this? I have had to self teach myself what I can about VBA and programmin in general, and therefore I am still ignorant in a lot of the nuances of it. Baldy McFatfat "If at first you...
  4. BaldyMcFatFat

    Variable ranges

    The basic purpose of this whole thing is to sort through data based on one column's data and move things around within the report. I was basically seeking to find out if it was possible to have a statement like ("A1:A14") have a variable in it. For Count = 1 to X is just telling the macro to...
  5. BaldyMcFatFat

    Variable ranges

    I will go ahead and insert the entire code up to the point of where I need help. And once again, I do apologize for my faults in this area. I am basically looking for it to select a range that goes down a certain number of rows from wherever it happens to be at that point in the macro (if that...
  6. BaldyMcFatFat

    Variable ranges

    Will I have to make the input box for the range seperate from other items at that point? I ask this cause the existing input box provides the variable for other functions within the code. I mainly want to know if I need to insert another input box into my macro. Baldy McFatfat "If at first you...
  7. BaldyMcFatFat

    Variable ranges

    I have an issue where I need a range to have a variable figure in one of the positions. This variable is set when running the macro by an input box. I am trying to learn all this VBA stuff with no actual programming background and I have been able to do most of it with the help of websites such...
  8. BaldyMcFatFat

    How to reference closed worksheet data in external workbooks in VBA

    I'm interested in what else will come up, because that might be able to help me in a couple reports I run for work. If anyone else has any suggestions, please provide. Baldy McFatfat "If at first you don't succeed, skydiving is not for you.
  9. BaldyMcFatFat

    Excel - Cannot use total function in protected sheet?

    Maisie, In regards to your question of how do you get notified that there is activity in your post, you can select to get an email notification whenever that particular thread recieves a post. you can select it right below where you type in the response. Regards, Baldy McFatfat "If at first...
  10. BaldyMcFatFat

    How to reference closed worksheet data in external workbooks in VBA

    You can do it either way. I'm just saying you don't need VBA. However, if you are more familiar with it, you could use some Do Loops with the LookUp included in the coding as a worksheet function. I was just saying it would probably easier to do the formula. Definitely less time consuming to set...
  11. BaldyMcFatFat

    Excel: Countdown Timer/Alarm [Not Rocket Science, still useful]

    I have outlook on my main desk top but can't access it from some of the other computers I may have to work from. The alram using Excel works great for me causing I just have it on a thumb drive that can plug into any computer and access. Thank you to both of you. Baldy McFatfat "If at first...
  12. BaldyMcFatFat

    How to reference closed worksheet data in external workbooks in VBA

    As long as you are moving data cell-forcell (meaning not trying to merge two cells into one) then you will be fine. the LookUp functions are extremely useful when it comes to grabbing data from one workbook to another. At work, I use the function to pull info from four pages all in different...
  13. BaldyMcFatFat

    Easy Way to Select and Delete Rows

    I thin he is saying you don't need code but can do it manually just as quick. Unless you have several hundred lines you would need to delete all at once, I believe manually is just as efficient. Baldy McFatfat "If at first you don't succeed, skydiving is not for you.
  14. BaldyMcFatFat

    How to reference closed worksheet data in external workbooks in VBA

    This actually doesn't need VBA at all. If I am understanding this correctly, you are trying to pull data from a complete seperate workbook. If that is so, you would just need to use a LookUp formula and specify the location of the worksheet you are attempting to access. I don't want to give...
  15. BaldyMcFatFat

    Sharing macros to use in any excel file on any computer.

    Not sure if this would help any, but do the other computers have their macro security set to medium or low? Baldy McFatfat "If at first you don't succeed, skydiving is not for you.
  16. BaldyMcFatFat

    No spellcheck for textboxes in Microsoft Word?

    The document being protected will stop you from doing any changes, even correct spelling. All you would need to do is unprotect it then spell check away. Had the same issue a little while ago. Hope this helps. "If at first you don't succeed, skydiving is not for you.
  17. BaldyMcFatFat

    Excel: Countdown Timer/Alarm [Not Rocket Science, still useful]

    Thanks Glenn "If at first you don't succeed, skydiving is not for you.
  18. BaldyMcFatFat

    Excel: Countdown Timer/Alarm [Not Rocket Science, still useful]

    xlhelp, This was extremely useful, thank you. Only one question. I'm the type of person that is usually looking through eighty things at once and sometimes get a little over excited when closing certain windows that I'll accidently close something I meant to stay open. With that in mind, is...
  19. BaldyMcFatFat

    LookUp formulas to bring two cells together

    Thank you all for the information. Thank you mintjulep for that advise. As skipvought stated earlier it was an equation question but I didn't know. So thank you to all. And please forgive my ignorance.
  20. BaldyMcFatFat

    LookUp formulas to bring two cells together

    I know this is a worksheet function and thoroughly know how to use it within a worksheet itself. I was wondering if there is a way to utilize this function in vba code to input a phrase where two sections of the code are from a seperate workbook altogether. I am looking to utilize vba to create...

Part and Inventory Search

Back
Top