Search:

Type: Posts; User: davewatson86; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    55

    VBA/SAP help

    Hi all

    i am trying to automate the creating and saving of invoices as a pdf.

    so far i have everything working up until it brings up the pdf preview and then i cant get it to work from there.
    ...
  2. Replies
    10
    Views
    151

    Re: Date issues

    will try this now cheer Fluff
  3. Replies
    10
    Views
    151

    Re: Date issues

    i copied this into cell R2 and it came up "Date" then when i dragged it down it came up with
    <tbody>

    <tbody>
    450965

    </tbody>


    </tbody>
  4. Replies
    10
    Views
    151

    Re: Date issues

    here is a small section of the data after i have run the find replace code

    <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col...
  5. Replies
    10
    Views
    151

    Re: Date issues

    Thanks Steve the fish but this just made the whole column #VALUE ! including the table header.
  6. Replies
    10
    Views
    151

    Re: Date issues

    100% some are DD/MM/YYYY and some MM/DD/YYYY i would post up the data but its 202996 rows of data
  7. Replies
    10
    Views
    151

    Date issues

    Hello all

    i have a report that is giving me dates in the format of DD.MM.YYYY i am trying to convert this to a date format that excel will work with but i am getting some strange tings happening....
  8. Replies
    9
    Views
    315

    Re: vba Appliation.onTime Running twice

    Thank you all for your reply's.

    i have changed the mtimertime to a global as @joeu2004 suggested and so far everything seems to me working as expected.

    Regards
    Dave
  9. Replies
    9
    Views
    315

    vba Appliation.onTime Running twice

    Morning/Evening all

    i have the below code set to update the data in a file every 5 min but it is running the Update sub twice one immediately after the other. i do not have the code...
  10. Replies
    5
    Views
    201

    Re: Top 50 List using Formulas

    Many thanks Eric W this worked a treat and has saved me heaps of time, absolute legend :cool:

    Regards
    Dave
  11. Replies
    5
    Views
    201

    Re: Top 50 List using Formulas

    The customer in column a and b will not show up more than once, helper columns is no problem as I can just hide them off to the side.
    Thank you for your help 👍
  12. Replies
    5
    Views
    201

    Top 50 List using Formulas

    Hello all

    i have this formula :{=LARGE((ROUND('Customer Data'!$Q$2:$Q$5000,5)+ROW('Customer Data'!$Q$2:$Q$5000)/10000000),ROW(K3)-ROW($K$3)+1)}
    this gives me a list of the top 50 spenders of a...
  13. Re: save range to notepad txt file. VBA

    Never mind im an idiot that needs more sleep
  14. save range to notepad txt file. VBA

    G'Day all

    i am trying to loop through some worksheets and export the data into a txt file.

    the below code works but i need it to save the file in the specified location rather than open it.
    ...
  15. Re: vba adding items to combobox from large list with multiples

    Many thanks for the reply Fluff

    i actually managed to Make this work



    Private Sub UserForm_Initialize()
    Dim sngLeft As Single
    Dim sngTop As Single
  16. vba adding items to combobox from large list with multiples

    Hello all

    i am trying to add all the unique values from my range with the below code.



    Private Sub UserForm_Initialize()
    Dim sngLeft As Single
    Dim sngTop As Single
    Dim ColNum, i As Integer
  17. Replies
    4
    Views
    137

    Re: split data in cells VBA

    thank you Peter_SSs

    that worked a treat
  18. Replies
    4
    Views
    137

    split data in cells VBA

    hi all

    this is probably really simple but all i have been ale to find is spit with commas etc.

    i have data that displays as below in column A



    <colgroup><col></colgroup><tbody>
    102269 ...
  19. Replies
    0
    Views
    84

    ActiveWorkbook.UpdateLink issue

    Hi all

    having an issue where i run the below code:



    Sub UpdateLinks()
    Dim Location As Variant
    Dim File_Name As String
  20. Replies
    2
    Views
    145

    sum--Frequency help

    hi all

    i have this formula: =SUM(--(FREQUENCY('1'!$B$7:$B$500,'1'!$B$7:$B$500)>0))

    which gives me the total amount of invoice numbers in the desired range.

    how can i tell it to only total...
  21. Replies
    3
    Views
    149

    Re: leading 0's problem vba

    Thanks for the reply fluff ill have to try it when I'm at work in the morning.

    Just a thought though would the interfere if I used a match formula for the part number?
  22. Replies
    3
    Views
    149

    leading 0's problem vba

    evening all

    having a bit of a problem i have some data that is exported as follows



    <tbody>
    000 012 280 B WEBBING
  23. Replies
    8
    Views
    152

    Re: vba- hiding ribbon issue

    Just tried your code for a third time and it worked perfectly.....
    No idea why it didn't work the first couple times but its all good now :cool:

    Thank you very much Jaafar Tribak for your help...
  24. Replies
    8
    Views
    152

    Re: vba- hiding ribbon issue

    so this is one step closer it now waits for the new workbook to open but after it is open fully i have to activate the workbook with the code and then go back to the new workbook before it runs the...
  25. Replies
    8
    Views
    152

    Re: vba- hiding ribbon issue

    as soon as i open the new workbook i get method ontine of object application failed.
Results 1 to 25 of 28
Page 1 of 2 1 2