• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by bradpallister

  1. B

    Email notification on file save

    Thanks Hui The only snag is that there would be in the region of 50-60 requisitions being raised every day, thus I only want a notification or alert sent, rather than the worksheet attached if that makes sense. The workbook is saved to a central location..
  2. B

    Email notification on file save

    Hi, this is a cross post http://www.ozgrid.com/forum/showthread.php?t=150920 as I am getting desparate for some help... I have a requisition template which currently has a button which saves a copy of the workbook to a specific location with the requisition number as the file name. On file...
  3. B

    Basic of VBA

    Dude you've already found the best website.. chandoo.org is free and you can learn quick
  4. B

    VBA Send as pdf

    thanks Vijay.. :)
  5. B

    VBA Send as pdf

    Hullo I need to send a worksheet by email ie SendEmail, but it needs to be as pdf. Any ideas? I need to keep the original xlxs format, but I will not need the pdf once its been emailled. Hope it makes sense, appreciateit if anyone has any sample code to sort. cheers
  6. B

    Quotes and Orders Pipeline / Forecast Chart

    Dear All I have a spreadsheet which consists of the following columns:- Column G: Date of Enquiry Column K: Quote Return Deadline Column L: Quote Value Column M: Order Probability (Percentage) Column S: Estimated Order Win Date Basically from these I need to create a few charts. Chart...
  7. B

    Information MsgBox

    Hi I have the following code: 'Sub RequisitionCompleteMsgBox() MyVar = MsgBox(Prompt:="Thank you. You have saved your Requisition successfully. You can now close this workbook without saving further.", _ Buttons:=vbInformation, Title:="Requisition Submitted!") MsgBox MyVar End Sub...
  8. B

    Input Box

    I am still learning the very beginning of VBA and enjoying some of the results I am coming out with. However I am stuck with a problem where I want a multi-field input box that when you enter the info, the information is pasted into the last row (i.e. not overwriting). How do I write the VBA...
  9. B

    SaveAs Macro Help

    brilliant, thanks Luke M
  10. B

    SaveAs Macro Help

    Hi I have a worksheet template (a type of form to be filled out). I would like to SaveAs a worksheet named after one particular cell (this cell is different with every form that is filled out), perhaps with a macro or similar. Anyone have any ideas how to do this? Many thanks
  11. B

    Button Controls?

    sorry, try https://rcpt.yousendit.com/1014151469/8b088b367342b1e2ae2bf25f97450c97 !
  12. B

    Button Controls?

    Hello I have a workbook wich contains a Quotes Register. I have uploaded this file here:- https://www.yousendit.com/download/RIRwSXQwQXBtMEt4dnc9PQ Ideally, what I wish to do is to fill out the relevant details and then hit a Submit button; this should then open up Quotation Form Template...
  13. B

    Template Protection

    I have saved a workbook as a template in a shared folder. The problem I have is that other users are using the template and then Saving As a template again - rather defeating the object! The template in query is actually just a simple form for technicians to fill out their reports on -...
  14. B

    Conditional formating using a formula.

    sorry, I am very thick.... what do you mean by set a format? Is this done in the formula or..? Thanks guys
  15. B

    Conditional formating using a formula.

    @hui Okey, thanks... but if say C4 was "Yes", how can I make that format row 4? Do I enter the formula in a separate cell or how do I do it? Thanks very much.. :)
Back
Top