Search:

Type: Posts; User: jpzinn; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Maud, the Amazon site is on sellercentral but it...

    Maud, the Amazon site is on sellercentral but it belongs to a business owner and is his inventory with his login information. What I have now works really well and saves me hours of time. I would...
  2. I did delete the boxes and there were also some...

    I did delete the boxes and there were also some checkboxes and comboboxes on the worksheet so I just deleted all the objects. I didn't need an if TypeOf section since I deleted them all. Thanks...
  3. Replies
    7
    Views
    395

    I will give that a look. Thanks for your...

    I will give that a look. Thanks for your suggestion.
  4. Yes, that is rather strange. Your file worked...

    Yes, that is rather strange. Your file worked fine for me too. I only changed a little bit of your code as you can see. Perhaps I had a typo at first. Bottom line, it works now and saves me hours...
  5. Replies
    7
    Views
    395

    I could just do an INSERT statement with the...

    I could just do an INSERT statement with the fields I need from there. The trouble is, there are several of those web pages for each age group and each region (Georgia (in my case), Southern,...
  6. I finally got it to work. My code is very...

    I finally got it to work. My code is very similar to the suggestion from Zeddy but there are some differences. Nonetheless, thanks to all who contributed. Apparently there are two types of...
  7. That looks great but when I run it, I get a...

    That looks great but when I run it, I get a message saying, "Unable to get the TopLeftCell property of the OLEObject class". I wonder if the textbox pasted from a web page is an OLEObject. When I...
  8. No one has any ideas on how to get the value of...

    No one has any ideas on how to get the value of the textbox? I've tried everything I can think of. From the above example, I've tried things like:
    MsgBox (Range("A2").Value) - I get a blank...
  9. Here is a sample of just the two cells. I want...

    Here is a sample of just the two cells. I want to take the value out of the textbox that is in A2 and put it into A1.
    I will have several thousand of these to do or I could just type the value...
  10. Replies
    7
    Views
    395

    Web Data Query Possibilities

    My son is playing a lot of tennis at an academy. All the students at the academy check their Junior Ranking which changes at least on a weekly basis based on tournaments played by themselves and...
  11. Text box value from a web page copy and paste

    We are needing to get some information from a table on a web page at Amazon. It is easy enough to copy and paste it into Excel. However, some of the important data comes in a textbox. I want to...
  12. Replies
    0
    Views
    572

    Office Suite Review Project

    Does anyone know of any kind of business scenario that I could use to tie the whole Office Suite together? I'm looking for some sort of capstone project that students would use to create marketing...
  13. Replies
    5
    Views
    1,209

    I don't know what NOS we were using four years...

    I don't know what NOS we were using four years ago but I was able to do it in previous schools....I'm not sure exactly what we tried because we were trying everything we could think of. I'll try...
  14. Replies
    5
    Views
    1,209

    Yes, there is email. Not sure what that has to...

    Yes, there is email. Not sure what that has to do with folder permissions on the network.
  15. Replies
    5
    Views
    1,209

    Restricting Folder Permissions

    I am teaching in a computer lab at a new school this fall where they are running Windows 7 for their network. I want to have a folder for each class where students can drop off assignments/tests but...
  16. Replies
    0
    Views
    668

    Change Email Properties?

    I recently bought a new laptop and of course it has Windows 8 on it. I took the advice of a recent column I read about using gmail and putting all email accounts there. However, I messed up and...
  17. Looks great. I guess that was too easy. J. P....

    Looks great. I guess that was too easy. J. P. Zinn
  18. Sorting by different columns automatically on two sheet tabs

    I'm looking for a way for two sheet tabs to contain the same information but be sorted by different columns. When data on the first tab is updated, I want the second tab to update automatically even...
  19. Thread: Sheet Tab Names

    by jpzinn
    Replies
    7
    Views
    1,115

    Yes, that will help. That is a fomula that a...

    Yes, that will help. That is a fomula that a person can copy down. Thanks
  20. Replies
    6
    Views
    1,129

    [SOLVED] I forgot to say in my last post that I don't know...

    I forgot to say in my last post that I don't know if there is a Worksheets.Count property but it seems that there should be....
  21. Replies
    6
    Views
    1,129

    [SOLVED] Would you put that code under a button or some...

    Would you put that code under a button or some key combination for a macro? Could you also just find out how many sheets there are and calculate it from there? For my example below, the subtraction...
  22. Thread: Sheet Tab Names

    by jpzinn
    Replies
    7
    Views
    1,115

    I already have the averages figured out on the...

    I already have the averages figured out on the individual sheets so I'll just have to put the label on my Summary sheet and then just point to where the average is. I was hoping there was a way to...
  23. Thread: Sheet Tab Names

    by jpzinn
    Replies
    7
    Views
    1,115

    That is close to being what I need. My scenario...

    That is close to being what I need. My scenario is that I have several classes (I'm a teacher) that have taken a test. I have all the students listed on the separate sheets with the class...
  24. Thread: Sheet Tab Names

    by jpzinn
    Replies
    7
    Views
    1,115

    Sheet Tab Names

    Is there anyway to refer to sheet tab names in a cell? I know you can refer to them with VBA code with something like Sheets(2).Name but I don't know how to put that in a cell. Say I have a large...
  25. Replies
    17
    Views
    3,732

    Retired Geek, Is there any advantage to using the...

    Retired Geek, Is there any advantage to using the Concatenate function over something like =A2 & " " & A3?
Results 1 to 25 of 87
Page 1 of 4 1 2 3 4