dcsimg

Search:

Type: Posts; User: kris01

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    700

    Re: Vlookyp and paste special

    Sorry I meant C7 on the control tab instead of I7.
  2. Replies
    6
    Views
    700

    Re: Vlookyp and paste special

    Morning.

    Just re-read my original post and I my original requirements were wrong...


    I need a macro to quickly lookup the date in the Control tab cell c7, look this up in column C on Data...
  3. Replies
    33
    Views
    2,004

    Re: [RESOLVED] Txt file convert to .xls

    Its still running slow.... Taken over 10mins to import the same file as you. Could it be that my workbook is 43mb?

    Which is bizarre in itself because it should be nowhere near that... How...
  4. Replies
    33
    Views
    2,004

    Re: [RESOLVED] Txt file convert to .xls

    Morning.

    Here's a sample file you can test the coding on.... My work book is too big too send.
  5. Replies
    33
    Views
    2,004

    Re: [RESOLVED] Txt file convert to .xls

    Hello.

    Have a small issue with the below coding....


    The actual size of my file is only 107kb, but when I tried to to import this file it took over 45 mins to import and increased the...
  6. Replies
    6
    Views
    700

    Vlookyp and paste special

    Hiya.

    Quick and easy one for the pro's on here.

    I need a macro to quickly lookup the date in the Control tab cell c7, look this up in column C on Data tab and paste special values the...
  7. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    Brilliant. That's worked. Thanks very much.
  8. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    I don't actually want to create a new sheet. Just want to import the txt file into a worksheet called US Equities.

    Changed as per your request above. Still breaking on the same line with...
  9. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    Ok, I've run the below code.

    New error message on this line


    objSheet.Name = "US Equities"


    Run time error 1004 - application defined or object defined error.
  10. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    Yes its already open
  11. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    I've changed the code to this...

    but now I'm getting on line in bold.

    Run time errror 9.... Subscript out of range.

    objExcel.Visible = True
    Set objwb = objExcel.Workbooks("New Revenue...
  12. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    I changed the coding to read like the below, but stopped on the below line

    Run time error '424' Object required. I'm guessing I've missed something.


    Set objSheet = objwb.Sheets.Add...
  13. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    I changed the coding to read like the below, but stopped on the below line

    Run time error '424' Object required. I'm guessing I've missed something.


    Set objSheet = objwb.Sheets.Add...
  14. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    Hello,

    Ok, nearly there on this.

    Below is my code.

    Last thing I need to change is this part of the coding...

    Set objSheet = objExcel.ActiveWorkbook.Worksheets(1)
    ...
  15. Replies
    33
    Views
    2,004

    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...
  16. Replies
    5
    Views
    519

    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 =...
  17. Replies
    33
    Views
    2,004

    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'


    ...
  18. Replies
    33
    Views
    2,004

    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...
  19. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    does anyone know how to import this file?
  20. Replies
    5
    Views
    519

    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...
  21. Replies
    5
    Views
    519

    [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()
  22. Replies
    32
    Views
    1,596

    MsOf365 Re: Save Workbook

    Ok finally got it sorted. Thank you for your patience and help.
  23. Replies
    32
    Views
    1,596

    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,...
  24. Replies
    33
    Views
    2,004

    Re: Txt file convert to .xls

    as requested....168895
  25. Replies
    32
    Views
    1,596

    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 " &...
  26. Replies
    33
    Views
    2,004

    [RESOLVED] 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 -...
  27. Replies
    32
    Views
    1,596

    MsOf365 Re: Save Workbook

    Current file is .xlsm and I want to save as a .xls
  28. Replies
    32
    Views
    1,596

    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...
  29. Replies
    18
    Views
    1,105

    MsOf10 Re: Send table on email

    are missing the sheet's "summary" reference from the above?
  30. Replies
    32
    Views
    1,596

    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...
  31. Replies
    18
    Views
    1,105

    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
  32. Replies
    18
    Views
    1,105

    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"?
  33. Replies
    32
    Views
    1,596

    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?
  34. Replies
    32
    Views
    1,596

    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...
  35. Replies
    18
    Views
    1,105

    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)...
  36. Replies
    32
    Views
    1,596

    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

    ...
  37. Replies
    18
    Views
    1,105

    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...
  38. Replies
    18
    Views
    1,105

    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
  39. Replies
    18
    Views
    1,105

    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
  40. Replies
    18
    Views
    1,105

    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
Results 1 to 40 of 58
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width