Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-25-2011, 11:59 AM
komobu komobu is offline Not sure what program to use Windows XP Not sure what program to use Office 2003
Advanced Beginner
Not sure what program to use
 
Join Date: Feb 2011
Posts: 34
komobu is on a distinguished road
Default Not sure what program to use

I have been using excel for this, but I am not sure it is the right program.



I disassemble a lot of very complex parts. As a part is removed, it is written down. The fasteners are placed in a ziplock bag, and a label is put in the bag saying where these fasteners are used. Often pictures are taken to facilitate reassembly that may take place a month or more in the future. Often I will have as many as 100 lines for any particular project. then upon reassembly, every removal line is verified to ensure that nothing was over looked.

Now I am trying to automate a lot of this. What ever data is typed into a cell, I would like to click a macro button and have just that cell printed to a 1 inch by 4 inch label. I have a dedicated dot matrix printer just for these tractor fed labels. Basically, what ever cell I am in, that is the cell value that I want sent to the printer. the labels have to be printed one at a time as the removal line is entered. If I tried to print all the labels at once, there is no way I would remember which label fit which ziplock bag. Is it possible to set up a macro that sees what cell I am in, and sends that cell data to the printer? It would actually be better if I could have a heading field that would list the project number and the date, and then the label would have the project number, date and item printed on it. Is this possible?

Another macro button I would like is to insert a jpeg. I would like all the jpegs the same size. If there is a difficult area, for clarity, I would like to enter a jpeg for what ever item I am on. I am hoping to click the button and have an insert pic pop up with a browse screen. Then I would just select the pic and it would be inserted in to a cell for the particular line I am on. Any advice/help setting this up would be appreciated.

Is excel the right program for this? Help setting up the labels to print would really be appreciated.
Reply With Quote
  #2  
Old 02-25-2011, 04:14 PM
macropod's Avatar
macropod macropod is offline Not sure what program to use Windows 7 32bit Not sure what program to use Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi comobu,

Attached to your command button (which I assume you'll place in a cell that remains visible as you scroll around the workseet) you could have a macro as simple as:
Code:
Private Sub CommandButton1_Click()
ActiveCell.PrintOut
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not sure what program to use Scanning into a program? phaz Office 4 02-25-2011 05:23 AM
Abnormal program termination Bestieboy Word 1 04-15-2010 09:16 PM
Not sure what program to use Don't know which program to use! Raner Office 3 12-09-2009 08:08 AM
Not sure what program to use Is Microsoft the right program and what one would I use? Networkrail Office 1 07-25-2009 08:40 AM
setting up a program to run from your calendar mattz76 Outlook 0 08-22-2007 09:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft