Search:

Type: Posts; User: WERNER SLABBERT; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi Eric

    when you've had a chance to look at my original workbook, would you maybe guide me through the process of incorporating your code alongside my ( frankenHacked ) macro to make it all one...
  2. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hey Eric.
    i have downloaded your workbook, but i have been swamped at work the past week or so, as soon as i have a gap i will run through it to see.

    thank you again for you patience and help in...
  3. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi
    i'm running 2016. would it help if i send you a copy of my original workbook?

    https://mega.nz/#!UM9H0azQ!mrgw1ktSxK1t0iw7CSKMHih2APr8p_3TduSfPyf80yw
  4. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi Eric

    not to worry about a late response you know what they say, beggars and choosers .... thank you so very very much for all the time and effort you have put into this, i owe you a...
  5. Re: VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi Eric H

    firstly, thank you so very much for taking a look at my post.
    the macro i posted auto saves a single sheet pdf in a folder on my desktop called "Famous_Brands" and then if the sub does...
  6. VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi there ....
    i recently found this thread
    "
    https://www.mrexcel.com/forum/general-excel-discussion-other-questions/710212-vba-code-convert-excel-pdf-email-attachment.html"
    that does more or...
  7. Re: VBA code to convert excel to pdf and email it as attachment

    i also would like to implement this in my current macro but Veni,Vidi Velcro... it realy isn't as easy as my noob brain would make it out to be... here is my current macro (pieced together and all.....
  8. Re: VBA code to convert excel to pdf and email it as attachment

    I have been trying( to no avail) to apply these steps to my Macro... but hell it gets confusing... can i kinda aslo maybe ask some help... ? the PDF save section works great, its the sending the...
  9. Replies
    0
    Views
    122

    Stock Labels and info control

    here goes,

    i have a workbook with 2 sheets( at this stage. ) i would like to enter all the stock detail in the first into nice neat rows ( like excel does),
    and then have the second sheet...
  10. Re: DUMB Question: SUMIFS with only one date... but multiple entries in about 10000 rows...

    I don't seem to be getting my thoughts across , my brain and fingers are not working together today, here is a link to the workbook complete.

    http://www.filedropper.com/gvscounterbetaversion11
  11. Re: DUMB Question: SUMIFS with only one date... but multiple entries in about 10000 rows...

    F5 in mine is just a cell that contains the selected date to process. by means of a drop down calendar. ( mainly to be able to select a specific date to sum.)

    how can i send you a sample book?
  12. Re: DUMB Question: SUMIFS with only one date... but multiple entries in about 10000 rows...

    Hi Yongle
    Thanx for the reply, i have tried it, but to no avail. still just returns '0,00'

    i just changed your formula to my range names...
  13. DUMB Question: SUMIFS with only one date... but multiple entries in about 10000 rows...

    <tbody>
    Ref
    Company
    Date
    Company
    INV Number
    Sub Total
    Expenses
    Difference
    Grand Total
  14. Replies
    4
    Views
    234

    Re: VBA Input Error Loop

    Thank You Yongle
    These solutions work Fantastic. as a noob at VBa i amtrying to power through the fact that i know less than a doorknob about coding, but try and fail... so just a quick question, is...
  15. Replies
    4
    Views
    234

    VBA Input Error Loop

    HEllo Folks, Any Idea how i can loop through an input error with my code here? the user should only use numerical but would it be possible for vba not to error out and just simply clear the textbox...
  16. Re: Too Dumb for VBA UserForm... i need smart people help

    hi ranman256

    that is what google said is the simplest way to just clear the form for the next company.

    Ps: its actualy just a reset form button
  17. Too Dumb for VBA UserForm... i need smart people help

    :confused:

    ok so here i am trying to teach myself some vba ... but its a hard route. i need help making a money counter/ record keeping thingy...

    i have the userfom basically setup but i am...
  18. Replies
    3
    Views
    264

    Variable Error

    Hi My VB Errors out here
    *Compile error
    Variable not defined*


    Private Sub cmdNew_Click()

    Dim answer As Variant

    blnNew = True
  19. Macro to save & Close current xltm in current location

    Hi
    quick question, can you have a macro to save and close the current template in the location" desktop" or the like and as an xltm . also without the '1' eg: template1.xltm, if template.xltm...
  20. Replies
    2
    Views
    116

    Re: generation of invoice number

    Hi
    Would it be possible to change the "inv" number of the original copy and save it like that, ".xltm" with the original template name and in the original placeeg: desktop. as i have a number of...
  21. Replies
    0
    Views
    573

    Calendar Function

    :=DaysAndWeeks+DATE(CalendarYear;9;1)-WEEKDAY(DATE(CalendarYear;9;1);(WeekStart="Mon")+1)+1
    :
    Hi can this formula be changes to dynamically update the month as per Cell P3 ?
  22. Re: Print and Save to specific folder indicated by cel in worksheet.

    Thank you for your patience Alpha you are a MAMBA !:rofl:
  23. Re: Print and Save to specific folder indicated by cel in worksheet.

    it means that the code you provided me with creates a folder on the desktop according to the doc type, eg: invoice, quote etc. and saves the PDF to that folder using data in Cell "G11 & B9" (...
  24. Re: Print and Save to specific folder indicated by cel in worksheet.

    Would it be possible for the code to create a sub folder in the current folder according to data in G11 ?
  25. Re: Print and Save to specific folder indicated by cel in worksheet.

    Thank you AGAIN Alpha Frog. whole lot simpler than my initial formula.
Results 1 to 25 of 100
Page 1 of 4 1 2 3 4