Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Applications in Excel
Can you run an application from within Excel? I have a program from
our database that creates an Excel spreadsheet for me but I have 7 of them (climbing to 15) to do all the time and I need to filter, combine and sort the data into 1 workbook and individual worksheets with a master. I was wondering if I created a macro to do this for me if it would run the program from our database? I hope I provided enough information. Thanks! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Applications in Excel
Yes
You can run a macro in one workbook that can open several other workbooks, process data in the varous workbooks, and then combine the results. -- Gary''s Student - gsnu2007k "Snailspace" wrote: Can you run an application from within Excel? I have a program from our database that creates an Excel spreadsheet for me but I have 7 of them (climbing to 15) to do all the time and I need to filter, combine and sort the data into 1 workbook and individual worksheets with a master. I was wondering if I created a macro to do this for me if it would run the program from our database? I hope I provided enough information. Thanks! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Applications in Excel
Can I run another program as well? Our proprietary database runs a
report that exports to an excel file. Can I setup Excel to run that application from a network drive location? Thanks for the response.... On Oct 21, 12:00*pm, Gary''s Student wrote: Yes You can run a macro in one workbook that can open several other workbooks, process data in the varous workbooks, and then combine the results. -- Gary''s Student - gsnu2007k |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Applications in Excel
Your macro can also include SQL statements that the database can interperate
once you specify the links to the database. However, I would get the dabase to do the preliminary filters and calculations before you import them. If you can't do this ask the IT department to do this for you, be very careful in the specifications and import the data from queries rather than the raw data. Regards Peter Atherton "Snailspace" wrote: Can I run another program as well? Our proprietary database runs a report that exports to an excel file. Can I setup Excel to run that application from a network drive location? Thanks for the response.... On Oct 21, 12:00 pm, Gary''s Student wrote: Yes You can run a macro in one workbook that can open several other workbooks, process data in the varous workbooks, and then combine the results. -- Gary''s Student - gsnu2007k |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Applications in Excel
Hi,
In some cases you can use the VBA's Shell() command to run other programs outside of Excel but these are executable programs. Technically, you can run other programs which use VBA from inside of Excel by referencing the Object library of the other program. However, all of this is no small challenge unless you have a strong programming background. It is best to see if you can "pull" the data from the other program using either a pivot table or an External data connections through a query. -- Thanks, Shane Devenshire "Snailspace" wrote: Can I run another program as well? Our proprietary database runs a report that exports to an excel file. Can I setup Excel to run that application from a network drive location? Thanks for the response.... On Oct 21, 12:00 pm, Gary''s Student wrote: Yes You can run a macro in one workbook that can open several other workbooks, process data in the varous workbooks, and then combine the results. -- Gary''s Student - gsnu2007k |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Applications in Excel
Thank you all for your help! Now that I know it is possible I will
work it out! Now the journey begins! On Oct 22, 2:04*am, ShaneDevenshire wrote: Hi, In some cases you can use the VBA's Shell() command to run other programs outside of Excel but these are executable programs. *Technically, you can run other programs which use VBA from inside of Excel by referencing the Object library of the other program. * However, all of this is no small challenge unless you have a strong programming background. *It is best to see if you can "pull" the data from the other program using either a pivot table or an External data connections through a query. -- Thanks, Shane Devenshire |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Installation of Excel and other MS Applications | Excel Discussion (Misc queries) | |||
Exciter: Custom Excel Applications | Excel Discussion (Misc queries) | |||
My formulas do not calculate in some Excel applications - help! | Excel Worksheet Functions | |||
Seperating two excel applications | Excel Discussion (Misc queries) | |||
Applications of Excel in different industries | Excel Discussion (Misc queries) |