Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello. I need help. I am not a profession VBA programmer. I want to
create macro such that it will copy some cells from a file(let C: \folder\file1) to other filelet C:\folder\file2). The below macro isnot my main macro. However if it works, I can make work may main macro. But the below one doesnt work, with same style how can I make it work? Thanks alot I try to copy "cell(1,1) of Sheet1 of C:\folder\file1" to "cell (1,1) of Sheet1 of C:\folder\file2" Sub macro1() F1 = "C:\folder\file1" F2 = "C:\folder\file2" F2.Sheets("Sheet1").Cells(1,1) = F1.Sheets("Sheet1").Cells(1,1) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Copying File or Folder message when copying file to CD | Excel Programming | |||
reading txt file and copying the lines in new excel file | Excel Programming | |||
Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions | |||
Copying rows from one file and pasting into a new file | Excel Programming | |||
Copying rows from one file and pasting into a new file | Excel Programming |