dcsimg

Search:

Type: Posts; User: kris01

Page 1 of 2 1 2

Search: Search took 0.03 seconds.

  1. Replies
    12
    Views
    470

    Re: Txt file convert to .xls

    Didn't seem to work buddy

    The code now produces this file. Which is correct. I just need to import it into my file under the tab 'expense'

    Workfile I need to import into.

    N:\My...
  2. Replies
    5
    Views
    300

    Re: Error message 400

    I changed the range as you mentioned earlier, but I'm still getting an error message Run time error 424

    on this part of the code..

    Set rngCopy =...
  3. Replies
    12
    Views
    470

    Re: Txt file convert to .xls

    Hello,

    Sorry for the delay in coming back. Been on holiday.


    I added the below code as below, but it simply creates a new workbook and re-names the tab as 'Expense'


    ...
  4. Replies
    12
    Views
    470

    Re: Txt file convert to .xls

    Thanks Chris.

    That worked a treat. How do i change it slightly so that I import the newly converted file into my workbook under worksheet 'Expense'

    Current workbook is called Kris...
  5. Replies
    12
    Views
    470

    Re: Txt file convert to .xls

    does anyone know how to import this file?
  6. Replies
    5
    Views
    300

    Re: Error message 400

    [QUOTE=westconn1;5391867]please use code tags when posting code, this keeps the formatting and makes it much easier to read and find problems

    Code tags? how?

    which is the line that give the...
  7. Replies
    5
    Views
    300

    [RESOLVED] Error message 400

    Hello,

    I'm getting an error message '400' when running the below code.

    Anyone know what this error message is and how I can fix it?

    Thanks


    Sub ImportFidessav1()
  8. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Ok finally got it sorted. Thank you for your patience and help.
  9. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Ok sorry there was a typo in my coding.

    I can now see a file saved down in my folder. However its still saving down an empty work book. Do I need to specify what worksheets to save?

    Also,...
  10. Replies
    12
    Views
    470

    Re: Txt file convert to .xls

    as requested....168895
  11. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    ok I've been testing this code....


    Sub Savev1()

    Dim Thiswb As Workbook
    Set Thiswb = ActiveWorkbook
    Workbooks.Add

    myFilename = myPath & Range("A1").Value & " Daily Revenue " &...
  12. Replies
    12
    Views
    470

    Txt file convert to .xls

    hello.

    I wish to convert a txt file that is saved down in my folder into a .xls file.

    Before I do this however I need to sort by columns and I wish to sort by using the delimited file type -...
  13. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Current file is .xlsm and I want to save as a .xls
  14. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Hello.

    Apologies for late replay.

    Changed the code to the below and still not working.

    Error message on last line.. Run time error 1004.

    Still not saving a copy of the work...
  15. Replies
    18
    Views
    729

    MsOf10 Re: Send table on email

    are missing the sheet's "summary" reference from the above?
  16. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Code is breaking with a run time error '1004

    Application-defined or object defined error

    Breaks on this line....ActiveWorkbook.SaveAs myfilename

    I forgot to mention that I don't want to...
  17. Replies
    18
    Views
    729

    MsOf10 Re: Send table on email

    Hello.

    Nearly there.


    It brings up the email with the various components.... Subject etc etc

    But not the table.

    168733
  18. Replies
    18
    Views
    729

    MsOf10 Re: Send table on email

    Thanks for doing this. Ive learnt so much from this thread.


    What line do I add If i want to select a range on a particular worksheet - Worksheet "Summary"?
  19. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Its bizarre. I run the code and it just breaks. It doesn't highlight the line it breaks on. Has that happened before?
  20. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Sorry I'm bit of beginner at this and learning as I go along.


    Then out of nowhere
    Code:
    Wks("Control").Cells(30, 5) = Format(Now, "dd/mm/yy hh:nn:ss")
    Where Wks defined and assigned a...
  21. Replies
    18
    Views
    729

    MsOf10 Re: Send table on email

    Sorry never done this type of coding before.

    Why do I need to convert a range? I only want to copy it the range specified and paste into an email.


    .HTMLBody = strHtml & RangetoHTML(rng)...
  22. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    I tried the code below....

    and it came back with an error message like this...

    ---------------------------
    Microsoft Visual Basic for Applications
    ---------------------------
    400

    ...
  23. Replies
    18
    Views
    729

    MsOf10 Re: Send table on email

    Not great... :-)

    I did some work on this last night and came up with the below

    Its coming up with an error message which I cant seem to fix.


    ---------------------------
    Microsoft...
  24. Replies
    18
    Views
    729

    MsOf10 Re: Send table on email

    Hello,

    Donít want it on word. Needs to be pasted onto an email and to a set group of people
  25. Replies
    18
    Views
    729

    MsOf10 Re: Send table on email

    Hello,

    Don’t want it on word. Needs to be pasted onto an email and to a set group of people
  26. Replies
    18
    Views
    729

    MsOf10 [RESOLVED] Send table on email

    Hello.

    Need to attach this table to an outlook email.

    Subject also needs to read.

    "Please find enclosed yesterdays" and showing date in dd-mmm-yy format.


    168657
  27. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    OK that all worked. However it just renames the file I'm working on. How do I save down an additional file with the new filename as described in #10

    (Basically just want to copy the workbook...
  28. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Hi,


    The workday is currently worked out via a formula in cell I8.

    How do I include this cell in the above code?
  29. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    (forgot to add this)

    Need the file name to look like this

    80 Daily Revenue 25 04 2019_KM
  30. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Nearly worked :-)

    168621

    Workday is missing before the word - Daily

    Also. Why does it only save down a blank workbook?

    I want to save down the whole work book I'm working from
  31. Replies
    14
    Views
    545

    Re: time stamp

    Yep all good now. Thank you.
  32. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    I get a run time error 424 on this? :-(
  33. Replies
    14
    Views
    545

    Re: time stamp

    Getting a run time error 424

    Object required.
  34. Replies
    4
    Views
    246

    MsOf10 Re: Roll network days

    Thanks dude. I will test this over next 5 days and see if it works.
  35. Replies
    14
    Views
    545

    Re: time stamp

    Here's my code.

    I want the time stamp to update every time I run this code.

    Sub openAndCopy()
    Dim wbCopy As Workbook
    Dim wsCopy As Worksheet
    Dim rngCopy As Range
    Dim wbPaste As Workbook...
  36. Replies
    32
    Views
    980

    MsOf365 Re: Save Workbook

    Workday represents the business day in the year.

    for example.

    Friday = 94
    Saturday = 0
    Sunday = 0
    Monday = 95
    Tuesday = 96
    etc etc
  37. Replies
    4
    Views
    246

    MsOf10 Re: Roll network days

    Yep of course that would work.

    But I want to take into account the weekend and bank holidays. Hence the workdays reference and I don't want it to update as soon as I open the spreadsheet. I have...
  38. Replies
    14
    Views
    545

    Re: time stamp

    Thanks for the above JDC2000

    It worked. however it only worked for that day and since then the time stamp has not updated. Do you know why that would happen?
  39. Replies
    14
    Views
    545

    Re: time stamp

    Thanks for the above JDC2000

    It worked. however it only worked for that day and since then the time stamp has not updated. Do you know why that would happen?
  40. Replies
    4
    Views
    246

    MsOf10 Roll network days

    Hi,

    I wish to run a macro that will roll forward yesterdays workday into today's current work day, whilst also taking into account the bank holidays on the right.

    The cell reference I need...
Results 1 to 40 of 44
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width