고정 헤더 영역
상세 컨텐츠
본문
It could support maximum download speed up to 300mbps. Configuration modem echolife hg520b wifi repeater. HUAWEI EchoLife HG620 ADSL2+ Home Gateway is new wireless router with ADSL technology for home or SOHO office. With one ADSL2+ interface and one interface for 3G USB Modem/Dongle, HUAWEI HG620 has also 4 LAN ports to connect Ethernet cable.
1993 honda cbr 600 f2 repair manual. - Take off across the continent, or fly around town. Featuring a fuel-injected 582 cubic centimeter DOHC engine, a fully automatic CVT transmission, and room for two in the cockpit, the Silver Wing is rider-friendly with its electric start and sophisticated braking system. The Silver Wing gets you there in comfort and style. Category Sport Bikes Engine 600 Posted Over 1 Month 1993 Honda CBR600F2 in great shape. Add super-reliability and a cool aerodynamic profile, and this scooter adds up to one heck of a Honda.
Survey Instrument Data Collector Download code for Nikon, Topcon, Lecia and Sokkia to excel worksheet. Utilizing David M. Hitchner's modComm and Brendan Lambe RS232 Class. Excel Serial Comms Class Example I.xlsm It can be easily adapted to be used with other serial port output equipment or changed to transfer data to a txt file. Excel Serial Communication Example. Download Microsoft Excel Com Port Serial Communication Code at Microsoft Informer: Excel Recovery Toolbox, Barcode Maker, Trim Spaces for Microsoft Excel. An example how to place the StrokeReader serial port ActiveX on Excel 2007 spreadsheet and read data from RS232 port, USB barcode scanner or RS485-equipped.
greetz to you all gurus here I'm trying to find a way to start controlling my serial port from within visual basic in excel. Anybody know how to get a good start in doing so ? Object is to control/communicate a (self built) controller attached to the com port, set and get values back from it using visual basic in excel. Communication already works using hyperterminal, so my only prob is to grab and manipulate the serial port of the pc. Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar Topics
Hi all, I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise. I've written a macro that is relatively simple. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations. Nothing incredibly fancy but it works fine on my computer. Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it. Should be fine and in most cases it is, however there is one user who although they can open the file, can't seem to get the macro to run properly. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. I have checked Macro Security level and that is the same as mine, Tools - Add-Ins is the same, In Visual Basic, Tools - References is the same as mine. It is the same Operating system and the same version of Excel. I have even signed into this person's computer as myself (it's a big company network thing) and tried to run the macro and it works fine, so there is nothing wrong with the hardware. I've googled and searched and tried everything I can think of but I'm no closer to solving this problem, so if anyone has read through this wall of text and can come up with a possible solution, that would be greatly appreciated to save me from tearing ALL my hair out! Thanks very much for your time. I have attached a schedule for shift allowance calculation. The conditions for payment are as follows: 3 & 4 shifts = 15% Basic 2 shifts = 10% Basic If on leave for 21 working days or more, no shift allowance If on leave for less than 21 working days and on 3 or 4 shifts, shift allowance prorated as (Basic*15%)/21*(diff. btw 21 and no of days leave observed) If on leave for less than 21 working days and on 2 shifts, shift allowance prorated as (Basic*10%)/21*(diff. btw 21 and no of days leave observed) The formular I used in the attached worked but the only problem is that I had to sort by no. of shifts and adjust the formular first. I need A formular that does not require sorting. I tried to combine IF, AND, OR formulae but I got error. Please assist me sort this out. Thanks a bunch.
Hello, I'm trying to set up a basic formula to clear out unwanted cells. Basically, if the cell is not equal a number, I'd like it to be cleared of any information. I would rather not use a space, because I have text that is overlapping between cells and would like it to be legible. Here's the basic formula: =if(A1>0, A1, ???) Any help would be great. Thanks! I am trying to correct a formula for a productivity worksheet in excel. The idea is that we would have the ability to input the number of hours worked each day and the number of direct hours (working with clients) per day. Then take the daily percentages and add them then devide them to determine the final productivity percentage for the week. Additionally not everyone works a full week so I would need it to only divide the percentages of the days that were completed. Any suggestions? or does anybody know a formula that would accomplish this already? I am good with basic excel and was able to identify a flaw in the current productivity sheet. Dear Sirs, Am in need for this solution very badly and what could be a better place than excelforum ! I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on. The last column is for hyperlinking photographs of individuals. In the same folder where I have saved this excel file, are lying photographs of individuals. While scanning the photographs, I have saved them serially i.e. 1,2,3 and so on. In the Excel file, in last column, I have given the respective serial numbers. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK. Problem : I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. Solution Needed : Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. Thanks a million and warm regards ::: Jack
From limited experience I know that excel calculates dates via serial numbers. I have formulas to add a number of days to a cell containing an entered date and display the resulting new date (ie. 03/01/2011 (c34)+11 = 03/12/2011) I am seeking to leave resulting formula cell blank until a date is entered in the input cell. Currently when the input cell is empty the formula cell obviously displays 1/11/1900 using the above example. What conditional format would achieve leaving the formula cell blank until date data in entered into the source cell? Hopefully a simpler question for your experience level than mine.
In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? Hi there. I'm using Excel 2007 and often use filters to find inconsistent data (mis-spellings, etc.) and then clean up the data using the fill handle to fill in correctly formatted values. I'm finding that, with a simple filter on, dragging over cells hidden by the filter changes the values in the hidden cells too. This is something I don't remember from my last version of Excel. I'm wondering if I've mis-remembered how this control works, or if there is a setting I can't find. My goal is to drag and fill (or paste) in a colum with a range of rows wiht some hidden (filtered out) rows, and have the filtered out data be unaffected, if that makes sense. Thanks! T
Hello, I have a number of different files that I often need to run a macro on. In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one. Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder. I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames (without referencing the exact filename). I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc. and input the macro I'd need to run in each file in the appropriate location. Is this possible? Any help is greatly appreciated!! Thanks, Jason Hi, I'm trying to get some macros to combine data from two open workbooks, and I can't figure out the commands to switch from the active workbook to the other open workbook and back. I'm new to VBA and just learning the ropes. All I can figure out is how to switch to another workbook with an exact name. If I record the macro to go to a recent file, for example Window > 1 (filename), the code that I get in VBA is Windows('filename').Activate. This doesn't translate to when I have two different workbooks with different filenames open. Make sense? I'm a bit confused myself. Maybe just a list of basic workbook-switching techniques or commands would be useful. - Michael
I am creating a basic accounting spreadsheet and I ask for assistance to automate data entry posts. I would like to have entries that are entered in the general journal automatically post to the corresponding ledger accounts. The entries need to remain in chronological order. Relative cell referencing will not work because the rows in the ledgers will not correlate to the rows in the journal because the journal but the entries in the ledger need to input on the next available row in that ledger account. Additionally, as the number of entries increase, can the ledger accounts add a new row? Attached is a very simple example with three transactions. I have included an end state view in the ledger accounts tab.
I'm using some basic code below in an on Workbook Open event to format cells with a value less then 2 and less than 1 with a particular color. The code works, but it really slows my worksheet down when opening. Is there better way to write this? Thanks! Code: I have a long list of item descriptions that I need to filter down to descriptions containing words like 'valve' or 'ring' or 'root' or 'epic' (17 key words in all). The basic custom filter looks like it only lets me filter for 2 words. I have some experience working with advanced filter for things like >100 but that's about it. Any help with this would be so appreciated.
Thought I'd start this topic since there seem to be a number of topics where the answer seems to be to use one of the above rather than other. Thought I'd kick off with my 2 cents' worth. I have a userform with frames containing textboxes. The user enters a currency value and once they leave the control, then a protected textbox next to it shows the corresponding value in SEK. I started off using the exit event but ran into 2 problems. If you tabbed out of the last textbox in the frame, the exit event never kicked in (this is documented in other topics but took some time to find). This resulted in me using the exit event for all except the last textbox in the frame that used afterupdate insteadI then discovered that the exit events didn't kick in if, instead of tabbing out of the field, I deliberately placed focus in a control elsewhere on the form. Changing the event from exit to afterupdate corrected this.My question then is .. could you guys document in this topic when you would/must use the exit rather than the afterupdate event (or vice-versa). Thanks I am looking for assistance in having one cell in a text format equals another cell that contains a time value in hh:mm format. For example: Cell A1 has a time format (hh:mm) value of 04:00; which is the Start Time. I would like cell D1 to have a text format value of '04:00' (result is dependant upon what is entered in A1). I would duplicate the same formulas to reflect Stop Times in other cells. My final result is to have another cell (F1) use the Concatenate formula to have the Start and Stop time shown in one cell as '04:00 - 12:30'. The times would change based on the Time formated values entered into the Start and Stop time cells. I have researched this in the board and found many excellent ways to do the opposite, but not convert Time format to Text format. Any assistance is greatly appreciated. -Shane
I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a .csv file in order to upload to an application that parses out the .csv data as transactions. The system requires .csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good. But I have to save as a .csv. So if I do that, close the Excel window, and then open again (as the .csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as .csv, close the window and then open that file up again, that dang scientific format is back. Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file? Thanks so much for your help!
Hi Guys, I need help..I am working production scheduling with Start and End time but there is a lunch time and tea time. Is there any formula to calculate Start time to End time with excluding lunch time? Here is example : Lunch time :12:00pm to 1:00pm. Duration Process :6 hours. Start Time (8:00am) End time (5:00 pm) I need a formula to calculate from Start Time 8:00am and what is the End Time? with 1 hour lunch time.. Thanks, ET Hello, As the title goes this is as simple as it gets. The macro worked good when I was using excel 2003 but now that I have 2007 everything works for except the resizing (Picture.Width & Picture. Height). Code: I have tried to record some macros while I am resizing the pictures but to no avail the macros are blank. Please help Thanks! Hi, This is a very basic question, but i have been struggling for hours, so I must ask. I I trying to simply fill a combobox on a userform from a named range on a sheet, I want to populate the combobox as soon as the userform starts. (I launch the userform from a button on the sheet) Where must I place the code? and will this code work? Code: I am very new to vba, so please excuse my ignorance, any help would be greatly appreciated regards jim
Hello gurus! Here's my question..I have a list of numbers and I want to know how many combinations (and what they are) of adding the numbers will equal an amount. e.g. List of Numbers 1 2 3 4 5 6 7 8 9 10 Amount to be reached = 12 These are some of the possible combinations to reach 12 : 2+10 3+9 4+8 5+7 3+4+5 6+3+2+1 Is there a function in Excel that will do this for me? I want to know which numbers (i.e. cells) can be added to reach 12. AND, if possible, colorcode the cells added for each combination. Good luck and thanks!!
Posted this on the Ozgrid forums, but haven't gotten any help yet, so I thought I'd try here too! I've been having a strange problem lately. I have a fairly lengthy macro that works perfectly most of the time. Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. When I click anywhere (trying to select a cell, or an excel menu item..clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated. So if I press 's' it will input 'ss' into the cell, and then when I press enter it will auto-move to the next cell down, but nothing ends up getting saved into the previous cell. I don't understand what's going on at all. I can't think of anything in my macro that would have these kinds of effects. I've made sure that screenupdating is turned back on at the end of every procedure. If I go into the VBE, I can manually run procedures and they all work fine. The only way I've been able to get back to normal is by force closing excel altogether and re-opening. Any ideas? ______________________ Still having trouble, and the same thing is happening with this workbook on two different computers, so I don't think it's a hardware, or OS specific issue. When it gets locked up like this, I can still do anything in the VBE (edits cells, run macros, etc.) with no problems. If I'm in the excel window, I can click alt on the keyboard and the shortcut keys for the menu come up, but I can't go deeper than that by clicking the letter shortcuts, they do nothing. If I use the delete key to delete the contents of a cell, then it gets deleted. But if I type anything else (numbers, letters, or symbols) then it types 2 instances of the key every time, yet when I hit enter, nothing changes in the cell. I also can't really bring focus to the excel window if something else (ie. the VBE) is on top of it, clicking into the excel window just gives the little system 'ding' sound and nothing happens. If I hit the save button in the VBE (since I can't click anything in the excel window), then it seems to snap out of it and go back to normal. I tried searching for anything simmilar to this and can't find anything.. Any help would be much appreciated. This is driving me nuts!
Is it possible to assign values to names in a list, so that when you validate it as a drop-down list, you can select a name from the drop-down and it's corresponding value will be added to separate cell? Basically, I have survey questions which have five possible responses: Excellent - Very Good - Good - Fair - Poor. We want to assign a value to each, 5 for Excellent, 4 for Very Good and so on, so that when a response is selected from a drop-down, it's value appears in a separate cell (so that we can calculate a total and average score from the selections). Thanks B
I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons. Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size. But I did so in a beta file (test file). The real file has become so big (103MB!) that Excel cannot even open it anymore! The file contains archive info that we do not have anywhere else. Is there anyway then to open the file or to reduce its size without opening it (through magics..)? I just honestly don't know how to retrieve that info before deleting that file. Thank you very much for your help. after sorting data in ascending order, how do i unsort it to get back the original format? i can't find the option anywhere on the excel ribbon for this
Hi- I am brand new to Mr. Excel and would love some advice. I searched the boards pretty extensively but could not find what I am looking for..I apologize if this is a duplicate. I am using Excel 2007 How do you automatically add rows and update values for cells to a linked worksheet in which rows have been added? For example: Sheet 1, columns A & B are linked to Sheet 2, columns A & B. Sheet 2 has values in A1:A5 & B1:B5 and Sheet 1, since it is linked, has the same info. I want to add a row in between 3 & 4 on Sheet 2 and want Sheet 1 to automatically add the same row and update the value of the cell in column A & B. Any help is greatly appreciated! John |
Serial Communication Example
I'm having trouble getting code to read the incoming data send by a torque reader I'm working with. It sends a RS232 data stream which our current wedgelink software can be set up to translate it into key presses and then exported to excel. I would like to get the data into a string then cut the string up into an array of arrays to be able to use the data directly with excel. There is a ton of stuff how to do it in other languages but I'm limited to VBA right now.
This link https://dl.dropboxusercontent.com/u/..77/modCOMM.bas has the base code someone wrote where i can open and close the port but im not getting any data or able to hold it open until end of the data feed. I'm still new at this and know I'm missing something.
Serial Port Communication in Excel (VBA) | Electronics Open Source was the first place i found this code. Any ideas?
