or Connect
AVS › AVS Forum › Home Entertainment & Theater Builder › Theater Room Items & Accessories › Excel HT Ticket Maker rev. 4.1.2 (9/2/04)
New Posts  All Forums:Forum Nav:

Excel HT Ticket Maker rev. 4.1.2 (9/2/04) - Page 15

post #421 of 449
Thread Starter 
I am so busy enjoying my hdtv, that I never seem to come back here and check on what is going on in this thread. Good to see you're still helping people out here! I wish I weren't so busy with other project and HDTV watchin, that I could upgrade this thing.
post #422 of 449
You're welcome. My HDTV watching has increased also.

What types of upgrades are you referring to?
post #423 of 449
Thread Starter 
Quote:
Originally Posted by hdtvluvr View Post

What types of upgrades are you referring to?

Oh.. to a newer version of Excel or even better, taking it out of the Excel world and actually making a real, living, breathing application out of it, so that more people could use it.
post #424 of 449
Quote:
Originally Posted by MikeWh View Post

Oh.. to a newer version of Excel or even better, taking it out of the Excel world and actually making a real, living, breathing application out of it, so that more people could use it.

That would rock. Openoffice might be a good platform to design around. Free for all to use.
post #425 of 449
This really is ingenious, nice work!
post #426 of 449
Cleaning up the stickies at the top. Thread now unstuck.
post #427 of 449
Quote:
Originally Posted by Alan Gouger View Post

Cleaning up the stickies at the top. Thread now unstuck.


That's a terrible thing to do.
post #428 of 449
Hi guys,

I think this program is awesome! I was wondering if anyone has ideas to incorporate a seat-map worksheet? I would like to use this for my HS auditorium and I really just need to mail merge the info from one worksheet onto the "print ticket" page?

I am pretty good with excel, but I can't touch on the VB programming. It would be awesome to be able to select seats on my worksheet and then have a radial "print" button to print those selected tickets.

Thanks for any input!

NProszkow
post #429 of 449
It really wasn't designed to handle a lot of different sections/seats.

However, with that said you could set up another workbook with 3 columns of data. Section, seat and Row. Populate 5 rows with the appropriate data.

Open Ticket Maker and go to the ticket page that has the 5 tickets. Set the appropriate fields (Note there are 2 section fields, 2 row fields and 2 seat fields for each ticket) to = the corrrect cell in the new workbook you created. Print the tickets, change the data in your new workbook to the next 5 tickets and print again.

Hope this helps.

To set the ticket fields to your seat info, click on the cell of the ticket for 'Section'. In the fx bar at the top type '=' without the ' then click on Window and select your new workbook, then click on the appropriate cell then click window and choose Ticket Maker. Go to the next cell in ticket maker and do the same thing. Continue until you have changed all 30 fields in the tickets. Now after populating your new workbook with the correct data, print the tickets and then change the data in your new workbook and print again.

It would be more difficult to automate further.
post #430 of 449
any thoughts on passing this along to someone for an update.

i can't get this to work on my mac for some reason.
at the first "next" i get a syntax error pop up that won't let
me move forward.
post #431 of 449
Are you using the latest version of Excel on the Mac? If so, it doesn't support Macros (VBA programming). You will need to revert to an earlier version of Excel (Excel 2004).

Blame Microsoft for removing the functionality with Macs.
post #432 of 449
actually using neo-office.
guess it isn't compatible with the ticket maker.
post #433 of 449
Yes, neo-office is built on OpenOffice and the VB isn't compatible. Sorry.
post #434 of 449
A friendly bump to a great thread from years past.

I was cleaning out my favorites/bookmarks and came across this awesome topic/excel ticket creation tool from years ago. Since there are so many new here who may have never even seen this thread, I thought I should bump it.

If you would like to make your own "Theater Ticket Stub", click this link to return to the front page for the file(s).
http://www.avsforum.com/avs-vb/showt...5#post15769445


Quote:
Originally Posted by Alan Gouger View Post

Cleaning up the stickies at the top. Thread now unstuck.

Alan ... HOW COULD YOU! haha...


-B
post #435 of 449
Thread Starter 
hdtvluvr... nice to see you've kept up with semi-supporting the folks with this thread. It's been a LONG time. I saw it became de-stickified, so I figured fewer and fewer people would be using it.

It's GREAT to know that Jason Hilton is still hosting these files. I think I saw somewhere here, where someone did a VERY good job of porting this over to java or some more appropriate web-ified platform.

Every once in a while, I think about this thing I created (and hdtvluvr greatly helped improve) and wish I created a real web app for it (or more appropriately, got one of the MANY talented programmers I work with to have them take a stab at it).
post #436 of 449
Thread Starter 
Ha! Just saw the recent thread re: a java version. Nice to see people continued to find a need for this type of thing. I actually only used my Excel thing once! Did it on a whim when someone asked if it could be done.
post #437 of 449
Quote:
Originally Posted by whotony View Post

actually using neo-office.
guess it isn't compatible with the ticket maker.

Quote:
Originally Posted by hdtvluvr View Post

Yes, neo-office is built on OpenOffice and the VB isn't compatible. Sorry.


Forgot all about this.
I have open office now, so this should work, right?
post #438 of 449
Quote:
Originally Posted by MikeWh View Post

hdtvluvr... nice to see you've kept up with semi-supporting the folks with this thread. It's been a LONG time. I saw it became de-stickified, so I figured fewer and fewer people would be using it.

It's GREAT to know that Jason Hilton is still hosting these files. I think I saw somewhere here, where someone did a VERY good job of porting this over to java or some more appropriate web-ified platform.

Every once in a while, I think about this thing I created (and hdtvluvr greatly helped improve) and wish I created a real web app for it (or more appropriately, got one of the MANY talented programmers I work with to have them take a stab at it).


I've enjoyed keeping up with this and helping when I can. I haven't seen the java version of this. Anyone have a link?

Where have you been?
post #439 of 449
Quote:
Originally Posted by whotony View Post

Forgot all about this.
I have open office now, so this should work, right?

No
post #440 of 449
Thread Starter 
Quote:
Originally Posted by hdtvluvr View Post

I've enjoyed keeping up with this and helping when I can. I haven't seen the java version of this. Anyone have a link?

Where have you been?

Here's the java thread:
http://www.avsforum.com/avs-vb/showthread.php?t=1204929

I've been enjoying my freakin theater! LOL I haven't added anything major to it in years, so I guess I didn't need any forum help. I know many people must simply vanish after they're done with their HT builds. I also tend to move from one hobby to the next.... I'm involved in a couple other non-HT forums lately... woodworking, etc. Good to see you're still active here. I should probably take some time to look through the forum... maybe find some cool new things for the HT.
post #441 of 449
I visit several other forums now also as some of my hobbies have changed too. I'm slowly getting back to seeing what has changed in the home theater front and occasionally read a few sections here at AVS.

Glad your back.
post #442 of 449
Does anyone still happen to have the photoshop file for this ticket maker???
post #443 of 449

I am  currently using your template to make my own Super Bowl party ticket.  It is awesome!  Thank you so much.  I have one question.  I am trying to select a color scheme but getting a pop up message that the macros in this program are not enabled.  Any tips or tricks so I can select a new color scheme?  Thanks! Nanci P.

post #444 of 449
Well, you need to enable macros in your Excel. How to do that depends on your version of Excel.

If you are running Excel 2003, you can find the answer here:

http://jeeshenlee.com/2010/09/25/how-to-enable-macro-in-excel-2003/

For 2007:
http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx

I would Enable All macros since this workbook isn't Digitally Signed. If you aren't uncomfortable leaving Excel that way, you can set it back when you are done with the TicketMaker.

BTW, MikeWh is actually the creator/owner of this Ticketmaker. I just helped with some of the coding to get it to work in the Mac environment.
post #445 of 449

Hi- I'm using your program in Excel (Mac) to create a Super Bowl party invitation.  However, I keep getting a pop up message that  the macros are not enabled.  How do I fix this?  I've made all my text changes but can't select a color scheme or move on to the next screen.

 

Thanks,

Nanci P.

post #446 of 449

Thanks I'll try this...

post #447 of 449
It depends on the version of Excel for Mac that you have. The 2004 version removed Macro functionality. I have Excel 2011 for Mac and Macros are back.

In this version of Excel, Click on Excel at the top of your screen, choose preferences, then choose security. Then uncheck both boxes on this screen.

You could check the bottom one and it should prompt you as to whether to Enable or Disable when the file opens. Just be sure to Enable when asked.
post #448 of 449
Edited
Edited by hdtvluvr - 1/11/14 at 8:10pm
post #449 of 449
Quote:
Originally Posted by nancileep View Post

Thanks I'll try this...

Were you successful?
New Posts  All Forums:Forum Nav:
  Return Home
AVS › AVS Forum › Home Entertainment & Theater Builder › Theater Room Items & Accessories › Excel HT Ticket Maker rev. 4.1.2 (9/2/04)