Home |
Search |
Today's Posts |
#1
Posted to comp.apps.spreadsheets,microsoft.public.excel.programming
|
|||
|
|||
Can Excel Macros and Ranges be streamed ?
Can data, including Excel macros and ranges be streamed ?
In this case we're using Excel 2002 and ASP. I studied the multiplication table example at microsoft's site and with that I'm able to stream data. It looks to me like it might be possible to modify the code below to do it ... I reviewed the Excel Object model and didn't find anything that looked like it does what is needed. In my case the user wants a working Excel Workbook having a WorkSheet with defined sumations and ranges. There doesn't seem to be a straight forward way of getting that data to him short of giving him a special WorkBook with a bunch of macros in it and having him load that workbook and run a macro to populate things. (That is too complicated for the user, who wants to visit a url and save.) It would be really nice to see defined ranges which were populated VBA style rather than data coming over in html tables. Thanks Can this be extended or modified ? <!--[if gte mso 9]<xml <x:ExcelWorkbook <x:ExcelWorksheets <x:ExcelWorksheet <x:NameSample Workbook</x:Name <x:WorksheetOptions <x:Print <x:ValidPrinterInfo/ </x:Print </x:WorksheetOptions </x:ExcelWorksheet </x:ExcelWorksheets </x:ExcelWorkbook </xml<![endif]-- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding ranges in macros | Excel Discussion (Misc queries) | |||
using named ranges in macros | Excel Discussion (Misc queries) | |||
using named ranges in macros | Excel Discussion (Misc queries) | |||
how do I use formulas with changing ranges in excel with macros | Excel Discussion (Misc queries) | |||
Named ranges in macros? | Excel Discussion (Misc queries) |