used name range to achieve the same :) it will not get shifted when you
named that cell and apply link on that.
Thanks
*Mandeep Baluja *
On Wednesday, November 19, 2014 10:24:36 AM UTC+5:30, amar takale wrote:
>
> Dear All friends
>
> Pls solve my hyperlink issue.
>
> If I give hyperlink for
Dear All friends
Pls solve my hyperlink issue.
If I give hyperlink for specific cell through button (Here text box)
in row in same sheet or different sheet then jump on that cell
perfectly but issue is that if i add rows in sheet then hyperlink link
change that specific cell.
I required fixed hy
Hi Mandeep,
Can we have only one code which you provided earlier that will include
filtering the required data(as per point 3.)and then paste the records in daily
file & previous file.
Thanks,
Ujjwal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N
Following is not woreking
Private Sub Workbook_Open()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
With ws
.EnableOutlining = True
.Protect UserInterfaceOnly:=True, AllowFiltering:=True, _
AllowFormattingColumns:=True, AllowInser
also i want i have 2 sheets in my work book, want to use the *Private Sub
Workbook_Open() , its not working for me :(*
On Tue, Nov 18, 2014 at 11:20 AM, USMAN TARIQ
wrote:
> *is the following fine ?*
>
> Public Function FileFolderExists(strFullPath As String) As Boolean
> 'Author : Usman T
*is the following fine ?*
Public Function FileFolderExists(strFullPath As String) As Boolean
'Author : Usman Tariq
'Macro Purpose: Check if a file or folder exists
On Error GoTo EarlyExit
If Not Dir(strFullPath, vbDirectory) = vbNullString Then
FileFolderExists = True* And (DateDiff(
following is the code in the *Module *
Public Function FileFolderExists(strFullPath As String) As Boolean
'Author : Usman Tariq
'Macro Purpose: Check if a file or folder exists
On Error GoTo EarlyExit
If Not Dir(strFullPath, vbDirectory) = vbNullString Then
FileFolderExists = True
E
Hi all,
I have attached two workbooks, Orders and Stocks.
In the Orders workbook, I have a macro, which filters Itemwise once I run
the macro and enter the filter values like "A001", "A002" etc.,.
I like to have a slight modifications in the same macro, so that, when I
run the macro, filtering s
your FileFolderExists() function probably utilizes the Filesytem object
and has something like:
if (fso.fileexists(filename)) then
you need to EITHER modify your FileFolderExists function
to also use:
set f = fso.getfile(filename)
if (datediff("d",f.datelastmodified,now()) = 0) then
or a
i have figured out the issue the following code works . but actually in our
project the updated files are replaced everyday .
For example there is a file called Report A, it was delivered on 11/17 ,
but is not delivered on 11/18 , in the folder the one that is delivered
still exist , but in my ex
Dear Rupesh,
Please find the attachment .
Regards,
*Mandeep Baluja *
On Monday, November 17, 2014 4:10:26 PM UTC+5:30, Rupesh Patil wrote:
>
> Hello experts,
>
> I need your help,I have one userform which attached with mail for your
> reference, what I need is add text boxes vertical on but
Hello Experts,
any help?
On Mon, Nov 17, 2014 at 4:10 PM, Rupesh Patil
wrote:
> Hello experts,
>
> I need your help,I have one userform which attached with mail for your
> reference, what I need is add text boxes vertical on button every time
> click "Add Button" and remove this text boxes eve
Use this code to apply filter do the changes as per your data.
Sub Filter()
Dim lastrow
Range("m2:q65536").Select
Selection.Clear
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Range("A1:e" & lastrow).Select
Sheets("Mainsheet").Range("A1:e" & lastrow).AdvancedFilter
Action:=xlFilt
Also can you provide me sloution for the 3. Point.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thre
Also can you provide me sloution for the 3. Point.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thre
Hi mandeep.
I have to compare prices of different varieties in various markets across
markets. Mostly the price comparison is on daily/weekly/Monthly/Yearly
basis and thier absolute change or diffrence between two dates.
But in the above formula mentioned by you,i have to select dates for
var
you can set your default path by copying it in code there is no need to
change it again and again.
add these lines of code in bottom
Workbooks(file1 & ".xlsx").Close savechanges:=False
Workbooks(file2 & ".xlsx").Close savechanges:=False
Thanks
*Mandeep Baluja*
On Friday, November 14, 2014 11:3
Hello ,
Thanks for the code.
Few changes needed :
1.Can we have a default path as the main folder “daily ATB”.(This will help
to compare file saved in any sub folder of “Daily ATB”)
2.Post the data is copied and pasted in the comparison report daily file
and previous file need to be auto close
18 matches
Mail list logo
