Add a Calculation by VBA

Multiply the value of B2 by 1.5%, then multiply that result by 56 and then paste the result in D2(i need only result in the cell no formulas)
note- 1st row contains headers so ignore the first row
The file will be located in C:\Users\sk\Desktop and file name is sample.xlsx
file is not opened so we have to open the file by vba and do the process and save it and close it
vba will be added in a seperate file process.xlsm
both files are located in same place
i need vba to do the same

Cross post link added
http://www.vbaexpress.com/forum/show...Formula-by-vba

http://www.vbaexpress.com/forum/show...ormula-by-vba&

If workbook 1 is the workbook in which you need the D2 cell populating, and this is being opened by a macro in workbook 2 then since workbook 1 will be the active file IMMEDIATELY your macro opens Workbook 1 then use somethig like the following as the bext line of code after the File Open instruction

Formula:

Please Login or Register  to view this content.

The reference to Sheet1 is the VBA Sheet code name NOT the sheet tab name which has the B2 value. Change as necessary
I also assume that the B2 & D2 cells you're using are in both in Workbook1,

Administrative Note:

I added a solution before it was brought to my attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting.

Add the links in your original post and I'll then re-open the solution I gave.

Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Hi,

I wasn't aware of a minimum 3 post limit, and in any case when you posted I think you had 5.

However since you've adjusted the tite to include the link, and assuming that's the only other forum in which you've posted the link - if not plet me know, I'll add the link in your original.

See post # 3 now displayed.

Put the code I gave you inside the Workbook Open event of workbook 2 as I defined it earlier i.e.

Please Login or Register  to view this content.

change the Sheet1 ref as necessary.

I see large mission creep from your first post.

It's now not at all clear (at least to me) what it is you're trying to achieve. In any case this is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data. Absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result.
You must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data).

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)