Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Copy/Paste From One Workbook To Another


Im trying to copy from one notebook to another and paste but to not paste over the information thats already there. I need to just paste my new info below whats already there. I have attempted this by filtering when I copy but its not working. My attempt is below. Right now Im filtering by column a but i need to be filtering by column c in the future.

ertyMerge()
ActiveSheet.Select
Range("a2:t65000").Select
Selection.Copy
Windows("Disc Pivots Template.xls").Activate
Sheets("Sheet1").Activate
Range("a1").Select
ActiveSheet.Paste
Sheets("Sheet1").Activate
Range("a1:t65000").Select
Selection.Copy.........................


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Copy Paste A Set Of Data From A Workbook To Another Workbook
How can i copy paste a set of data from a workbook to another workbook. for example i will copy cell D10:I10 of workbook1 to cell B2:F2 of workbook2.


View Replies!   View Related
Select/Copy/Paste From Workbook To Workbook
I've been doing various searches for past few hours and can't seem to find out if one its even possible, the closet I've found on here is to copy row to another workbook.

My question is I have one excel book called level1.xls and another excel book level2.xls, now in level1.xls I have a row of fields filled in and in level2.xls I have a blank form which for example I would like to try programme in VBA from the level2.xls file to click a button and open automatically level1.xls then grab field "A2" value from level1.xls and place it in level2.xls field "L4" then continue using level1.xls "B2" to level2.xls in field "C3" and then continue down when I add more values A3, A4 so on in level1.xls to the same field in level2.xls L4.
Steve.

View Replies!   View Related
Copy / Paste To Another Workbook
I have to gather a LOT of information from different files, into 1. To do so I want to automate this.

1. I will make a new, target file
2. I want to have a file with the macro in it
3. i want to open a (various) number of files to copy the info from

Now for my questions:

* How can I determine which other files are open (apart from the new and macro file)?

* How can I access each individual file, copy the information, paste it in the target file and close the "copy-file" after this

* Within the previous *): how can I determine how many worksheets there are in each file and do the copying sheets by sheet?

View Replies!   View Related
Macro To Copy And Paste From One Workbook To Another?
I have a master workbook and a template workbook. The template workbook when run generates a new workbook with the current date as the file name. Within the newly generated workbook, the template, had created 5 worksheets. On each worksheet, there is a single cell that contains the total from that particular worksheet.

What I need is a macro that will grab these totals, one from each of the 5 worksheets from the newly generated workbook done by the template, and pasted it in the master workbook under the 5 columns in a worksheet: 0-20, 21-40,41-60,61-80,81-100. However, the next time the macro is run, it will not over write the previous data but move to the next blank row and paste the totals there.

View Replies!   View Related
Copy-paste Large Workbook
I'm having a little bit of trouble with my code. I basically need to copy-paste special a large workbook (50 worksheets) into a new range-valued workbook. I've defined Sheet as S, but in some instances when I use the variable "S" I received a runtime error 1004.

Please see the highlighted red "S" in the code below.

Also, if one knew of an easier method for this particular operation that would be great!

Sub PasteSpecial()

Dim W As Workbook
Dim S1 As Worksheet
Dim S As Sheets

Set W = Workbooks("newfile2")

Set S1 = W.Worksheets("Sheet1")

Set S = Sheets

S(Array("Sheet1", "Sheet2", "Sheet3")).Select
S1.Activate
S(Array("Sheet1", "Sheet2", "Sheet3")).Copy
Cells.Select
Range("a1").Activate
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Paste:=XlPasteFormat
S("Sheet2").Select
Cells.Select
Selection.PasteSpecial Paste:=xlPasteValues, Paste:=XlPasteFormat
S("Sheet3").Select
Cells.Select
Selection.PasteSpecial Paste:=xlPasteValues, Paste:=XlPasteFormat

MsgBox "New Range-Valued Workbook has been created"

Application.CutCopyMode = False

End Sub

View Replies!   View Related
Copy & Paste To Another Workbook
Need code that would copy range "A1:J1" to another workbook in the next available blank row.


View Replies!   View Related
Copy/paste To New Workbook Several Times....
I'm trying to create an "export" feature where certain data can be copied out to a new workbook. I want to copy out the following from the current workbook to a new one: Sheets("1TR").Range("C33:M999") to range("A1") in the new workbook
and Sheets("1PL").Range("K33:K999") to range ("L1") in the new workbook.

The problem I'm having is that it is not just one copy/paste exercise, but two, and I don't know how to reference the new workbook as it doesn't have a filename.

View Replies!   View Related
Copy The Range And Paste To Another Workbook
i facing another problem at here and do not know how to write the part of coding. it is pending for 2 weeks. i do not know how to explain so i attach the excel to explain. i hope can get any reply soon.

View Replies!   View Related
Copy & Paste Data To Other Workbook
By referring to the attached file, I have to copy all the datas which have a value only ( total=0 is ignored) in the Bin_Trip worksheet(highlight in image1 below), then all this data will be paste to other new workbook. All this job is done by clicking the start button and after user enter the directory(image2 below).
The last result consist of the workbook with the pasted datas from Bin_Trip worksheet.
image1
image2


View Replies!   View Related
Copy Paste Range To Closed Workbook
Copy and paste the values only from one workbook and a set of named ranges (Name1, Name2, Name3) but only the rows within the range were TRUE is found in column A - To a CLOSED workbook named Data / Sheet1 - located at C:NetworkTemplate starting with cell B10.


View Replies!   View Related
Copy+paste From Closed To Open Workbook
how to go about taking data from a closed workbook with a range say A1 to A100, and place it in the work book i have open. I have 3 different sheets in the open work book but all the data is coming from the one sheet in the closed workbook.

View Replies!   View Related
Macro To Copy Range And Paste It In A New Workbook
Is it possible to write vba code to copy the range A1:A20 from my workbook to a new workbook?

View Replies!   View Related
Create Workbook & Copy Paste To It
I am currentyly using VB to extract some data sets to another tab in the same workbook. I would like to extract the same data to a new workbook that is already created upon running a macro. How do I specify the location of the new workbook and sheets so the code will extract and input correctly?

The code I am currently using is:

Sub RunModel()

Dim Events As Range
'
'
Application. ScreenUpdating = False

Set Events = Worksheets("Inputs").Range("L41:L90")
Worksheets("Results").Range("A5:FX5004").Clear
Worksheets("Results").Range("A5009:FX10010").Clear

y = -100

For x = 1 To 50

View Replies!   View Related
Find Copy & Paste To Another Workbook
Here is some sample code I found on the internet similar to mine:

Windows("Waterfall 1.xls").Activate
Cells. Find(What:="accounts", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
Windows("test Schedule.xls").Activate
ActiveCell.Offset(0, 0).Range("A1").Select
Application.CutCopyMode = False
ActiveCell.Offset(0, 1).Range("A1:G1").Select
Selection.Copy
Windows("Waterfall 1.xls").Activate
ActiveCell.Offset(0, 2).Range("A1:G1").Select
ActiveSheet.paste
Windows("test Schedule.xls").Activate
ActiveCell.Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "4"
ActiveCell.Offset(0, -1).Range("A1").Selectp.

I now understand that there's a way to remove the activate statements, while still selecting that document to work with, and therefore greatly increasing the speed.

View Replies!   View Related
Copy VLOOKUP Results & Paste Into New Workbook
Is there to copy my vlookup results into another workbook?

I put together a marco that will select an range and paste it into a new document, however my vlookup results will not copy over.

Is there a way to extract my vlookup results and paste it into another workbook with the enclosed vba code?

Private Sub CommandButton1_Click()
'
' Macro2 Macro
' Macro recorded 4/24/2009
'
Columns("A:E").Select
Range("A2").Activate
Selection.Copy
Workbooks.Add

ActiveSheet.Paste
End Sub


View Replies!   View Related
Copy A Range Of Data And Paste To The Last Row Of Another Workbook
I need a macro that will copy a selected range from an existing worksheet in a workbook and paste the data to the last row in another workbook on a particular worksheet.

View Replies!   View Related
Search, Copy And Paste Entire Row Into New Workbook
I need a code that will search column A over multiple sheets for a user specified value through an input box. I then need this code to copy and paste the entire row to a new workbook titled "Batch Report" Anyone have any ideas? I have a code that will copy and paste only a few rows but no where near all of them, and I cant figure out why.

View Replies!   View Related
Copy/Paste Macro (automate Copies To Another Workbook)
I'm looking for information on building a macro that will automate making copies of a spreadsheet into another workbook that contains very particular information. My master sheet has lists of my customers and the rep's that service them. What I need to do is have macro buttons for each rep. that will pull all the shops that they service and all information for these shops into another spreadsheet.

View Replies!   View Related
Copy & Add New Workbook To Paste Special
Currently I have a macro which successfully updates a value in the report page, creates a new document and then copies and pastes (as values)that sheet into the new workbook and saves it down as a unique file.

I need to have graphs on this new workbook. So gathered creating a template and getting the macro to open this template, copy the ranges and then paste into the template (which will update the charts) and then save down.

The ranges i need to paste in are: B5:D7, and B11:P37 the destination cells are exactly the same.

The current code i have is: ...

View Replies!   View Related
Copy Last Cell In Column Of 1 Workbook & Paste To Another
I type all the information into the Workbook called 'Form' in ' Sheet 1' and i need it to also transfer into the workbook named 'Master' in sheet 'August 08'

For Instance.
It needs to copy Cell C4 from Sheet1 in Form and paste into the next empty cell in column A in August 08 in Master.

All comments/improvements would be much appreciated as the macro I attempted to create solely didnt work at all.

View Replies!   View Related
Copy Paste Cells To Newly Created Workbook
My code in the first workbook generates a new workbook with a variable in the filename, then copies the cells from the first workbook to the newly created workbook. This code is working properly when used in a draft worksheet I use for testing. As soon as I put it in the master file, an error message pops up "Runtime error 1004 : select method of range class failed". Then the debug sends me to the line " Cells.Select ". What should I be looking for, why does my code work on one file but when i put it in another one it doesn't ?

Private Sub CommandButton1_Click()
Dim line_counter As Long
Dim prm_line_value As Boolean
prm_line_value = False
Do
prm_line_value = Sheets("Rate").Cells(1 + line_counter, 1).Value
line_counter = line_counter + 1
Loop Until prm_line_value = False
line_counter = line_counter - 1
Dim Wk As Workbook
Dim number_of_new_wb_needed As Integer
If line_counter < 5000 Then.....................

View Replies!   View Related
Copy A Range And Paste Into Another Workbook - Files Are Password Protected.
I need to copy and paste a range from one workbook to another workbook automatically.

Basically, I have 180 files in a folder. The details are:

1) 90 master files

2) from these a range named "COPYTOE" has to be copied and pasted into another 90 report files.

3) I have list of files & its passwords in a separate file named FNAME.XLS. In this, Sheet1, A1:C the details consist like this: ....

View Replies!   View Related
Copy Data From Child Workbooks And Paste In Master Workbook
I had to copy data from child woekbooks (*.xls) and paste it to the master workbook with same page to page every time when a macro is executed i had done the copy and paste part

But I'm Facing the problem in which i had to deal with

Validations as on both master and child sheet validation (column based combo box is activated )
one is worktype
2ns is time type

i jst had to copy data to the master macro works perfectly fine but the problem is that a msg box appears which signifies that i had to change the name (version ) for both types when i click yes 2 times it pastes the data

I'm attaching my macro as well as pic of that msg box with this attachment

View Replies!   View Related
Copy Range From Multiple Sheets & Paste To Another Workbook
I am looking for either formula which will allow me to copy data from a workbook with multiple named sheets into a workbook with a single named sheet. For instance workbook 1 has sheets named bob, sue, and tom and there is a workbook 2 which only has sheet bob. I want to copy the range fo data from sheet bob in workbook1 to workbook 2 as long as workbook 2 has sheet bob.

View Replies!   View Related
Open File & Copy Paste Cells From Workbook To It
Is it possible, in vba, to copy two sets of cell values to two clipboards (clipboard1 and clipboard2?), open another workbook and paste those two seperate clipboard values into another two cells?

View Replies!   View Related
Macro To Copy Over And Paste Data In To A Work Sheet From A Closed Workbook
I have a macro code which gets the file list from a folder i specify and puts it in to an excel sheet as a column. I have then made a drop down list from this so the user can select the file they want.

From this file i wish to copy the data on a sheet that i specify. For example the sheet "dump" from file FR7_19.11.2009.xls (which will be a closed workbook) and paste its content in to the sheet "dump" in Summary.xls

I have a macro which opens up the closed workbook FR7_19.11.2009.xls and copies the sheet "dump" and then creates a new sheet of the same name and content in my current workbook (Summary.xls). However when i wish to select a different file to load in to Summary.xls "dump" the formulas i have been calculating information from this sheet all come up with #!Ref errors. I know this is because the macro i use deletes the old dump sheet before re adding a new one containing new data.

I am therefore looking for a macro which will simply just copy and paste the data from any file i select in to a sheet named "dump" as the data is always set out the same in every file but the values are different. I assume this will then mean that any formulas i use relating to this "dump" sheet in Summary.xls will work because the sheet is no longer being deleted and re-added the data within it has just simply been copied over.

View Replies!   View Related
Sharing Workbooks; Copy And Paste The Workbook Onto Another Laptop, None Of The Scripts Work
I have created a workbook with vb code that include 4 modules, 1 userform. These all work in the original workbook. When I copy and paste the workbook onto another laptop, none of the scripts work? Both laptops run the same os plus office 2003.

View Replies!   View Related
Open Chosen File, Copy Range & Paste Into Workbook
I'd like to know if it is possible to run a macro in a workbook that will open another workbook (of the users choice) extract data from it, such as columns from its sheets then paste that data into the workbook the macro is running from. The file to be opened will change, so i've found some code that enables the user to select the file to open then open it.

Dim strFile As String
strFile = Application. GetOpenFilename
If strFile <> "False" Then Workbooks.Open strFile

This brings up the standard windows choose file to open box, then opens the selected file. Am I correct in thinking that the Dim here will store the file name I select in the open file box? If so, I'd like to know how to select the workbook using the dim so I can manipulate it from the workbook I'm running the macro in. Incidentally, once the the data has been copied, I'd like the workbook opened with the macro to be closed.

View Replies!   View Related
Copy Cell From Workbook And Paste To Another Workbook's Cell
I need to create an automated process to copy data from book1 and book2 and paste it in another workbook called book3. I want vba code to do this task whenever I open my book3

Book1
Location: G:FUTOMS-phases - eTD and TDReference Infoook1.xls
Data to be copied: Entire Rows 6 to 12
Paste: Book3> Sheet1

Book2
location: H:OptionsInfoook2.xls
Data to be copied:: Entire Rows 1 to 5 & rows 10 to 15
Paste: Book3>Sheet2

View Replies!   View Related
Formula Copy & Paste: Reference Other Worksheets Within The Workbook, Are Copied Over As Links
I'm trying to perform a copy & paste operation by hand which to me should be easy in theory. I have a worksheet whose formulas have been corrupted. I have a backup of this sheet- I'd like to copy the backup sheet into the workbook. The problem is that the formulas, which reference other worksheets within the workbook, are copied over as links to the backup workbook instead of the new workbook they are being copied too. This seems simple, but how do I copy the worksheet and the references without having to go through all of the references by hand to only apply to the local book.

View Replies!   View Related
Open Workbook Where Named Cell Contain Name & Path, Copy Range And Paste Values
I am successfully opening a .csv file using a variable value stored in a named range in my Main file (the variable includes the directory and path).
I copy data from the .csv file to the Main file then I need to close the .csv file without saving but I want to do that by using the

Windows("xxxx").Activate

command where "xxxx" is the namedrange in my Main file which stores the .csv filename (without the directory and path prefix).

I can use the

ActiveWindow.ActivatePrevious

command but if I have another workbook open, this one closes instead of the .csv file I opened from the macro.

I realise this is probably very basic and I've searched the forums but can't find any identical postings.

View Replies!   View Related
Copy, Paste, Change Font Size, Copy, Paste, Print VBA
I'm using 2003.

1. Copy cells B5 to V-First blank row in Strength Tests worksheet
2. Paste cells into Racks worksheet in cell C5
3. Change font size to 6
4. Sort by Column T descending then by Column C ascending
5. Copy one row (A5-W5 (1Rx23C)) from Racks worksheet
6. Paste row into M1 worksheet in cell D4
7. Print M1
8. Drop down one row on the Racks worksheet
9. Repeat steps 5-8 until there's a blank row.

View Replies!   View Related
Copy Multiple Columns From Multiple Excel Files & Paste Into 1 Workbook
I have 8 different files all have a set of data in them

each one has a long list of (column a-n) however the number of rows change by date. I need each file copied into the finalfile.xls one after another. in the files that will be merged into the final file the final row i need copied is blank.
I have all the copy formulas and everything set, I just need a range to copy that automaticaly takes cell a10 to the first blank a cell from each file and pastes it in the finalfile.xls under the last paste so they dont over write each other.

View Replies!   View Related
Copy Range From Closed File & Paste To Closed Workbook
Is there code that will take certain data from one Excel sheet to another named file in a different place on the network? Example Copy cell aa47 from "Recent Faxes.xls" that sits in "correspondence" folder. Then paste into cell B25 "Current Documentation.xls" in the "Sales Contacts" folder

View Replies!   View Related
Copy Data From Another Workbook And Paste The Data From According To The Column Title
I have a time card report which will record the time spent on work for each employee. Each month, i have to generate the time card report and copy the data to my master file. Is there any code that can auto copy the time card entry directly to the master file? I only need some of the entry on the time card report, some of the column can be ignored.

I was thinking of creating a macro that will prompt me to choose the file to import as there are different file for different individual. Attach here with the master list (Demo.xls) & the time card for one individual (Nov-KTTHAM.xls) for reference.

I want to copy the data on column B of the time card to the column A of the master list, column C to column B, column D to column C, column E to column D, column F to column E and column G to column G.

View Replies!   View Related
Copy & Paste Macro Won't Paste
I want this macro to find in this case "406" in column A which is at the very end of the last block of 160 rows of information.

I then want it to move up 159 rows and copy 160 rows of information underneath the last block of information.

i.e.go to A5280 , then go to a5121, copy rows 5121:5280 to 5281.

It falls over on the very last line of code I can see A5281 selected but it won't paste....

View Replies!   View Related
Copy And Paste From One Sheet To Another Based On Column A Using A Macro Copy Button
I want to copy and paste from one sheet to another based on column a using a macro copy button.

E.g. if column a value = apple then copy that row into the apple sheet.

View Replies!   View Related
Copy/paste Macros Will Not Copy Filtered Items
The following sub will look in the file ("FY09 SOF"), in column "A", search for the strings that begin with "2109", "3009", or ends in "-1", and copy the entire row. It will then paste these in the file ("FY09 PR Log Blank").

I have found that in the file ("FY09 SOF"), if things are filtered in any row, it will not copy those necessary items.

The data filter is on row 13 of each sheet. Is there a way of fixing this? (i.e. having the macros select "all" on the filter before copying the sheet? There are 60 sheets so a macros will be necessary.

Sub get_data()
Dim wb As Workbook, wbDest As Workbook
Dim ws As Worksheet, wsDest As Worksheet
Dim lngCalc As Long
Dim FoundCells As Range
Dim FoundCell As Range

Set wb = Workbooks("FY09 SOF")
Set wbDest = Workbooks("FY09 PR Log Blank")
Set wsDest = wbDest.Worksheets("Paste all here, then sort")

With Application
.ScreenUpdating = False
lngCalc = .Calculation
.Calculation = xlCalculationManual
End With
For Each ws In wb.Worksheets.............................


View Replies!   View Related
Copy A Range Of Cells In Another Workbook Opened In A Separate Instance Of Workbook
I m not able to use the standard Excel Paste Special function when I copied a range of cells in another Excel workbook opened in a separate instance of Excel. Instead, Paste Special thinks that I have copied some non-Excel objects and gave me the Paste As options. This is not the case if I open both workbook within the same instance of Excel. Could you share with us if there is a trick to trigger the normal Paste Special options in such situations (without having to invoke Macro procedures)?

View Replies!   View Related
Copy Range To New Workbook & Close Existing Workbook
I have a very brief question

dlgAnswer = Application.Dialogs(xlDialogOpen).Show
Selection.Copy
Windows("Derivative YK pricing Mod G.xls").Activate
Columns("B:B").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Range("C5").Select
Application.CutCopyMode = False
Windows("EXPORT1.xls").Activate
ActiveWindow.Close

As you can see, I open a workbook with the dlgAnswer, I was wondering how I could close that opened workbook

Currently I have

Windows("EXPORT1.xls").Activate
ActiveWindow.Close

however the workbook will not always be called export1.xls, I want it to close whichever one I opened earlier.


View Replies!   View Related
Copy Values From A Worksheet To Another Workbook. Source Workbook Name Unknown
I need to copy a range of values (actually two ranges). The ranges are of fixed size. Le't say A2:D20 and E2:H20.

Both workbooks have the exact same layout, and they both have the same named worksheet (in this case it's called Entry). However the actual filename of the source workbook is unknown. I know numerous users have changed the filename of the xls file.

I want to instruct them to open the old and new workbook, and open a third workbook containing the copy macro, they run the macro and it copies the data.

How can I reference a known worksheet name but of an unknown workbook name esp when the source and destination share the worksheet name?

View Replies!   View Related
Copy Single Call Value From Multiple Workbook To Master Workbook
I have multiple workbooks ( with unique names) under same folder. Each workbook has "Report-Corn" sheet.

I would like to copy cell "P15" from each (workbook-> report-corn -> P15) and paste to Master.xls workbook -> Sheet 1 one after another which is also located under same folder.

View Replies!   View Related
Is It Possible To Copy A Value Without Copy & Paste
Is there a way of having a value that's in cell A1 also appear in cell C1 when the value in A1 changes - but without copy & paste?

View Replies!   View Related
Copy Formats Without Copy/Paste
I currently have a macro that outputs data to a bulletin-board type table in my worksheet. At the moment, what happens is that the macro copies the entire table down one row using copy/paste, then prints a new line of data to the top row of the table.

This works great because it is very fast and because I only have to format each line once--the formats just get copied down every time a new line of data is added.

My problem is that while this program is running, I am unable to use copy and paste in windows, because the copy/pasting from the macro overwrites the windows clipboard.

Is there a way for me to "copy" formats from 1 range to another range of equal size without actually using copy/paste? I know this can be done with values (eg. range("B2:B4").value = range("A2:A4").value), but I can't get it to work with any sort of formatting.

View Replies!   View Related
Copy Worksheets From Active Workbook To A New Workbook
I am trying to code a Macro so that i can take all the worsheets and save them as individual Workbooks. I wrote a macro that appeared to work, but, after it saves the first sheet as a workbook, i get a debug error.

MS VB Script error:
Runtime error '9':
Subscript out of range

Any advise would be greatly appreciated.

Thank you

Code is below..

Sub saveall()
'
'
For Each ws In ActiveWorkbook.Worksheets

ThisFN = "C:Documents and SettingsUserDesktop" & ws.Name & ".xls"
I = I + 1
Sheets(I).Select
Sheets(I).Move
ActiveWorkbook.SaveAs Filename:= _
ThisFN, FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

Next ws

End Sub

View Replies!   View Related
Workbook Too Large After Copy Graphics From Other Workbook
Gosh, the workbook I'm copying the graphs from is only 4 mb in size but after I copy and paste those graphs to another workbook (empty one) it became 122mb in size

Does any of you know why this has happened and how to copy the original size graphs to new workbook?

View Replies!   View Related
Copy From Closed Workbook Then Create New Workbook
I've got a problem with this code, have been wracking my brains about. Here is the process I am trying to do:

1) Copy a range (a2:av1000) but (ideally) find the last populated row from a closed workbook (with a different password)
2) Create a new workbook and paste this data into it at A2
3) Close all the workbooks but only save the new one.

View Replies!   View Related
Copy From Closed Workbook To Open Workbook
I'm trying to write a macro that accomplishes the following:

" Book 1" is already open. The user runs a macro that lists all .xls files in directory "d:measurements" The user selects the desired file from the list or box the macro copies from this "book 2" " sheet 3", " range A6:I107 and pastes (values only) into "book 1", "sheet 5", "range A6" End of macro.

I want to accomplish this without opening the selected file (book 2)

View Replies!   View Related
Paste Special Value Whole Workbook
I am trying to come up with some VBA to paste special value an entire workbook.

View Replies!   View Related
Disable Paste In Workbook
it was possible to disable pasting in an Excel workbook. He didn't want Copy disabled, as he needed to paste data out of this tool into other workbooks, but just wanted Paste and Paste Special disabled while viewing this particular workbook.

Public Sub TogglePaste(booPaste As Boolean)
Dim cmb As CommandBar, cbc As CommandBarControl, cbp As CommandBarPopup
Dim cbpEdit As CommandBarPopup, cbcPaste As CommandBarControl
Set cmb = Application.CommandBars(1)
For Each cbp In cmb.Controls
If cbp.ID = 30003 Then Set cbpEdit = cbp
Next cbp
For Each cbc In cbpEdit.Controls
If cbc.ID = 22 Or cbc.ID = 755 Then
Set cbcPaste = cbc
cbcPaste.Enabled = booPaste
End If............................

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved