Hi Sandeep,
I have a code, which simply goes to specific folder & open the workbooks
one by one & copy the data and paste them in same sheet (Where the marcro
is written).
** Make sure all the files have same header, because it copies all the data
including the header.
So if this is relevant, I
Hi Paul,
If I run the command based on your comment that I use
ThisWorkbook.Activate
> MaxRow = ActiveCell.SpecialCells(xlLastCell).Row
> MaxCol = ActiveCell.SpecialCells(xlLastCell).Column
> For iRow = 1 To MaxRow
> For iCol = 1 To MaxCol
>
Then the command below comes up with s
Hi Paul,
The code works. However, it doesn't achieve the desired result. The code
doesn''t show all the updated data in the next blank row. It doesn't seem
to compare the database in both workboooks.
Cheers
On Tuesday, 26 January 2016 21:20:47 UTC+8, Paul Schreiner wrote:
>
> I updated the
I'm afraid you'll have to seek elsewhere.This forum's rules state: 3) Don't
post questions regarding breaking or bypassing any security measure.
since we have no way of knowing if the person that CREATED the application are
protecting their Intellectual Property, or there was another reason.
If y
Dear Paul,
Thanks, But in this scenario I am not at all aware from where this password
has come. can anyone help me how can I get rid of this.
On Tue, Jan 26, 2016 at 1:39 AM, Paul Schreiner
wrote:
> I'm not sure what you are expecting.
> When I open the file, my "Review" tab shows:
> [image: I
I'm having trouble understanding what you are trying to do.The terms don't
quite make sense.Automatic sort? What is that?if you record a macro and define
your sort, the issue is that the selected range becomes "hard-coded" into the
macro.SortFields.Add Key:=Range("I2:I766")
means that if you add
Thanks for reply
I get the solution from Vaibhav Bhai .
It is working as per my query too
On 26 January 2016 at 19:04, Paul Schreiner wrote:
> To do what you're actually asking would take a great deal of programming.
>
> In Cell E26, a simple formula like:
> =IF(G26>70,70,G26)
>
> would look a
Hi,
automatic Sort with the macro recorder or normal sort with three levels do
not give me the expected results.
Sorting descending, between the same values in one column the other column
is not sorting any more, until the value changed again.
is there a routine already in VBA ?
PS there is no
Hi,Any way to solve this problem.
To do what you're actually asking would take a great deal of programming.
In Cell E26, a simple formula like:=IF(G26>70,70,G26)
would look at G26, and if it is more than 70, it returns 70.Otherwise, it
returns the actual value of G26.
However, you said you want accept ANY VALUE if it's <= 70.That
I updated the macro to this.give it a try:
Option ExplicitSub test()
Dim varSheetA As Variant
Dim varSheetB As Variant
Dim strRangeToCheck As String
Dim strRangeToC As String
Dim iRow As Long
Dim iCol As Long
Dim wbkA As Workbook
Dim eRow As Long
Set wbkA = Workbooks.Open(Filename:="C:\temp\vba\for
I have send this query on 21 st -- No body reply.
Is this possible or not
-- Forwarded message --
From: big smile
Date: 21 January 2016 at 08:12
Subject: $$Excel-Macros$$ Polite Reminer -- Prompt / Ask the value & then
calculate value
To: excel-macros@googlegroups.com
Hello Fr
12 matches
Mail list logo