Need help while using concatenate formula in macros

viv_karthy

New Member
Joined
May 30, 2015
Messages
2
Hello
The problem statement is this:
1. I have a column in an xls ie work book1-> Sheet A-> Column AA(source)
2. I need to bring in each of the value from that column into another xls workbook2-> Sheet 1-> Column BB(destination)
3. Paste each of the value from the source(column AA) to the destination(column BB)
4. After pasting at the destination, I need to concatenate each value of the cell with the string "Application Manager"
The sample code looks like this:
ActiveCell.FormulaR1C1 = _
"=CONCATENATE('[Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R34C1,"" Appliocation Manager"")"
Range("B4").Select
ActiveCell.FormulaR1C1 = _
"=CONCATENATE('[Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R35C1,""Application Manager"")"
Range("B5").Select
ActiveCell.FormulaR1C1 = _
"=CONCATENATE('[Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R36C1,""Application Manager"")"
Range("B6").Select
Where :
Source file name =Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire
Source cell location : R34C1, R35C1, R36C1
Attaching string: Application Manager

Now, i would like to variabalize the portion "Seaton - Non GBS Application Inventory.xlsx]Application Questionnaire'!R34C1" so that it picks the data from the source and and concantenate it with "Application Manager"
How do I variabalise this?

Please advice
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
you spotted the typo on the first statement
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,290
Messages
5,836,435
Members
430,429
Latest member
monkeyhalf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top