solved your query now
--- On Mon, 11/19/12, Raj Mahapatra rajexcelma...@gmail.com wrote:
From: Raj Mahapatra rajexcelma...@gmail.com
Subject: $$Excel-Macros$$ Event - Worksheet Change
To: excel-macros@googlegroups.com
Date: Monday, November 19, 2012, 11:15 PM
Dear Friends,
kindly help out on
Dear All,
Please find below is my request to create excel macro.
I have a list of files in local directory and file list located in A column
and need to merge text file based on the B column listed files.
A1---B1
C:\1.txt --- C:\Merge\1.txt
C:\2.txt ---
C:\3.txt ---
when i use C:\test\[WSO_Record.xls]Record, the script can run propriety,
but if change to network pathThisWorkbook.Path
\[WSO_Record.xls]Record, i will get error 1004, what is the error in my
script?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And
Dear teow,
can u share a workbook with us??
Regards,
Gawli Anil
On Wed, Nov 21, 2012 at 4:34 PM, Teow teow...@gmail.com wrote:
when i use C:\test\[WSO_Record.xls]Record, the script can run propriety,
but if change to network pathThisWorkbook.Path
\[WSO_Record.xls]Record, i will get
Hi Teow,
Can you ple share your Both WorkBook eg. WSO_Record.xls and the one inwhich
ur writing formula.
Regards
Prince
On Wednesday, November 21, 2012 4:34:54 PM UTC+5:30, Teow wrote:
when i use C:\test\[WSO_Record.xls]Record, the script can run propriety,
but if change to network path
Thanks prince and Natron
On Tue, Nov 20, 2012 at 9:37 PM, Prince prince141...@gmail.com wrote:
Hi Shrini,
I think without macro it is not possible to do as formulas can not control
objects and a workbook is an object. But you can do one thing by using
conditional formatting you can
Glad it worked for you.
On Tuesday, November 20, 2012 1:29:45 PM UTC-5, Mangesh wrote:
Thank you so much Natron.
You have made my work very easy.
Thanks again.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
My apologies Anoop, I hope you can understand my code, I tried to comment
it at key locations. I attached a workbook the second go around.
On Tuesday, November 20, 2012 9:38:32 PM UTC-5, Enrique Martin wrote:
It's better to attach the file and put you query there.
No one gonna study this
SUBMITTED
On Mon, Nov 19, 2012 at 12:32 PM, Deba Ranjan drdeva...@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (drdeva...@gmail.com) Add cleanup
Hi! jeet singh,
Thanks i am expecting this only thanks a lot
On Wednesday, 21 November 2012 11:20:48 UTC+5:30, jeet singh wrote:
PFA
On Tue, Nov 20, 2012 at 10:20 PM, renuka chari jva@gmail.comjavascript:
wrote:
hi Excel beginner,
i don't know your name?
but you gave me a
Hi Viswanathan,
Pls find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Nov 21, 2012 at 2:43 AM, Viswanathan Yoganathan
viswanathan.yoganat...@asia.xchanging.com wrote:
HI,
** **
In the attached excel, I need to remove the duplicate lines
Hi Renu,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Nov 20, 2012 at 10:20 PM, renuka chari jva.ch...@gmail.com wrote:
hi Excel beginner,
i don't know your name?
but you gave me a wonderful solution
thanks allot.
but is there any
thx your reply, here is the excel file, is use Publish.xlsm connect
WSO_Record.xls
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
both files is under same server, but if i want set give a path value in
Publish.xlsm,
in worksheet Data_Set, C2 is path and D2 is target file and sheet name to
connect
the blue color script if i add will solve the issue?
C2 = \\Server\Plan Delivery
D2 = [WSO_Record]Record
Private Sub
Hi Renuka,
Please find one more solution from my side :
=INDIRECT(CHAR(65+ROW(A1))ROW(B3)-1)
Regards
Prince
On Monday, November 19, 2012 10:35:49 PM UTC+5:30, renuka chari wrote:
Dear experts,
is there any solution for pick the step value in certain table?
please see above attached
Both files in same server, but I wish can add the path but use a cell value
in worksheet Data_Set on the Publish.xlsm file
Below blue color script is a new add modify, but still come out error 1004
C2 = \\Server\Plan Delivery
D2 = [WSO_Record]Record
Private Sub Worksheet_Change(ByVal Target As
Hi all..
i have a doubt in excel qt
General: Ex: in one folder its have five(5) different work book are there
like a',b,c,d,e and each work it has 3 sheets same data .
how to get page setup in all work book at the same
thanking you
--
Join official Facebook page of this forum @
17 matches
Mail list logo