Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    132

    Save all Sheets as CSV

    Hello,

    I have a Workbook and multiple sheets around 30 (Tabs) need to save all of them with their tab names as CSV format to a particular folder.

    Thanks in advance.
  2. Replies
    2
    Views
    160

    Thanks Maudibe its working. Many Thanks.

    Thanks Maudibe its working.
    Many Thanks.
  3. Replies
    2
    Views
    160

    Import a Specific File

    Hello,

    This script does Application.GetOpenFilename instead of that i need a fixed/Specific text file from "D:\database\costing\global.txt" always.
    Please help to modify.

    Thanks.



    Sub...
  4. Thanks Maudibe for helping. The codes pop up...

    Thanks Maudibe for helping.

    The codes pop up the message box, is there any way to see the outlook compose window once and then proceed.
    Thanks.
  5. Hello, Maudibe, waiting for your support.

    Hello,

    Maudibe, waiting for your support.
  6. Hello, Thanks Maudibe for reply, sorry the...

    Hello,

    Thanks Maudibe for reply, sorry the codes are not working for me. The codes which i use for sending the email are as follows. Please suggest.
  7. Display only one record before sending email

    Hello,

    I send email successfully from the macro but before sending email address with multiple rows in Column G. I need to check a single email in Outlook window for Subject Line, Contents &...
  8. Thanks Zeddy its working, Now this error of...

    Thanks Zeddy its working, Now this error of Run-time error 13 Type mismatch.
    If value not found then result file #N/A creating this error at 'If Len(cell) < 15 Then'. Please have look.
    Thanks in...
  9. Hi, Zeddy, Difficulty is that if there are...

    Hi,

    Zeddy, Difficulty is that if there are leading zeros in details.xls then result file drops them, Please provide a solution, new details.xls uploaded with leading zeros for testing.
  10. Hi, Zeddy, If i want the declare the Sheet...

    Hi,

    Zeddy, If i want the declare the Sheet 'Particulars' data from the workbook.

    Secondly while copying from source file if the cell value is text (numeric formatted as text) it does not...
  11. Same error "Constant expression required." ...

    Same error "Constant expression required."

    Thanks
  12. Hi, Thanks Paul T, I get error on this line...

    Hi,

    Thanks Paul T,

    I get error on this line 'Dim aData(iLastRow, 1) '2d array' Constant expression required.

    Thanks.
  13. Hi,

    Hi,
  14. Hi,

    Hi,
  15. Macro to copy values from a closed workbook to the current workbook

    Hi,

    I'd like to copy values from a closed Excel workbook to the current one.
    The current workbook is named CNEE.xlsx, and has one worksheet named "CNO" where I'd like to copy the data to.

    The...
  16. Replies
    5
    Views
    3,362

    Hi, Thanks Zeddy. Thanks Maud. You both...

    Hi,

    Thanks Zeddy.

    Thanks Maud.

    You both ROCK the forum.

    Thanks.
  17. Replies
    5
    Views
    3,362

    Hi, Thanks RG, I have attached the sample file...

    Hi,

    Thanks RG, I have attached the sample file along with results, Please have a look.
  18. Replies
    5
    Views
    3,362

    Need to get results in message box

    Hi,

    This codes Displays Message Box from Row (B2) onwards in Sheet2 (named :Level2)


    Sub SumTotal()
    Dim Rng As Range
    Dim c As Range
    Worksheets("Level2").Select
    Set Rng =...
  19. Replies
    1
    Views
    255

    Change Cell Color

    Hello,

    Below codes works fine for me, In Column C if it has a value of '2' then set cell color to Red.



    Sub DeleteRows()

    Dim ChkRange As Range
    Set ChkRange = Range("C2:C200")
  20. Replies
    3
    Views
    448

    Hello, I have attached the sample text file...

    Hello,

    I have attached the sample text file and excel workbook.

    I will import single text file and Column B will be the name of sheet. The data to be sorted on column B and then transferred to...
  21. Replies
    3
    Views
    448

    Import 4 Text files to different sheet

    Hello,

    I have 4 text files in a folder & format, structure of files are same.
    I want to import all 4 files simultaneously to a workbook with each text file having their own sheets.
    Any one, a...
  22. Replies
    9
    Views
    1,623

    Hi, AWESOME kweaver & Maud. Thanks

    Hi,

    AWESOME kweaver & Maud.

    Thanks
  23. Replies
    9
    Views
    1,623

    Thanks kweaver. Exactly thats what i was...

    Thanks kweaver.

    Exactly thats what i was looking for.

    One thing if the number is increased in thousand than it does not give the output.
    Like starting 17500 Points 2000 How to do that.
    Can...
  24. Replies
    9
    Views
    1,623

    Hello, No, if its greater than 100 than...

    Hello,



    No, if its greater than 100 than split it into 100 each. if Col D points are 150 then split 100 & second one 50.


    In the same sheet in descending row order.

    Thanks in advance
  25. Replies
    9
    Views
    1,623

    Divide into Group

    Hello,

    I have points in Column D wherein if the value is greater than 100 then divide it into group.

    Col A---------- Col B---------- Col C---------- Col D----------Col E---------- Col F...
Results 1 to 25 of 40
Page 1 of 2 1 2