LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 04, 10:55 PM
Posts: n/a
Default copy\paste from one workbook to another

i don't use copy and paste. if you assign a string to the
source cell then the value is stored in the string. While
the macro is still alive, the workbook can be closed and
the string value is still active. When you open the
invoice file, the target cell can take the string value.


I do many of the quoteforms. If you want to send the
quoteform, directory/folder addresses of both the source
xls and ther target xls to me, i will create a program to
do what you want. It is free till it gets either boring or
time intensive.

confidentiality assured and guaranteed.
See my excel stuff at:

- - Mark
-----Original Message-----

I am an amateur using vb excel 97, I want to copy data

workbook("QUOTE") and paste it into certain cells in

PROGRAM"). It is set up so that the user goes into QUOTE

and makes one
up. Then later on in the week they pull the saved file

back up, click
on sheet1 commandbutton2 whereby this code,


FileName:= "\\Fileserver\spencersshare\RETAIL INVOICE

opens the INVOIVE PROGRAM. I want to set it up so that

before the
INVOICE gets opened, certain cells from the opened QUOTE

ex. A1, A3, B3
etc. are copied, the QUOTE workbook closed, then the

INVOICE opens, the
specific copied cell data from QUOTE and gets pasted into

respective INVOICE cells. I know that it can be managed

to fall in that
order, I just don't know what the code is to do it. I

searched the old
files on here and nothing was really able to help.

any ideas? Thanks


chief's Profile:
View this thread:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
linking cell value in one workbook to a cell in another workbook Jig Bhakta Links and Linking in Excel 1 January 20th 05 06:12 PM
No More New Fonts may be applied to this workbook perplexed Charts and Charting in Excel 1 January 4th 05 07:10 PM
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 3 December 31st 04 10:31 AM
sotring worksheets in a workbook pineywoods Charts and Charting in Excel 3 December 22nd 04 10:11 PM

All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017