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 TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by eit09

  1. eit09

    IBC 2902.3.2 location of toilet facilities in occupancies other than malls

    IBC section 2902.3.2 states the path to travel to facilities shall not exceed a distance of 500 ft, but then in the next paragraph there is an Exception stating the maximum distance can be exceeded if approved. The building in question has expanded multiple times and now the path to travel to...
  2. eit09

    Macro error when cells locked

    Agent666, That suggesting worked perfectly thanks for pointing that out. JG2828, Thanks for the info on file names and creating a valid attachment link.
  3. eit09

    Macro error when cells locked

    I am trying to create a template that once a few cells are filled in the user can run a macro and auto populate specific named sheets to enter specific info. To use this spreadsheet the user is required to enter specifics (Series/Chute#) in Cells A2&B2,A3&B3.... within the summary sheet then...
  4. eit09

    VBA Code for selecting specific sheet names within specific workbook.

    vcolella, This works well thank you. Do you know if your able to also include a drop down list within the Input box versus typing? Within Cell C1 in the Loads worksheet I have a drop down list of all active worksheets and would like to try to take the input box one step further?
  5. eit09

    VBA Code for selecting specific sheet names within specific workbook.

    I would like to modify the following code so I don’t need to step into and edit the sheet names every time I use it. Currently I step into the vba and change the sheet name to one of the 10 sheet names within the workbook(W-shape in 3 places as shown highlighted below for this example). Is there...
  6. eit09

    VBA within Outlook Compile error

    Agent666, Thanks for trying on your machine at least I know the code works. I did check my settings and they were the same so removed 365 and reinstalled with no luck.
  7. eit09

    VBA within Outlook Compile error

    I have used this coding bellow in the past but now I am getting a Compile error. looking for some guidance how to change this coding to get around the compile error. Sub Sendoffice365invoice() Dim myItem As Outlook.MailItem Dim myolApp As Outlook.Application Dim myRecipient As Recipient...
  8. eit09

    AASHTO 2012 Side resistance for drilled shafts into rock

    BigH, Thanks for the references! There was no relevance for me to post the quor pa values not sure what I was thinking!
  9. eit09

    AASHTO 2012 Side resistance for drilled shafts into rock

    BigH, The quis actually just = 19000 psi. Thanks for the attachment! What reference does the attachment come from?
  10. eit09

    AASHTO 2012 Side resistance for drilled shafts into rock

    To resist uplift to a footing that sits directly on solid granite my customer plans on drilling a 5.5" diameter hole, 10 feet deep with 2 #8 rebars embedded into the hole with 4000 psi concrete.I came accross equation 10.8.3.5.4b-1 on page 10-137 of 2012 AASHTO book to calculate to calculate the...
  11. eit09

    Creating a Macro in outlook to schedule weekly meetings

    @MintJulep, Slap my head on the End Sub! THanks that really cleans this macro up!!
  12. eit09

    Creating a Macro in outlook to schedule weekly meetings

    @IRstuff, I am not sure what you mean at missing MJ's point and which one sticks. All three emails are placed in the meeting invite once I run this macro the way it is written. How would you write the code below to be more correct? Set myRequiredAttendee =...
  13. eit09

    Creating a Macro in outlook to schedule weekly meetings

    @MintJulep, That would certainly clean things up, but when I change the code (below) I receive a compile error when I try to run it. Sub Sendofficeweeklymeeting() Dim myItem As Object Set myItem = Application.CreateItem(olAppointmentItem) With myItem .MeetingStatus = olMeeting .Subject =...
  14. eit09

    Creating a Macro in outlook to schedule weekly meetings

    @MintJulep, If you look at the lines before 86chevys10 I have 2 other email recipients. Sub Sendofficeweeklymeeting() Dim myItem As Object Dim myRequiredAttendee As Outlook.Recipient Set myItem = Application.CreateItem(olAppointmentItem) myItem.MeetingStatus = olMeeting myItem.Subject =...
  15. eit09

    Creating a Macro in outlook to schedule weekly meetings

    Below is the code I found to work :) Sub Sendofficeweeklymeeting() Dim myItem As Object Dim myRequiredAttendee As Outlook.Recipient Set myItem = Application.CreateItem(olAppointmentItem) myItem.MeetingStatus = olMeeting myItem.Subject = "Weekly Meeting" myItem.Location = "Front...
See more

Part and Inventory Search

Back
Top