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 SkipVought 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. jimbolove

    VBScript focus on Excel Alert

    Here's the alert box that I'm getting from excel, but nothing I try seems to focus on it. http://files.engineering.com/getfile.aspx?folder=13e9e39b-ed65-4ad7-b438-c2daa53c1ca0&file=Capture.JPG
  2. jimbolove

    VBScript focus on Excel Alert

    I can't seem to activate the box, it's visible but it's not letting me focus on it.
  3. jimbolove

    VBScript focus on Excel Alert

    Skip thanks for the response but if I turn off alerts then I don't get the error code. The script just continues to run. Whereas I don't want the script to continue if there is an error.
  4. jimbolove

    VBScript focus on Excel Alert

    My code is using errorcodes generated from Excel. So I don't want to turn off alerts. However I'm having an issue and want to answer the Excel Alert caused by the save error "File already exists, Do you want to save over?" message and want to answer "No". Is this possible? Below is some of my...
  5. jimbolove

    Determining Values to be paid

    I put the table in to simplify things the listing is quite cumbersome as it's got more than 2000 entries on the sales side (there could be as many as 20 for each customer) and yes there are invoice numbers associated with each sales entry but when the customer submits payment they don't...
  6. jimbolove

    Determining Values to be paid

    Since you all were so helpful on my last question, maybe you can help point me in which direction I should go on this one. It's way more complex so I thought about using access or excel and am leaning toward excel. I want to set up a worksheet/table for Sales commissions and billings. We may...
  7. jimbolove

    Help Converting Date to Period

    Thanks, ya'll are awesome.
  8. jimbolove

    Help Converting Date to Period

    Hi, can anyone offer assistance in changing the date to show as a Period. What I'd like to show is between 5/16 and 6/15 would be period 5. And then 6/16 to 7/15 would be Period 6 and so on it should be pretty easy to do I'm hoping.

Part and Inventory Search

Back
Top