Re: embedded dynamic interactive menus in powerpoint presentation mode linked to Exc

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

David and Steve,

Thank you! This points me in the right direction and more importantly,
inspires. I believe this method would be usefulfor many people.

David, it looks like I should pick up your book. It is definitely
appropriate for my task....and much more relevant.....than the text I bought
last night. :-)

Steve, thanks for the pointer to those specific examples.

It does look like if I put these elements together I can make this work. I
only wish I had more talent as I only generate code myself when I must do so
to bring a vision forward.

I will plug away at this and let you know all how it goes.

Any more comments/ thoughts are appreciated

Dr Edward L. Principe

Focused Ion Beam Applications Developer, North America

Carl Zeiss SMT Inc.

Nano Technology Systems Division

"Steve Rindsberg" <abuse@xxxxxxxxxxxxx> wrote in message
news:VA.00003898.278a5468@xxxxxxxxxxxxxxxx
In article <Xns99B160A413948marcoNOSPAMloyolaedu@xxxxxxxxxxxxx>, David M.
Marcovitz wrote:
As Steve said, this is almost definitely possible, but it will take a lot
of VBA work to get it to work. I have much simpler quizzes on my site
that might point you in the right direction. However, my quizzes use
regular autoshape buttons, not pull-down menus, for answers.

Ah, good. It shouldn't be too difficult to change the examples to work
with
listboxes. Here's some help with those:

Manipulating Listbox and Combobox controls on slides
http://www.pptfaq.com/FAQ00439.htm

Additionally, my quizzes keep track of the answers either in PowerPoint
itself or by writing to an external text file (see the More Tricks
section of my site).

If the text is written out in CSV format, Excel will happily open it.
In fact, on a normal Office install, Excel will have taken over
"ownership" of
CSV files; iow, they'll get an Excel icon and will automatically open in
Excel
when doubleclicked.

To write CSV each record should be a single line and each field should be
surrounded by quotes and separated by commas.

"each","field","should","look","like","this"



I believe that Shyam (http://skp.mvps.org/) has some
stuff on his site about populating combo boxes (pull-down menus). I know
that others have done some stuff to have PowerPoint communicate with
Excel, but I can't remember who off the top of my head. So, all you have
to do is pull together these three elements, and you will have what you
want.
--David


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================




.

Relevant Pages

  • Re: Preserving "trailing" zeros from csv file
    ... My mistake, David. ... I was probably thinking of Lotus which put quotes around text values, but Excel certainly doesn't. ... So, as you say, the formatting is lost on reopen. ... In Excel 2003, if you have one cell with 123 formatted as a number with 3 decimal places to show 123.000, and another cell with the text value 123.000, when it is saved as a csv they both show as 123.000 in the csv file. ...
    (microsoft.public.excel.misc)
  • Re: Convert CSVs to Excel workbook
    ... If the file has the extension .CSV, then Excel will just open the file. ... "David" wrote in message ... >> My quesion is how to convert the CSV's to Excel workbook? ...
    (microsoft.public.excel.programming)
  • Re: "Unable to open data source" in mail merge
    ... Do you mean a .csv, which is a delimited text file that you can open in, and save from, Excel? ... STEVE wrote: ... "Peter Jamieson" wrote: ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Using other workbooks..
    ... David Munday ... I have attached the VBA code. ... and it pulls in data from another Excel spreadsheet of that same name e.g. ... Excel file the name of the sheet the data is kept on (unless it is the ...
    (microsoft.public.excel.worksheet.functions)
  • TechEd 2004 Europe - Which speakers/sessions to attend?
    ... David Chappell ... Christian Weyer ... Mark Russinovich ... Steve Smaller ...
    (microsoft.public.vsnet.general)