Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac Excel 2008 question
Greetings,
Two questions: 1) What happened to the microsoft.public.excel groups? I've been away from them for about a year or so and have discovered that some of them have almost died in the meantime. Is there another site which has taken the traffic? 2) My main question I am asking this here because the charting group is dead and also because some here might have experience trying to work around the lack of VBA in Mac Excel 2008. I made a chart (in Excel 2003 on Windows) to analyze a fairly large set of scienctific data. The data evolves over time. In such a situation I like to create simple animations which show how the data evolves over time. I have done this many times using simple VBA macros. My problem now is that a colleague of mine uses a Mac and has Excel 2008 which is crippled w.r.t. VBA. My macro was just a simple time loop that updated the contents of a certain cell 10 times per second, after which spreadsheet formulas involving named ranges control what data is actually plotted. I read online that you could at least use form controls (but not Active-X controls) on the Mac version - so I made a different version of my spreadsheet with the macros deleted but with a slider (scroll) bar inserted and linked to a cell controlling the time parameter. The idea was to create a semi-automatic version where the animation is implemented by the user sliding the bar. It works quite nicely -- on Windows. It sort of works on the Mac - but the animation aspect (more or less the point of it all) doesn't work. The Mac version waits until the user releases the control before updating the chart so that if you slide through several animated seconds on the Mac the graph just lurches to the final state without displaying any of the intermediate states. I know almost nothing about Macs and even less about Excel on the Mac. Is there any way to get charts in Mac Excel to update in real-time? Thanks -scattered |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac Excel 2008 question
Could you persuade your friend to upgrade to Excel 2011 on the Mac, so
that the macros that you originally had would work on that? Pete On Apr 18, 9:38*pm, scattered wrote: Greetings, Two questions: 1) What happened to the microsoft.public.excel groups? I've been away from them for about a year or so and have discovered that some of them have almost died in the meantime. Is there another site which has taken the traffic? 2) My main question I am asking this here because the charting group is dead and also because some here might have experience trying to work around the lack of VBA in Mac Excel 2008. I made a chart (in Excel 2003 on Windows) to analyze a fairly large set of scienctific data. The data evolves over time. In such a situation I like to create simple animations which show how the data evolves over time. I have done this many times using simple VBA macros. My problem now is that a colleague of mine uses a Mac and has Excel 2008 which is crippled w.r.t. VBA. My macro was just a simple time loop that updated the contents of a certain cell 10 times per second, after which spreadsheet formulas involving named ranges control what data is actually plotted. I read online that you could at least use form controls (but not Active-X controls) on the Mac version - so I made a different version of my spreadsheet with the macros deleted but with a slider (scroll) bar inserted and linked to a cell controlling the time parameter. The idea was to create a semi-automatic version where the animation is implemented by the user sliding the bar. It works quite nicely -- on Windows. It sort of works on the Mac - but the animation aspect (more or less the point of it all) doesn't work. The Mac version waits until the user releases the control before updating the chart so that if you slide through several animated seconds on the Mac the graph just lurches to the final state without displaying any of the intermediate states. I know almost nothing about Macs and even less about Excel on the Mac. Is there any way to get charts in Mac Excel to update in real-time? Thanks -scattered |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell 2008 Mac Question | Excel Discussion (Misc queries) | |||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days | Excel Worksheet Functions | |||
(Fussball Spiel EM 2008) [1/3] - "Fussball Spiele EM 2008.sfv" yEnc (0/1) | Excel Discussion (Misc queries) | |||
(Fussball Spiel EM 2008) [1/3] - "Fussball Spiele EM 2008.sfv" yEnc (1/1) | Excel Discussion (Misc queries) | |||
DOWNLOAD CRACKED 2008's SOFTWA ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008 | Excel Programming |