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.
View 2 Replies
ADVERTISEMENT
Dec 12, 2011
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?
View 2 Replies
View Related
Nov 9, 2011
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.
View 5 Replies
View Related
Feb 15, 2013
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.
View 7 Replies
View Related
Jun 23, 2009
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).
View 9 Replies
View Related
Nov 5, 2013
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?)
View 3 Replies
View Related
Mar 11, 2014
Data starts on row 4 of each sheet except for the "Labels" sheet where data is pasted.
I need to skip the sheet if there is no data supplied in it and move to the next sheet.
View 1 Replies
View Related
Jun 3, 2013
I am trialing a WASP scanner that populates a excel worksheet. I am reading Item number (P12345) quantity (Q123) etc.
Currently all readings are in column A
A1 is p12345
A2 is q123
A3 is p123456
A4 is q123
I need to have all item numbers in one column and all qtys in another column and any other data I read in separate columns
the set up or the extraction from column into columns for item, qty, etc
View 2 Replies
View Related
Feb 28, 2007
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).
View 9 Replies
View Related
Oct 6, 2006
I have a large workbook with hundreds of rows of data.
I have sorted the data and ended up with product codes in column A and my data between columns C and V.
I want to do a sumif with a difference if that is possible.
I want to sum all of the data in column C based on the product code in Column A. But I don't want to include any rows of data where Column V is blank.
i.e. If my sumif for a product code covered 3 rows C3:V5
I want to sumif Column C dependent on the product code in column A but I only want to include rows where there is a value in Column V.
So if all of the cells between C3:V3 contain data include count C3.
Moving down to row 4 if this row only has data between C4:M4 don't include C4.
Moving down to row 5 if this row has data C5:V5 include C5 in the sumif.
i.e if there was 100 in C3, 200 in C4 and 300 in C5 the sumif would be 400 because although C4 has a value V4 does not.
I want to roll this out across all of the columns C:V using the same method if possible.
View 7 Replies
View Related
Dec 15, 2008
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
View 11 Replies
View Related
Mar 4, 2014
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.
View 2 Replies
View Related
Mar 29, 2013
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
View 1 Replies
View Related
Jan 18, 2014
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
View 1 Replies
View Related
Jan 27, 2014
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.
View 3 Replies
View Related
Nov 14, 2013
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?
View 3 Replies
View Related
Apr 2, 2014
I have attached the the excel sheet where in i want to calculate the total number of completed data points for one person.
Let's say "Wasim" would have completed 7 tasks and would updated the relevant cell as Completed.
Now in a huge data list How will i find "Wasim" and how do i calculate how many he has completed.
I believe Pivot table would be the answer here but is there any formula which would replace the pivot table?
(Please see the attachment) Example.xlsx
View 2 Replies
View Related
Feb 19, 2008
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.
View 3 Replies
View Related
Apr 30, 2013
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
View 5 Replies
View Related
May 3, 2014
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.
View 3 Replies
View Related
Nov 27, 2009
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
View 9 Replies
View Related
Oct 25, 2009
The Code will not add the found values into the userform textboxe's.
View 14 Replies
View Related
Jan 18, 2013
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).
View 2 Replies
View Related
Aug 13, 2007
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".
The code below is part of a bigger macro.
View 9 Replies
View Related
Jul 5, 2012
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.
View 2 Replies
View Related
Aug 22, 2006
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.
View 3 Replies
View Related
Jul 14, 2014
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
[Code] .....
View 1 Replies
View Related
Jan 5, 2009
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?
View 6 Replies
View Related
Jun 20, 2006
Would like to know is that possible to scan some information, e.g table or figures, into the excel spreadsheet.
View 5 Replies
View Related
Oct 11, 2013
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..
View 3 Replies
View Related
