Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
put data in to another workbook
From template based workbooks, I want to put data in to a master workbook
on server, using before save event. Is it necessary that I open the master workbook for this? Thanks in advance Sharad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
put data in to another workbook
Well I meant that apart from using SQL commands, is there other way to do
it, without opening the master workbook? "Sharad" wrote in message ... From template based workbooks, I want to put data in to a master workbook on server, using before save event. Is it necessary that I open the master workbook for this? Thanks in advance Sharad |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
put data in to another workbook
Yes, an Excel workbook has to be opened to enter or extract data.
Regards, Alan "Sharad" wrote in message ... Well I meant that apart from using SQL commands, is there other way to do it, without opening the master workbook? "Sharad" wrote in message ... From template based workbooks, I want to put data in to a master workbook on server, using before save event. Is it necessary that I open the master workbook for this? Thanks in advance Sharad |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
put data in to another workbook
You can have your code put in linking formulas, then replace those formulas
with the values returned. This is probably the fastest way if you don't want to open the workbook unless it is a huge amount of data. -- Regards, Tom Ogilvy "Sharad" wrote in message ... Well I meant that apart from using SQL commands, is there other way to do it, without opening the master workbook? "Sharad" wrote in message ... From template based workbooks, I want to put data in to a master workbook on server, using before save event. Is it necessary that I open the master workbook for this? Thanks in advance Sharad |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
put data in to another workbook
Hi Tom, thanks for the reposnse.
I couldn't get what "have your code put in linking formulas" means. Can you please explain? Regards Sharad "Tom Ogilvy" wrote in message ... You can have your code put in linking formulas, then replace those formulas with the values returned. This is probably the fastest way if you don't want to open the workbook unless it is a huge amount of data. -- Regards, Tom Ogilvy "Sharad" wrote in message ... Well I meant that apart from using SQL commands, is there other way to do it, without opening the master workbook? "Sharad" wrote in message ... From template based workbooks, I want to put data in to a master workbook on server, using before save event. Is it necessary that I open the master workbook for this? Thanks in advance Sharad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
1.Open workbook. 2 copy data. 3 replace data. 4 save workbook. | Excel Programming | |||
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |