ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can excel export to, run, and run a spread sheet that is closed? (https://www.excelbanter.com/excel-programming/409556-can-excel-export-run-run-spread-sheet-closed.html)

mrogers

Can excel export to, run, and run a spread sheet that is closed?
 
I am trying to have one main work book that I can:
-(1) Input data
-(2) Have that data exported to a closed excel workbook that modifies it and
-(3) returns it to the first workbook.

thanks

ryguy7272

Can excel export to, run, and run a spread sheet that is closed?
 
Not sure what you are trying to do, but look here for some ideas:
http://www.rondebruin.nl/tips.htm

This may be most relevant for you:
http://www.rondebruin.nl/ado.htm


Regards,
Ryan---

PS, maybe you should look into using Access for some of these things;
certain things in Access are much easier to do that certain things in Excel.

--
RyGuy


"mrogers" wrote:

I am trying to have one main work book that I can:
-(1) Input data
-(2) Have that data exported to a closed excel workbook that modifies it and
-(3) returns it to the first workbook.

thanks



All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com