Thanks Maudibe its working.
Type: Posts; User: carmine; Keyword(s):
Thanks Maudibe its working.
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 Maudibe for helping.
The codes pop up the message box, is there any way to see the outlook compose window once and then proceed.
Maudibe, waiting for your support.
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.
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 &...
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.
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.
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...
Same error "Constant expression required."
Thanks Paul T,
I get error on this line 'Dim aData(iLastRow, 1) '2d array' Constant expression required.
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.
You both ROCK the forum.
Thanks RG, I have attached the sample file along with results, Please have a look.
This codes Displays Message Box from Row (B2) onwards in Sheet2 (named :Level2)
Dim Rng As Range
Dim c As Range
Set Rng =...
Below codes works fine for me, In Column C if it has a value of '2' then set cell color to Red.
Dim ChkRange As Range
Set ChkRange = Range("C2:C200")
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...
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...
AWESOME kweaver & Maud.
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.
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
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...
Thanks Paul T.
Thanks R.G. Thanks a lot.