Excel HT Ticket Maker rev. 4.1.2 (9/2/04) - Page 15 - AVS Forum
Forum Jump: 
Reply
 
Thread Tools
post #421 of 449 Old 03-26-2008, 08:30 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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.
MikeWh is offline  
Sponsored Links
Advertisement
 
post #422 of 449 Old 03-27-2008, 05:15 AM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
You're welcome. My HDTV watching has increased also.

What types of upgrades are you referring to?
hdtvluvr is offline  
post #423 of 449 Old 03-27-2008, 07:04 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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.
MikeWh is offline  
post #424 of 449 Old 03-31-2008, 12:26 PM
Advanced Member
 
R_Willis's Avatar
 
Join Date: Jan 2003
Location: Lebanon, OH; 45036
Posts: 885
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 11
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.
R_Willis is offline  
post #425 of 449 Old 04-19-2008, 10:42 PM
Newbie
 
osquid's Avatar
 
Join Date: Apr 2008
Location: USA
Posts: 1
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
This really is ingenious, nice work!
osquid is offline  
post #426 of 449 Old 10-18-2008, 10:27 AM
AVS Club Gold
 
Alan Gouger's Avatar
 
Join Date: Jan 1999
Location: Florida
Posts: 18,726
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 16
Cleaning up the stickies at the top. Thread now unstuck.
Alan Gouger is offline  
post #427 of 449 Old 10-18-2008, 01:29 PM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
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.
hdtvluvr is offline  
post #428 of 449 Old 02-02-2009, 06:46 AM
Newbie
 
NProszkow's Avatar
 
Join Date: Feb 2009
Posts: 1
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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
NProszkow is offline  
post #429 of 449 Old 02-02-2009, 11:01 AM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
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.
hdtvluvr is offline  
post #430 of 449 Old 02-07-2009, 07:54 PM
AVS Special Member
 
whotony's Avatar
 
Join Date: Apr 2001
Location: near philly
Posts: 1,248
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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.
whotony is offline  
post #431 of 449 Old 02-08-2009, 08:58 AM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
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.
hdtvluvr is offline  
post #432 of 449 Old 02-08-2009, 09:38 AM
AVS Special Member
 
whotony's Avatar
 
Join Date: Apr 2001
Location: near philly
Posts: 1,248
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
actually using neo-office.
guess it isn't compatible with the ticket maker.
whotony is offline  
post #433 of 449 Old 02-08-2009, 10:16 AM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
Yes, neo-office is built on OpenOffice and the VB isn't compatible. Sorry.
hdtvluvr is offline  
post #434 of 449 Old 08-22-2009, 08:00 PM
Senior Member
 
Pringals's Avatar
 
Join Date: Mar 2003
Location: St. Louis, MO. USA
Posts: 273
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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

I have eight different bosses right now. ...Eight. So that means that when I make a mistake, I have eight different people tell me about it. That's my only real motivation is not to be hassled.
Pringals is offline  
post #435 of 449 Old 03-16-2010, 07:16 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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).
MikeWh is offline  
post #436 of 449 Old 03-16-2010, 07:26 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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.
MikeWh is offline  
post #437 of 449 Old 03-16-2010, 07:44 PM
AVS Special Member
 
whotony's Avatar
 
Join Date: Apr 2001
Location: near philly
Posts: 1,248
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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?
whotony is offline  
post #438 of 449 Old 03-16-2010, 08:10 PM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
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?
hdtvluvr is offline  
post #439 of 449 Old 03-16-2010, 08:11 PM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
Quote:
Originally Posted by whotony View Post

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

No
hdtvluvr is offline  
post #440 of 449 Old 03-16-2010, 10:17 PM - Thread Starter
Advanced Member
 
MikeWh's Avatar
 
Join Date: Mar 2003
Location: Holly Springs, NC
Posts: 554
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
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.
MikeWh is offline  
post #441 of 449 Old 03-17-2010, 05:24 AM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
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.
hdtvluvr is offline  
post #442 of 449 Old 02-02-2011, 09:18 PM
Newbie
 
lojoend's Avatar
 
Join Date: Feb 2011
Posts: 1
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10
Does anyone still happen to have the photoshop file for this ticket maker???
lojoend is offline  
post #443 of 449 Old 01-11-2014, 05:35 PM
Newbie
 
nancileep's Avatar
 
Join Date: Jan 2014
Posts: 3
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10

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.

nancileep is offline  
post #444 of 449 Old 01-11-2014, 05:56 PM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
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.
hdtvluvr is offline  
post #445 of 449 Old 01-11-2014, 06:01 PM
Newbie
 
nancileep's Avatar
 
Join Date: Jan 2014
Posts: 3
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10

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.

nancileep is offline  
post #446 of 449 Old 01-11-2014, 06:01 PM
Newbie
 
nancileep's Avatar
 
Join Date: Jan 2014
Posts: 3
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 10

Thanks I'll try this...

nancileep is offline  
post #447 of 449 Old 01-11-2014, 06:15 PM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
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.
hdtvluvr is offline  
post #448 of 449 Old 01-11-2014, 06:27 PM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
Edited
hdtvluvr is offline  
post #449 of 449 Old 01-19-2014, 12:01 PM
Advanced Member
 
hdtvluvr's Avatar
 
Join Date: Aug 2002
Location: Tennessee
Posts: 648
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Liked: 15
Quote:
Originally Posted by nancileep View Post

Thanks I'll try this...

Were you successful?
hdtvluvr is offline  
Reply Theater Room Items & Accessories

User Tag List

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page


Forum Jump: 

Posting Rules  
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off