Thanku so much vabz for clarification...
On Friday, August 22, 2014 12:11:04 PM UTC+5:30, Vabz wrote:
>
> Old module is for creating files in wrokbook insted in feedback sheet.
>
> I have also created Macro for updating only 1 sheet, wherein you needed to
> keep open scorecard & feedback book. Af
Dear Expert
I have forget the passowrd of my old excel file .is there anyway to recover
the password.
?
Please help it is urgent
--
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
Hi All,
I have two files: File1 and File2.
I need to apply Vlookup in File1 using references from
File2.
I have stored name of File2 in a string wrkbk and need to apply vlookup using
this.
Recording Macro gives:
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'[ForecastLastUpdat
Hi
Use:
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'["&wrkbk&".xlsx]Sheet1'!C1:C8,8,0)"
Cheers
On Aug 25, 2014 4:18 PM, "Nitin Balodi" wrote:
> Hi All,
>
>
>
> I have two files: File1 and File2.
>
>
>
> I need to apply Vlookup in File1 using references from File2.
>
> I have stored n
In order to understand what you're doing and work through your question,
you need to understand what VBA is doing.
Your VBA line:
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'[ForecastLastUpdated_18 July 2014
15.45.xlsx]Sheet1'!C1:C8,8,0)"
is essentially :
ActiveCell.FormulaR1C1 = "some strin
There are many ways to recover a password.
You can search Google:
"Excel Password Recovery"
provides over 3 MILLION results.
however, many user groups discourage using the group to accomplish this
(see Forum Rule #3)
the main reason is that programmers/developers make a living from designin
Hi Vaibhav,
Thanks for immediate response, but it is still showing me Syntax Error.
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'["&wrkbk&"]Sheet1'!C1:C8,8,0)"
Value of WrkBk is ForecastLastUpdated_18 July 2014 15.45.xlsx
Regards.
Yours Sincerely,Nitin Balodi
Date: Mon, 25 Aug 2014 16:25
The problem is this:
Just because you gave a filename a .xlsm extension doesn't MAKE it a .xlsm file!
You could just as easily used:
& ".docx"
and it would not make it a Word document.
Probably Windows is giving you the "corrupt document" message because it's
trying to open a file that SAYS
try:
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],'["&wrkbk&"]Sheet1'!C1:C8,8,0)"
On Mon, Aug 25, 2014 at 5:16 PM, Nitin Balodi wrote:
> Hi Vaibhav,
>
> Thanks for immediate response, but it is still showing me Syntax Error.
>
> ActiveCell.FormulaR1C1 = _
> "=VLOOKUP(RC[-3],'["&wrkbk&"]Sh
Hi Vaibhav,
I had used this but it is still showing syntax error.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Mon, 25 Aug 2014 17:45:09 +0530
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
To: excel-macros@googlegroups.com
try:
ActiveCell.FormulaR1C1 = "=VLOOK
The syntax error is probably because of the:
wrkbk&
you need a space:
wrkbk &
In technical terms:
In programming, the "&" is called the "address of" operator.
following a variable with a & means the "addres of" the variable,
not the variable itself.
It's pretty convoluted, and deals primari
Hi Paul and Vaibhav,
Thanks, it worked by giving spaces.
Regards.
Yours Sincerely,Nitin Balodi
Date: Mon, 25 Aug 2014 05:45:45 -0700
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
To: excel-macros@googlegroups.com
The syntax error is probably because
Hi Vabzzz..
I need one more help in this. As you have seen the scorecard file, that
should be summary of four weeks & thehn the feedback would be prepared. Can
you please also help me in consolidation of those four files in to one
file. It would be a great help.
On Monday, August 25, 2014 3:3
Agree to paul..
It should be: ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],'[" & wrkbk & "]
Sheet1'!C1:C8,8,0)"
On Mon, Aug 25, 2014 at 6:15 PM, Paul Schreiner
wrote:
> The syntax error is probably because of the:
>
> wrkbk&
>
> you need a space:
> wrkbk &
>
> In technical terms:
> In programming
Hi
File which you shared contains data for one week only.
Cheers!!
On Mon, Aug 25, 2014 at 6:49 PM, SG wrote:
> Hi Vabzzz..
>
> I need one more help in this. As you have seen the scorecard file, that
> should be summary of four weeks & thehn the feedback would be prepared. Can
> you please al
Hi Friends,
I need to prepare a process documentation MS Word, can any one forward me
the best format.
With Regards,
P Madaiah
--
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.co
*Please respond to gurjant.si...@damcosoft.com
*
*Position: Developer/Architect (JAVA)Location: San Jose, CADuration: 6+
Months*
No of Position: 6
(Solr/Lucne or other search)
- 5+ years experience with Solr (Apache Lucene), HTML, XML, Java, Tomcat,
JBoss, MySQL
- 5+ years experience implemen
Anyone ?? Even an alternative solution perhaps ??
On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote:
> Hi Guys,
>
> PSA.
>
> What I am ultimately looking for is a formula that would automatically
> return all the information based on three different criterias.
>
> In cell K1 - The o
Hi Friends,
Can anyone help me with the excel formula for the attached list of question
Regards,
Ganeshan
--
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
Hi
Kamal Ganeshan
Please find the attached file i cheersss
Regards
Pramod
On Tue, Aug 26, 2014 at 12:16 AM, Kamal Ganeshan
wrote:
> Hi Friends,
>
> Can anyone help me with the excel formula for the attached list of question
>
> Regards,
> Ganeshan
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(
Awesome,
Appreciate a lot for really good information.
Regards,
Ganeshan
On Tue, Aug 26, 2014 at 1:39 AM, Pramod Singh wrote:
> Hi
> Kamal Ganeshan
>
> Please find the attached file i cheersss
>
>
> Regards
> Pramod
>
>
> On Tue, Aug 26, 2014 at 12:16 AM, Kamal Ganeshan
> wrote:
>>
>> Hi F
Well Paul there's a guy in England who says this formula works for him. I'm
awaiting his reply on another forum but he apparently doesn't log on to
often. I also know of another formula some claim to work the difference
being Value & ".xlsm" is replaced with Format=51. I can't get either to
wor
Dear Rjag,
First of all save that code excel file as .xlsm format then run the code it
should work properly.
if found any error then pls let me know.
Warm Regards,
Gawli Anil.
On Tue, Aug 26, 2014 at 7:45 AM, rich johnson wrote:
> Well Paul there's a guy in England who says this formula wor
23 matches
Mail list logo