Recent content by Abouya

Others will be using it as well and i dont want them to see this spreadsheet. This for will be invoked from the main spreadsheet. Thanks for responding.

Hello, I'm trying to find a solution for updating company contact info/phone/email etc using a form in excel. First, I use the Combobox to find the company and records will show using Vlookup. how I can change/update the records of selected company and sending them to the spreadsheet? I...

Hello, I'm trying to find a solution for updating company contact info/phone/email etc using a form in excel. First, I use the Combobox to find the company and records will show using Vlookup. how I can change/update the records of selected company and sending them to the spreadsheet? I...

thanks, that did the job. i also added this after some search on the internet: "<P STYLE='font-family:Times New Roman;font-size:15'>" & "<br><B>Hello,</B>" & "<br>" & "<br>" & "<i>PO Requisition #</i>" & " " & Range("I5") & "<br>" & "<i>Vendor: </i>" & Range("C5") & "<br>" & "<i>Total: </i>$" &...

Hello, I'm working on this excel spreadsheet vba to send active sheet as pdf and it works fine, except .body formating which doesn't look right. Can someone please help me format it so it looks nicer? The "Hello" looks much bigger and "thanks," looks weird! strbody = "Hello," & "<br>" &...

Great solution. I will post the working code tomorrow for others to benefit from as well. Again, thank you so much.

I don't have such code? where did you see this? Thanks.

Good afternoon, I'm trying to alter this below code to send the spreadsheet as pdf. Thanks for helping me out. Sub Mail_Click() Dim Msg As String, Ans As Variant Dim wb1 As Workbook Dim TempFilePath As String Dim TempFileName As String Dim FileExtStr As String Dim OutApp...

Hello, I don't get why this code doesn't work, could someone help: Sub saveaspdf() Dim TempFileName As String 'Prompt for file destination With Application.FileDialog(msoFileDialogFolderPicker) If .Show = True Then DestFolder = .SelectedItems(1)...

Thanks for responding. How do i use the vlooup function here. could you please help me. I have a table that holds employees names and their approval limits. Names are on ApprovedAmounts!A2:A16 and approval limits are on ApprovedAmounts!B2:B16. Plus, ApprovedAmounts!c2:c16 that mentions X2 or...

Thanks Sneuberg for responding. i have a table that holds employees names and their approval limits. Names are on ApprovedAmounts!A2:A16 and approval limits are on ApprovedAmounts!B2:B16. Plus, ApprovedAmounts!c2:c16 that mentions X2 or X1 supervisors for each employee. Now, on spreadsheet "PO...

I would love to prompt users " do you want to save(or not to) the file I'm sending on the attachment after they get the message: "MsgBox "Your File was successfully sent to" & " " & Range("B28") & " " & "and" & " " & Range("B29")". is there a way to do this? Here is the code i'm using: Sub...

I'm getting the result using this nested if now: =IF(AND(H6=ApprovedAmounts!A2,J26>ApprovedAmounts!B2),ApprovedAmounts!C5,ApprovedAmounts!C4) However, this checks for one employee, how i can add this condition if H6=ApprovedAmounts!A3,J26>ApprovedAmounts!B3 and more conditions. They all have...

Hello, I have this excel form in wich a user/employee will request a purchase order. there is a button to send that email directly to the designated supervisors depending on the approval limits. Say for example I'm A and i'm filling a PO. This if formula will check if the total is under or...

Works great. Thank you so much. this is all the code i'm using: You know if there is a way to give a selection of email addresses to chose from (range) instead of a predefined email like i have bellow ".to = "XXXXX@XXXX.com"? Sub Mail_Click() Dim Msg As String, Ans As Variant Dim wb1 As...