Referencing Closed workbooks...Help!

  • Thread starter Thread starter chris100
  • Start date Start date
C

chris100

Hi all...

I have a macro to archive some daily sales. What i want to do for th
procedure below is send the info to a closed workbook rather than th
active one. The reason for this is just to keep the active workboo
faster.

So if i wanted say, to append to Workbook "Archive", "Sheet1" which i
held in a folder called "Folder" in the C drive, how would i write th
reference?

Answers on a postcard.....

Thanks for help inadvance,

Chris

Dim SourceRange As Range, TargetRange As Range
Dim SearchRange As Range, LastWrittenCell As Range
Dim i, n As Integer, k As Integer, j As Integer, ItemToSearchFor
'--------------------------------------
' User definitions
n = 6 ' number of columns to append
Set SourceRange = [N2]
Set TargetRange = Range("BD!A1")
'--------------------------------------
Set SearchRange = Range(SourceRange, SourceRange.End(xlDown))
If IsEmpty(TargetRange) Then
Set LastWrittenCell = TargetRange
k = 0
Else
k =
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transferring rows with variable criteria 1
Problem with VBA in Excel 3
If, Then, Cut, Paste, Delete HELP 1
Index and Match - Errors 6
Excel VBA - Updating of data problem 2
import all sheets from a closed workbook 2
Copy cell values to another sheet 9
Code to produce consistent new Workbook name 4

Back
Top