Multiple Barcode Scanners: Prevent The Scan From Accepting Data Until The Macro Has Completed Its Cycle
Jan 26, 2007
I use a scanner that initiates a f2 command and trips my macro. I would like to use multiple scanners using a 8 port hub but I am having trouble with a scanner starting my macro and another scanner dumping data into my macro before the first one is finished. This is dropping scanned data into my macros. Is there a way to prevent the scan from accepting data until the macro has completed its cycle.
Can I make the cursor use only 2 columns? In other words, I know that when I scan barcode data into A1, I have the cursor automatically move to B1. BUT, once I've scanned data into B1, how do I make the cursor automatically move to A2?
I need to run this on all cells in column a not just A2...:
Dim ie As Object Set ie = CreateObject("internetexplorer.application") Dim srchtrm As String srchtrm = Range("A2").Value ie.Visible = True ie.Navigate "http://myurl.com=" & srchtrm
I also need to add to this code an option for finding text on the particular URL before the cycle is completed and looped to the next cell.
I have a list of Users in Column A on Sheet 2 and a list of Extension Numbers in Column B.
I'm looking for a way to populate a Cell (F5) with a User and Cell (H5) with the Extension number. I then enter Data into Cell (G3), (G9) and (G10). I would then on enter on Cell G10 update the relevant columns in Sheet 2 and move on to the next user.
I send out 300 or so spreadsheets. The spreadsheet contains lines of products that recipients have on hire. Column L allows to the user to put YES or NO on each line, to state whether it is correct or not. The user then sends this sheet back.
The difficult part for me is I have to open each spreadsheet, and deal with all the instances of NO in column L. It takes almost a day to go through every spreadsheet.
Is it at all possible to have some sort of macro, VBA sript or access front page, that allows me to search all instances of 'NO' in all the spreadsheets which are in 1 designated folder?
Hopefully I am making sense in what Im after.. ideally I'd need a button on a spreadsheet that I click to give me all rows that contain NO in column L.
All the file names will be constant each week. (so each file name will be 01 - Hire List.xls, 02-Hire List.xls, 03-Hire List.xls etc etc).
Bar codes would contain a part number and a quantity.
822808 / 1604 pcs
1st question: I have scanned them into excel, but how does the next scan get into the next cell? It is currently putting multiple scans into the same cell.
2nd question: Can the data be broken up into separate columns? (e.g. Column A = "Part Number", column B = "QTY") I know about text to columns, but I think I have to get the format right?)
I'm looking for a code that will scan the rows (x) (of which there are 10), and print the data for the corresponding columns (y) (of which there are 42).
I'm trying to run a macro that only shows completed projects, which means all elements of a project have been labeled "Completed". See example below; 1868 is the only project I want to see when I run the macro, 1869 and 1870 are fully complete, so I don't want to see them.
Project #Status1868Complete1868Complete1868Complete1869In Process1869Complete1870In Process
I've recorded a Macro that goes through multiple spreadsheets and refreshes the pivot tables in the sheets. I would like the Macro to run without it actually showing it go to each sheet and showing the pivot table updating. Bascially I would like the spreadsheet to remain on the first sheet while it's working with all the spreadsheet in the workbook when the macro is running.
I am trying to cycle ALL open workbooks so that I can choose the file to manipulate in subsequent code this is the code that I am utilizing furhter below
this is my code
VB:
For Each wb In Workbooks If MsgBox("Do you want to do access this Workbook for the Update " & Chr(10) & Chr(10) & wb.Name, vbYesNo) = vbYes Then wb.Activate VI_wb = wb.Name I = True End If Next wb
But for some reason it only loops through .xls and xlm workbooks BUT not .xlsx
is there a way that I can loop through any and all open workbooks.
The reason I do this is because my update are based on many numerous excel workbooks with differnet extentions, and naming conventions and many of the come via email, I cannot use the eact naming convention
I have a macro which works well. All it does is save a file to a specified location on my network. However, after a file is saved there is no prompt telling the user that the file was saved successfully leaving them wondering whether the macro actually worked.
VB: Public Sub SaveAs() ThisFile = Range("X2").Value ActiveWorkbook.SaveAs Filename:="legdcAudits" & ThisFile & ".xlsm", FileFormat:=52 End Sub
I've got a password protected spreadsheet with only certain cells unlocked to allow users to complete them. I need the following to work on Excel versions 2003, 2007 & 2010.
Cell E3 has a drop down list with types of car to choose from. One of the car types is "Pool_Car".
Cell D12 should only be used if "Pool_Car" is selected from the drop down list. If any other car type is selected, and the user tries to enter a figure in D12, I need an error message to appear.
E3 & D12 are unlocked cells.
I'm happy for D12 to become locked & only allow it to be unlocked if "pool_car" is selected, but I've looked elsewhere, but can't find VBA or data validation to work.
I am using Excel 2013 and would like to input data into my spreadsheet using a barcode scanner. I've created some barcodes using an online barcode generator (Code 128-B). My barcodes are text as opposed to numeric. I initially tested it out using Access and it scanned the information just fine. However, when I try to scan in a code into Excel nothing happens, no error, no data, no nothing. Is there something I need to set in the options of Excel to recognize the barcode scanner as the input device? Or is there some other reason why the scanner might not be pulling in the data?
I have a data set that contains a repeating cycle. I want excel to find the first and second occurrence of the data crossing the zero axis and then report the time between the zero crossings. The data is not purely in ascending or descending order and often just changes from positive to negative or negative to positive without hitting the actual 0 point.
I am trying to create a life-cycle management sheet that is simple for the user but gives specific data.
The user would input "Date", "Machine type", "Component Set No.", and "Component". This would happen over a period of time and build up a picture of how often each component was lasting and it's average life in days.
I am fine from the user input side but am struggling to figure out how to extract ONLY the data I need to display in a graph.
For example: If I want to see the average no. of days "component X" is lasting before being replaced I've not been able to extract just that data. I have tried using a pivot chart but this won't do exactly what I'm after.
See the attached for a clear explanation : Component LifeCycle Example.xlsx
I have a button on a userform that will generate certain text in a combo box. The combobox then goes to a worksheet. If I select a second button, I want the first information on the worksheet to clear and accept the new information from the next button.
NOTE: I have it as a combobox so I can either select it from the combobox or click the button. When I select the information from the combobox, it does clear out everything automatically.
Here is my code:
Private Sub CommandButton2_Click() Worksheets("score").Range("B6").ClearContents ComboBox1.Text = ComboBox1.Text + "PASS" Worksheets("score").Range("b6") = Me.ComboBox1.Value TextBox2.SetFocus End Sub
What I think I am doing is clearing the cell, entering my text then going to the next text box, but when I click the second button (same code, text is "FAIL"), I then get "PASSFAIL" in cell B6.
I want it to clear out the previous entry and only use the new one, but it keeps all that I click even though I said to clear the contents.
My company uses 4 types of barcodes 8, 12, 13, & 14 number barcodes for our products my problem is that I can't figure out how to force the barcode to format properly no matter how somebody enters it if they don't use spaces or put them in the wrong spots, I can't use custom formats because there is 4 different layouts
8 digit should be "#### ####" 12 digit should be "###### ######" 13 digit should be "# ###### ######" 14 digit should be "# ## ##### ######"
these barcodes are in columns L, M, & N also right now 'm using a formula in another cell to verify the barcodes by calculating the check digit and comparing it to the check digit typed the formula i'm using is
I have an xls-workbook that is saved in OpenOffice. It has simple formulas that shows correctly in Excel. Excel doesn't solve them before "re-accepting" (like going to formula bar and pressing enter). No editing of formula is needed at all (unless you count "enabling edit-mode" and accepting the empty edit as editing).
Leith Ross kindly helped me with the below macro but for some odd reason, Excel simply does'nt like it and gives me the error message: "Compile Error: Object Required".
I have a spreadsheet that has values in the end column that read Addition, Deletion or No Change. I am trying to get the row cells in Column A to shade red, green or yellow depending on the value of the cells in Column I. I have tried the folllowing:
="IF(I4=No Change)"
I chose the fill to be green for this but when I click OK nothing happens but I do not get any error messages.
I've created a worksheet that uses multiple print macros with defined margins. This works fine with the Epson printers I have, but a user has an HP Officejet Pro K550.
This printer has an option named "Minimize Margins". If this option is checked then you adjust the margins the way you want.
For some reason when this particular workbook is opened you have to manually go and check this option so that the margins can be manipulated. this is a problem b/c my macro prints several reports so it's impossible to set this option.
I then opened a different workbook and it accepted the default setting (option checked). For some reason the workbook I created doesn't.
This code is not accepting the values which is starting from strings like this
for example
bearing 15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID 19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID steel 15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID 19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID spares 15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID
I am trying to scan through all files within a directory and all subdirectories to find files where the name begins with certain characters. Below is code that will accomplish this for a certain directory, but I do not know how to look through the subdirectories within the specified directory. So, the issues are:
1. How do I loop through each subdirectory within a specified directory?
2. I am trying to return the file name, path name (separate from the file name), and modified date. I can return the name. I can return the path, but it includes the name. Is there a way to return just the path?
3. What is the code to return the modified date of the file?
I want to scan the envelopes coming into our postroom and look up the results within excel. I would then if I match the name be able to print out the details e.g. name floor they are located on etc..
