( SOLUTION NEEDED ) Far Point Spread


hai friends,   Code:is any one familiar will FarPoint Spread sheet.in our project v r using VB & EXCEl.For excel, i used Far Point Spread.its working for me, without having Ms Excelits loading an excel file & values r added to the excel file.I don't know how to edit,delete, save the added the values.Any one who is aware of this Far Point Spread can help me to proceed my project nathanks & RegardsEdited by - Geethahiren on 4/1/2005 4:44:48 AM

View Answers
Very similar questions



Printing The Contents Of A Single Control www.codeguru.com

I have a Far Point Spread control on my form which is like an excel sheet and I wish to print this spread along with its data.How can this be done?In general can we print a single control (like a textbox or datagrid) along with its contents?Please help.Thanks in advance.Ekta.

Spread Control [FarPoint] www.vbforums.com

Hi all.I'm using the FarPoint Spread control and need to get a command button embedded into the spread [so when the spread scrolls the button stays in the cell/position it was embedded in and scrolls with it]I've tried using Spreads CellTypeButton but it looks as thou you can only call pre-defined Spread functions, which is not what I need as I have my own function the needs calling on click.I've tried the standard VB CommandButton but button does not link/embed itself to the spread it floats on top so when you scroll down on the spread the button remains in the same position.....Can anyone help out with this one pls??Many thanks.Rocks

Spread Control www.codeguru.com

Hi,I am using FarPoint Spread control in my VB6.0 project. One of the form in the project contains 3 spread controls. I have to print contents all the 3 spread controls on a single sheet. Using the available properties, one spread only can be printed on one sheet. Does anybody have a solution for this??Thanks in advance.

World Cup Formula Greater / Less Value www.excelforum.com

I'm trying to find a formula to use for a specific numerical outcome. For example say you have two teams playing throughout the year and you've made a prediciton on the results. If your prediction is correct your awarded 7 points if you predict a win its 3 points and if your incorrect than it's zero. what is the formula for awarding points? I've attached the spread sheet : FIFA Spread sheet.xlsx‎

Can I Select Subset Based On Time Of Entry forums.databasejournal.com

A table gets data every 4 minutes, I only need spread of every 15 minutes. Can I select only records spread every 15 minutes apart from this table without having to run a scheduled job every 15 minutes and loading one record closest to getdate() at that point into another table(this is how I am doing it now) Is there a better way. Please help Thanks

Spread Sheet Printing www.codeguru.com

Hi All,I have an OCX, which consists of a Spread control ocx (Farpoint Spread3.0). I want to print the contents of spread sheet. I have used the Action property of Spread which is set to SS_SMART_PRINT. But in the resulting print sheet, columns are coming only partially. Could anyone tell me a solution for this?Thanks in advance,Regards,Sajitha

Component Busy Message ?????? www.xtremevbtalk.com

I am transferring the data from excel sheet to spread sheet in vb.But when the number of records in spread sheet exceed 900 it gives the component busy message and my application and system hanges.If the number of records is lesser say 500 no such message is reported and my application runs fine.I will be oblieged if some one can give me a solution of the problem as I have to transfer at least 10,000 records to my spread sheet. thanks Upasna

Data Query www.codeguru.com

Hi, I need help for data query from 1 spread sheet to another. I will enter data on 1 spread sheet but the other spread sheet will also updated. But the latter spread sheet will be updated only if 2 of the data fields are the same as the former spread sheet. Hope to get some advise on this. Thanks.

Conditional Format To Identify Formula Cells www.ozgrid.com

This should be pretty straight forward but the solution has escaped me so far. I have some formulas that ratably spread monthly budgets across the life of a program. Ocasionally these budget formulas are hard keyed over with a value which overrides the ratable budget formula. I would like to conditionally format all cells that contain hard keyed values so they don't get inadvertently copied to new budget lines.

Two Excel Questions www.xtremevbtalk.com

1) How can I divide up a spread sheet so that a portion of the page will scroll while the rest of the page is stationary?I recently saw an excel spread sheet that was divided up into 3 sections. There was a section on top, a section along the left side, and the 3rd section was all the remaining cells underneath/to the right. Somehow, it was made so that when the user scrolled up/down, only the bottom two groups would scroll, and when the user scrolled left/right, only the right two groups would scroll.It is hard to find out how to do this if I don’t even know what the feature is called. Anyone know what I am describing?2) How can I sum up [a range of] cells across different spread sheets within the same excel file?I have a list of data [numbers] on one spread sheet. I would like to access these values on another spread sheet. Is there a way to point to another spread sheet’s cell values in a formula?


VS 2010 Clean Up XML Hack? www.vbforums.com

I need to simply identify if a particular tag occurs in an XML document. At this point my XML solutions, much like my regex solutions, are based on limited knowledge and are far from elegant. Is there a better way to achieve the following: For Each e As System.Xml.XmlElement In xmldoc.GetElementsByTagName("stat") parse = False Next

So Simple I'm Afraid To Ask... www.xtremevbtalk.com

I posted this message to the VBA forum and realized after the fact that VB 6.0 is NOT VBA (whoops!).All I need to do is use VB 6.0 to open a VERY SIMPLE (and small) Excel worksheet and read/load data from various cells into variables, (or arrays, text boxes, etc - you get the idea). Once I get the data from the spread sheet into the app, I'll be able to process it myself, and I have no need to write back to the spread sheet. Have read examples, including those which use ADO to manipulate the data, write to cells, create new columns and rows, create spread sheets from scratch, etc - all sorts of higher level stuff I don't need to do. But none so far show how to do the above mentioned. Thanks ahead for help!

Display MsgBox If Sum Of Column Is Zero www.ozgrid.com

I have a file with 2 tabs that linked 1) Input 2) Spread. The idea is for the user to spread the total number they keyed in the "input" by months. I need a code that will display a msgbox if the sum of the variance column in Spread <> 0, so it can prompt the users that they still have to do the spreads before closing the files. I want the action to happen when they attempt to save or close, just to remind them it's not done yet.

Gradient Colorize Chart Points Based On Cell Reference www.ozgrid.com

Conditional formatting is lacking. I need to colorize each data point on the graph according to a characteristic cell (not an x-axis or y-axis variable). I have done something similar by simply graphing a group of points as a series and changing the series color. I'm looking for a more graceful solution. From the example picture attached (i would attach a workbook, but the data is sensitive), a point is charted based on two variables and colorization is attempted based on the third variable. i would find the range of the third value, assign a gradient based on the spread, and colorize each point. My VBA syntax is lacking for chart functions

Left 4 Dead DirectX Crash www.sevenforums.com

Just my bad luck - first CoD4 crashes with DirectX error and now Left 4 Dead does that too (those are unrelated problems as far as I can tell, but still) Anyways, straight to the point: I get "Failed to lock index buffer in CMeshDX8::LockIndexBuffer" error right after intro movie starts. So far none of the solutions I found thanks to google worked so I was wondering if any of you nice people seen that problem. Or even better - solution. Made me sad when two of my favourite games refused to work in freshly installed system

Macro To Create Multiple Tabs With Same Spreadsheet On And Date Them www.excelforum.com

I am trying to create a workload spread sheet for work I need to have the same looking spread sheet 365 times but also need each sheet to be dated, EG (tue,01/04/2014 through to tue,31/03/2015) I can create 365 tabs that have the same spread sheet on and I can create dates but not do both at the same time, it isn't fun doing copy and paste 365 time.

Find Numbers That Equals A Sum In An Array? stackoverflow.com

I want to find the first set of integers in an array X that the sum equals a given number N. For example: X = {5, 13, 24, 9, 3, 3} N = 28 Solution = {13, 9, 3, 3} Here what I have so far : WARNING, I know it uses global and it is bad,that's not the point of the question. <?php function s($index = 0, $total = 0, $solution = '') { global $numbers; global $sum; [Code]... I don't get how I can stop the process when it finds the solution..

Accessing SQL 2000 Table From Within Excel bytes.com

Hi, I have a need to process a column of data and get information from SQL 2000 and return it to the Excel Spread Sheet. The data will be a list of order numbers in column 1. I need to look up each order number and return infomration relating to the order from SQL. Can anyone point me to the right process? thanks in advance,

Set The Position Of Farpoint Spread? bytes.com

i developing a application in vb.net using third party tool Farpoint Spread control i need to set the position of spread while we enter in another spread cell?

ActionScript 2.0 :: Adjusting Start Page In Pageflip www.actionscript.org

I'm trying to get it to start and end on a spread rather than with a front cover and back cover (with blank space on the left and right). I just need to flip between two spreads.I have gotten it to start on page2, but it appears on the right rather than on the left as a spread. I tried getting rid of ename="blankpage"; on line 123 and 127, but it only caused order issues.

CR8.5 Control Line Graph Markers www.codeguru.com

Dear All,I have a line graph where the markers are displayed at every point, I have a maximum and minimum point in the graph and the marker must be displayed only at these points and not all along the line. I tried the show markers by turning it on and off, but either they display the marker at all points along the line or they don't display the markers all along the line. I need them only at the maximum and minimum point. I am very desperate and need to find a solution immediately.Can anyone pls help.Thankx,Vicky

Networking :: "campus" Wifi On-the-fly "campus" Wireless Network? www.linuxquestions.org

discover HOWTO for an on-the-fly "campus" wireless network? I will be part of a large youth sports event spread over several acres of grassy fields. I need a wireless network for the event operations and administration. I want to operate a private wireless lan, "under the stars" with a few puddles of kiosks participating. Some of my thoughts:I need some sort of antenna for outside use with wifi. I need a primary wifi access point.I could use a wifi router & access point to connect with the primary for each kiosk puddle.I could use a pair of wifi router & access point boxes, with directional antennae, as point to point.phone and tablet and pda and laptop boxes, in the hands of staff,could use this private wifi lan for event operations.I could put a LAMPP or XAMPP server someone on this lan for event operations The server could have a connection to the public internet somehow If I used one of the linux open-source wifi box, hotspot images or similar, I could manage this lan as a group of steamer-trunk, drop and setup stations.

IPhone :: 4 Bricked During Update On Day 1 - No Jailbreak discussions.apple.com

Finally got my new iPhone 4 today. Then it threw an error during update, and now iTunes says my iPhone needs recovery. But that throws an errors as well, at the point where it tries to restore the firmware. Happened thrice so far, exception code 9. So... do I have a very stylish brick lying here or does anyone happen to know a solution to this? Information:

How To Change The Col Size Of A Far Point Spread At Runtime www.codeguru.com

Hi guys please help meScenario:Iam populating the far point grid by assigning a recordset to its datasource property.In that there is one remark column which contains 255 characters but iam able to see only 60 characters.What are properties i should set for this in the design time as well as at the runtime

Formula For Number Of Perfect Ordered Needed To Achieve Certain Target www.excelforum.com

I was working on a chart to calculate my Amazon seller rating to see how many more perfect order I need to hit my next target grade. Here is how the calculation works. Order with no problem gets 100 points per order Minor problem gets 0 point Moderate problem minus 100 points Severe problem minus 500 points Grade are evaluate by: <84.5 Fair <96.5 Good <98.5 Very good Above is Excellent Total points / total orders = final grade (or percentage) As of now i got : 53800 (points) / 624 (orders) = 86.22(%) Now that I know what grade I've got so far and I also want to know how many more perfect orders I need to achieve my next targets or in case some bad orders come by and how far they pull me down. Attached is my work sheet so far and I'm just missing the calculation for the orange shaded part. Amazon seller rating calculator.xlsx‎

ActionScript 3.0 :: Way To Get The Mouse Pointer Location Outside Of An Event? www.actionscript.org

I have the gun all coded and setup, it's an automatic weapon that fires at the mouse as long as you hold down the trigger, seems simple enough. It updates the target point whenever the user clicks or moves the mouse.My problem though, is that it can't so easily update the target when the user moves their avatar via keyboard keys. As they do this, the target remains at a constant point in worldspace, getting farther and farther from the mouse pointer until they click again or move the mouse. While not a huge issue, this is annoying.A dirty solution I can think of would be updating the target point according to camera movement so that it should follow the mouse even when the mouse isn't moving. This solution seems like a lot of unnecessary work though and I'd like to explore the apparently simpler route first.

Copying .xls File Numerous Times And Rename Each File From .xls Spread Sheet www.mrexcel.com

I have an excel template that needs to be copied multiple times and each sheet needs be named according to a list in an excel spread sheet. I also have a formula in the template that needs the value copied instead of the formula. I got this script from an site and tried it. It runs but I don't see any spread sheets. strComputer = "." Set objWMIService = GetObject ("winmgmts:\" & strComputer & " ootcimv2")

Create A Windows Shortcut? stackoverflow.com

I'm writing a script to tidy up a bunch of media spread across my hard drives, and it works pretty well so far at home (on my Mac) as I use symlinks in a directory to give the impression that everything is organised in one location, whilst the actual data is spread across the 4 drives. Unfortunately, I have to use Windows at work, and of course there's no symlink support there until PHP 5.3 (and I assume that requires Vista as that's when the command-line tool "mklink" first appeared). As a workaround, I considered creating a shortcut, but I can't find a way of doing it. Is it possible, or is there a better solution I've not considered?

VBA Select Data For Graphing? www.mrexcel.com

I have a spread sheet that we input data on and produce a simple graph. When I started we plotted these graphs by hand on chart paper. When we started using spread sheets I learned how to graph the problem is these guys we have working in the field don't know how or care to learn how to make a simple xy graph. Six months ago I started automating a workbook so our field guys could just plug in numbers and have the needed graph, I put check boxes to select the points to calculate the slope and intercept. I hard coded to plot to say line 21 then at the end of the test we always have a zero point that we don't plot so I put that on line 22 then have a macro to hide everything before I print it. I think I would like to dynamically select the data for graphing but I'm not sure about the best way to do this. My first thought is to key on the x axis column with a loop and graph data from zero until the x looses value.

Firewall Load Balancing Recommendation Needed www.webhostingtalk.com

Can any one recommend a firewall which supports load balancing? We have a number of servers with in our rack which are currently hosted behind one firewall box but I would like to have the firewall load spread across multiple boxes. Ideally this needs to be an open source solution. We have Looked at IPCOP, pfSense, m0n0wall but these dont seem to support the sort of load balancing we require.

Vlookup Across 12 Worksheets www.excelforum.com

I've being asked to create this awesome new spreadsheet that summaries data from two other spreadsheets. I personally have no idea about excel but have gotten quiet good with the vlookup and isna formulas etc and so far so good. Till i had to search for a value over 12 worksheets. Ive tried Vlookup using an indirect formula using named cells etc i found but i cant work it out and all this reading has turned my brain to mush. So what im trying to do is: I have a new spreadsheet called summary. What i need to do is pull sales data through from a spread sheet called "Sales Orders_2009". In the spread sheet there is multiple tabs, 12 of which i need to search. The tabs are called SalesJan, SalesFeb etc. On each tab i need to search in the data range B10 to I34. In the Summary spreadsheet i type an invoice number into A2 and that is the lookup value to search for across the 12 worksheets.

Difference Between Start And End Dates www.excelforum.com

I need to compute the no. of days between start and end dates and spread no. of days on each month. I've attached a spreadsheet with examples and further explanation.

Creating An Editable Style Sheet www.codingforums.com

I'm trying to create a script that opens a css style sheet and inside a form field, inserts the data from the style sheet, so that it can be edited as a whole. I'm also trying to have a submit button that writes the whole thing back to the file. I know to open the file, I need to use fopen(), but that's about as far as my knowledge spreads. And I also know that the script isn't unique to a css stly sheet but could be used for any file.

Dropdown Listbox Question www.xtremevbtalk.com

I have a dropdown list box that I want to have the box small but when selected the data spreads out across as far as it needs to go. Forgive if it doesn't line up. Any help is appreciated.exampledropdownbox display = N1 click display would go N1 / LONG INFORMATION N2 / LONG INFORMATION

Search For Number Within Alphanumeric Text? www.mrexcel.com

I have data on two spread sheets which I am trying to cross reference. On the 1st spread sheet I have a list of product codes e.g. 22886, On the 2nd Spread sheet I have a list of product titles which all include product codes within the text e.g. CHRISTMAS FANCY DRESS COSTUME - SANTA SPARKLE OUTFIT 22886 M I need to insert a formula into the 1st spread sheet which will tell me if based on the product code it is present in the 2nd spread sheet. I have tried VLOOKUP and I think because I am trying to search for a code within a text string it keeps failing! All cells are general cells but the position of the code within the titles varies.

Excel Code To Print Invoice Numbers On Stationary www.vbforums.com

I am looking to print invioce numbers on stationary. So, for example, the invoice number is located in cell I1 of the excel spread sheet and starts at 100600. I want to print 150 invoices with the invoice number going up by 1 in each increment. So, I have thus far written: [Code]... What i need to achieve as you can now see is that the macro picks up the invoice number and does this however many times (or however many invoices I want to print.

Setting Up An Excel Spread Sheet www.vbcity.com

i'm relatively new to Visual stuido and am currently tryin to transfer data to an excel spread sheet. i have heard by a few friends that i need to set the spread sheet up.  i have 8 columns and need to list the data underneath each.Please help me

Need VB Tweak For Excel Spreadsheet www.xtremevbtalk.com

I need to copy a range of data to a user defined spreadsheet and tab via a message box. I know I'm way off at this point, and I would appreciate any help. Thanks -Herrtodd Code:Sub copydatatosummary()'copys all pending leaks to user defined spreadsheet and tab Range("A1:F100").Select 'this is the total leaks range Selection.Copy MsgBox "What spread sheet and tab would you like to copy to" Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False Range("A1").Select End Sub

Pulling And Manipulating Data In Different Areas www.excelforum.com

i need to pull data from one spread sheet and place it in a new spread sheet. and i am not that familiar with macros i am learning but i need to get this done.

Time Format- Spread Sheet To Calculate Call Duration www.mrexcel.com

I am setting up a spread sheet to calculate call duration it would be a great help if data could be entered using one hand IE use decimal point on the number pad instead of the colon is this possible. I will need to subtact start time from end time to get the duration

Find, Highlight Across And Sumif Macro www.excelforum.com

I have a large spread sheet. I need to find 38 accounts in the spreadsheet, highlight them across the span of the spread sheet and then do a sum if to the side. I need to use this Macro monthly on a new ageing and some months some of the accounts may not be in the ageing.

Lookup With Multiple Criteria www.mrexcel.com

I have a spread sheet with multiple columns. I need a formula to look at criteria from three specific columns in the spread sheet and spit out a description from a key I created. Here is an example. This is the key I created: Record Kind Group Group Name Category [Code] ..... The spreadsheet has the same columns so I need a formule to look in the spreadsheet and if it sees each combination as in the key to spit out the category name from the key.

Find A Value From Table www.mrexcel.com

I have data spread across 76Rx68C - this table is raw data with no logic to placement of values within . In another sheet i have one row of values. I need to know if each of these values appear in the data spread. - a simple YES / NO would suffice - i dont need to know where exactly are they appearing in the data table.

'greater Than >' Formula & Result www.excelforum.com

Column B is basically 550 points + column C = Base Roll. We need to introduce a cap so no more than 1000 points can be displayed/earned. So column G adds all points & column F caps. So far it's all ok. Now when i add a value to column E (points spent) those points are deducted from column G instead of the capped 1000. Entering a value of 500 displays 800 in column F instead of 500.

Points System? www.codingforums.com

I am creating web site where users earn points and buy items with their points ect. I am pretty new to php, but I have learned alot of the basics. On my website I have a registration page where users can signup and their data is inserted in a MYSQL database, and the users can login and logout. Thats about it so far, I need help with creating a points system, where users can earn points and spend points.

VS 2005 - Creating New Application (Solution Explorer Window) www.vbforums.com

I seem to have some finger trouble creating a new application, here is what I am trying to do: I am trying to create a new solution and under the solution an exe (console project and a set up / deployment project. I have done this in the past and cannot see to do that any more. Steps: 1. Create a new solution, the solution show in the solution explorer (with 0 projects) 2. Using "add" I create a console application (under the solution) and it shows a module etc. So far fine. 3. At this point the solution explorer windows only shows the console project and the solution itself (that used to show on the top) is gone. Now I am not able to add another project to my solution. I close my screen and then try to open the solution again. It comes up with the console project.

LG :: Vx8500 On Telus Need On Pageplus / Verizon www.howardforums.com

I got a bunch of lg vx8500 black and white from telus and I'm having a real hard time putting it on pageplus, i need to know what the process is to make the phone recieve pictures and web, so far I program the phone for talk and text but no luck with pic messaging and web, I have lg download and all the cdma softwares but need some guidance I'm afraid I have downloaded too many solutions and files and now I'm really confused, if you need to be paid for your help I'm willing to discuss it since I really need a solution asap.

Help Needed Setting Up A F1 Scorecard www.access-programmers.co.uk

Hello People I�m new to Access and I�m trying to create a database of the upcoming Formula 1 season. I�m trying to create a database that I can show all the details I want at a click of a button, my first problem is this� How would the work? What tables do I need? This is the information I would like to show and store in the database but I�m not sure how to put it all together and sort out all the relationships, can someone please help. Drivers First Name Second Name Team they driver for Champion ships Total points so far Points needed to win Last race position Racing History (points won, number of pole positions, number of wins, number of DNF (Did Not Finish)) Teams Name Tires Engine First Driver Second Driver Total points so far Points needed to win Last race positions Tracks Name Location Winners Track History (Last year�s Lap Record(driver Name),average weather, )) Thanks NickJ ;)

Convert Column Number To A Letter www.xtremevbtalk.com

Hi all,Say you have the formula Code:.cells(rownum,colnum)rownum and colnum are variables.How would you get vb to convert the rownum into its letter equivalent. I just want the letter value for that range, not the row number aswell.e.g colnum=5, therefor its letter equiv is EAlso, I want to extend this so it goes further than IV, the furthest cell to the right on an excel spread sheet.So if I typed in 300, it will say what Column letter it would be, even though the maximum amount of columns is 256.Thanks for any help given

Xy Scatter Graph Average Point With (+) Around It www.excelforum.com

I am supposed to make an xy scatter graph like the one drawn of paper. The average point need to have a "cross" around it. So far I can just plot the points. I have added the average point as secondary series. I just need to put the "+ sign or cross around" it.

Repeating Adjacent Cells Based On Formula www.mrexcel.com

Based on a trigger point (being a month), and the number of times the expenditure is spread over (factor), can I formulaize the repetition of the figures? Sheet1 *CDEFGHIJKLMN5***Trigger Points**Desired result via formulae **6CostFactor*JunJulAugSept*JunJulAugSept7 £ * * * *10,000 2**1**** £ * * * *5,000 £ * * * *5,000 *8 £ * * * * *6,000 3*1**** £ * * * *2,000 £ * * * *2,000 £ * * * *2,000 *9 £ * * * * *8,000 1***1**** £ * * * *8,000 *

Limit Data Validation Values To A 1 Point Margin In 3 Different Cells www.excelforum.com

I have a section of my program that asks for board scores (point value is 6-10 in increments of .5) I have set up a data validation so that users can only enter those specific values. Problem is, none of the values can be more than 1 point from each other. (the part I have yet to figure out) Example, if the first value is a 6.5 the second is 7.0 and the third is a 9.0, I need the data validation to display an error because the 9.0 is beyond the one point spread. Summary: Display an error message if any of the points are more than 1.0 point from another.

Linking Excel Spread Sheet - Version: 97 (8.0) www.utteraccess.com

Have: excel spreadsheet with 30 fields and records/rows that does calculations to get markup on products. ( i only need 15 to be linked) access data base with a lot of fields table "data main" with 1200 records. Have created a linked table from the excel spread sheet in access. it contained all the excel fields "excel linked" Previously, I imported all the data from the excel spread sheet to a table. "excel Data" I then did an append queries choosing only the fields needed to append to "data main" After running the update, I realized I had messed up, I had chosen some of the wrong columns. I need to do 2 things, update the data from the "excel data" table to correct the data info. I need to make a more permanent query or link to link the data from the 15 fields in the spread sheet to the "data main" table. Any help/ tips on this? Thanks

Requirements For In-house A/V Hosting? How Much Traffic www.sitepoint.com

I'm trying to come up with a cheap , middle of the road, and high end set of solutions (list of equipment) for in-house hosting of video-casting / audio-casting on a site that can get big spikes of traffic at times. With some particular attention /consideration to the back-end, server requirements/needs. When or at what point does one need a a dedicated server for media? How much bandwidth is needed? how much traffic is a breaking point?

Find Resulting Point By Given Point, Angle And Distance www.xtremevbtalk.com

I need someone with a descent understanding of math to help me out with this little problem.Given an origin coordinate, angle and distance, calculate the resulting point's x,ySo far I have the following:Public Type Point X As Integer Y As IntegerEnd TypeFunction Get_Point(ByRef ptOrigin As Point, ByVal angle As Integer, ByVal distance As Integer) As Point 'Do math stuff here Get_Point.X = resultingX Get_Point.Y = resultingYEnd FunctionAny help is much appreciated

Complex Locked Cells Probem www.xtremevbtalk.com

Guys and Gals,I've got a spreadsheet that I am using for a project at work and I've come to the point where I need to implement a complex solution..... and Im looking for hints / solutions to help me.I want for my spreadsheet to be mosltly locked not allowing anyone to change the entries, however some columns need to be unlocked to allow entry, and every row below the last row need to be unlocked for data entry. Does anyone know a macro, or some kind of process for doing thisThanks again for your helpNick

Spread Values When Criteria Met www.ozgrid.com

I have worksheet where I would like to apply a number value proportionately throughout a column bases on user-defined conditions (i.e. >=, <=, Between) from other colunmns. See example below and attached worksheet with further detail. Col A Col B Col G Col L Col M 01380Employee 15.0 5.5 (0.8) 00304Employee 24.0 - (0.8) 01901Employee 33.8 (1.0) (0.8) 01729Employee 43.0 - (0.8) 01482Employee 53.0 (1.1) (0.8) 00299Employee 62.5 - - 00069Employee 72.5 0.5 - 01783Employee 81.5 - - 02076Employee 91.0 - - 01934Employee 100.5 - - TOTAL 4.0 -4.0 In the above example, I would like to have the TOTAL value of Column L (4.0) be inversely spread throughout column M based on criteria selected by a user in a section of the spreadsheet. Criteria: Column G >= 3 AND all values in Column L = 0; Spread -4.0 (Inverse of cell L12 = 4) in column M for records that match criteria. I would like to have a command button apply the logic of the conditional criteria set for Columns G & L and spread proportionately ithe value from n Column M. I added examples of the different criteria and the layout in the file attached.

Annual Amount By Month www.ozgrid.com

There are two tabs in my workbook right now. The first is where users will input information and annual budget number for consulting fees. The second tab spreads the annual budget by the 12 months. I don�t want the users to see or touch this tab containing the spread. Once the annual budget number is entered, I would like them to use a combobox to choice how they would like to spread the budget monthly. One choice is evenly which is the default and the other would be manually. If they choice manually I would like a userform or something where they than input each month�s amount that will total the annual budget. See attachment, this is all I got so far.

Bitmap To Bitmaps (Finding Objects) www.xtremevbtalk.com

I am new to graphics. I have asked a lot of experts(?) about this and NO one seems to have the answer.How do I find objects in a bitmap and copy them to a new bitmap automaticly?Example 1: A bitmap with 30 coins spread on a red background. I would end up with 30 new bitmaps ,each with 1 coin.Example 2: 20 Stamps spread on a red background. I would end up with 20 new bitmaps, each with one stamp. All these objects would be spread far enough apart that a rectangular area around them would not have another object in it. There are only 3 colors involved, 2 for object, and a different one for background.

ActionScript 3.0 :: Input About Large Data Handling? www.kirupa.com

I'm building a sidescrolling world where you can move around.The idea is that you should be able to move to any point in the world, as well as travelling really fast.I'm pregenerating a long list of data about objects to place, their positions etc. Now. When moving to a point far away from current position I don't want to loop through the whole list of objects to find what objects should be seen and not, so I'm thinking I should divide the position list into sections, each covering an area equal to the visible area. That way I would only have to roll through the lists closets to the new position.This would however result in an array of thousands of elements each consisting of about 20 objects and I'm figuring that might not be very healthy.One solution would be to split everything up further so that in the end I would have a handable nr of arrays containing a handable nr of elements. You're probably thinking I should generate positions on the fly, but since one place in the world can be revisited I need to store all positions.

Vb Steps To Fine Tune The Requirement www.xtremevbtalk.com

We are doing a software for a POINT OF SALE (POS) for a retail operation (huge supermarket) where we need to give a pop-up on item code and item description where ever required. We have a item master containing around 80,000 records.The coding is done in VB and we are using the VB 6.0 ADO 2.6 / Oracle 8.1.7.The usage of this pop up is as follows.A user would press a key (say home ) and then a pop up window comes up with two columns namely item code and item description. We will be giving 2 option like say F2 and F3. If a user will press F2 the pop up will get sorted code wise and then there will be a text box where he can start typing the code.. If he presses F3 the pop up will now appear sorted description wise. A search function is used (in list box) to bring in those codes which match the keys pressed in the text box. The search will actually fire for each key typed in the text box. In case data is not found, a validate is to be made to disable further typing.We are having a restriction in the List box to display only 32,000 records (which is the maximum capacity). So we are stuck with giving the above solution to the users. Now we are loading the same 80,000 into three list boxes, which is not actually the solution.We are now using a Windows API function to search in the list box. So now searching is fast, but loading is getting delayed.. becoz we are using three list boxes for item code and three more for item description..We have tried using some spread with oracle data controls also, where the loading is fast but search is very slow. We are forced to give the above said solution as it is becoz the users are already using this function exhaustively in a dos based Point of Sales software.Kindly suggest an alternate to over come the same. If required, I would put in some screen shots or the source even.Thanks in AdvanceGiri

Spread Sheet www.vbforums.com

Hey people, I make a program for my dad to keep info about his TAX cleints. I need to be able to get a spread sheep to have something like this:[NAME] [ID]Carp 111Carp1 112Carp3 113The files are stored as 111.ini, 112.ini ect...inside the INI file is has name=Does anyone knoe how I can add this to a spread sheet??

Import Multiple Text Files www.ozgrid.com

I have about 200 text files each with 2 columns. I want to create a single excel spread sheet where the data comprises of the second column from each text file. I do not know any thing about macros and so need help on writing a macro that will automatically import data from the whole of the second column of each text file into one single spread sheet.

Formula To Clear Out Cells With In A Spread Sheet If Certain Input Entered. www.excelforum.com

On the attached spread sheet here is what I am trying to do. In B2 I will either enter D (digital label) or F (Flexo label). With that than if a D is entered nothing else will happen with in spread sheet but if F is entered D23:Q40 will need to be cleared out and blank.

Importing Data From Multiple Tabs www.excelforum.com

I have an excel spread sheet with about 300 tabs. each sheet has the same column fields..I need to pull certain column fields ( the same fields ) out of each tab and export them to another spread sheet.

Listing Required www.excelforum.com

I have been given a worksheet which has 5000 rows spread along 13 columns. There are about 200 cells that I am interested in from this sheet, these cells being the subtotals of the cells above them. I have extracted the individual cells containing the subtotal values to a new, empty column but they are spread down this column with blank cells in between. Is there a function / formula to get rid of the 4800 blank cells so that the data I need is compressed into a stack of 200 cells all filled with data?

Formula To Distribute A Value Along A Bell Curve. www.excelforum.com

I'm trying to find a formula that would spread out a value amongst multiple cells along a bell curve. Say I have $x,xxx. I want to spread that amount out in a certain proportion, regardless of how many cells I'm spreading it throughout. Say I have a $10,000 project. I want to be able to spread it out like a bell curve in the cells I choose. For instance, if it was a five month project it would be distributed as January - $1,000 February - $2,500 March - $3,000 April - $2,500 May - $1,000 If I added another month it would change to January - $833.33 February - $1,666.66 March - $2,500.00 April - $2,500.00 May - $1,666.66 June - $833.33 I already thought of manually adding percentages to each cell, but the formula needs to be dynamic.

Converting Table To List www.excelforum.com

I am wanting to manage my inventory and need to convert spread sheets with tables specifying style, size color to lists with skus specifying style, size color. please see attached spread sheet with one sheet with table and second sheet with list.

To Get A Column Data Which Spanned Multiple Tables www.sqlteam.com

All, i am looking for a query which fetches data from column 'managerid' which spread across 20 tables, Managerid colums is spread across 20 tables and i need only managerid data from all the tables available, data for managerid column will be different in each table. can anyone help me regarding the same.

Pulling Data From One Spreadsheet Into Another? www.excelforum.com

What I am trying to do is pull data from one spread sheet into another. The Data spread sheet has 2 columns. Date and Price. What I need to do is enter a date in to row b2 (example 2/13/2013) Then Cells c2-v2 fill in with the data from the 20 days prior to 2/13/2013. Also note that I use only dates from weekdays.

Sort Spreadsheet To Collect Like Items www.excelforum.com

I have attached my particular spread sheet I an referring to. I set up a spread sheet to write out all the material I buy to go into a product I make. I work my way through a layout diagram and type all my data in to a spread sheet, one row per item I need to buy. Now I want to order everything. Is there a way to sort the spread sheet so it brings all my like items from Column A (item) together, so I Can count the quantity required to order? I have tried to sort, but am worried I might be messing up the rows and column - all the row information must stay together for it to work. 567 BOM REV 0 - 16 12 2013.xlsx‎

How To Shift A SUM Row Down When The Above Cell Is Filled www.excelforum.com

I've attached a simple spread which gets across the main problem. i need the totals row (currently row 7) to drop down a cell each time the data base above has an extra row added to it its pretty much a cosmetic issue but it can be useful on hugely long spreads.

New Tab Within Excel Automatically? www.excelforum.com

Is it possible that excel can copy a template tab and create a new tab automatically when requested? I am trying to create a spread sheet to log all spends within the department but need to be able to generate a front sheet for each purchase order request. I have attached the spread sheet and have highlighted what I am trying to create. I have never used visual basics so am completely in the dark, can excel do this sort of thing?

ActionScript 3.0 :: Random Value From A Circle? www.actionscript.org

I need to get a random xy value from a circle, for example going to spread circles on stage randomly. Its quiet easy to spread the circle in a square. Here that was done. var MC:MovieClip=new MovieClip(); var squareWidth:Number=200; var squareHeight:Number=200; [code].....

Shuffle An Array Of Cards www.vbforums.com

i have an array of uno cards in my project, and need to shuffle the array. each array cell from 1 to 96 is set as form load...yes, i searched the forum for solutions. but couldn't implement anything i found to work for me except for one that shuffled exactly the same every game...so can i please get a simple solution to this? i don't want anything complicated... need help asap because i'm kinda stuck at this point now before i can do anything else on this assessment task

3 Point Arcs!! Clockwise Or Counter-Clockwise www.xtremevbtalk.com

Hi, I need to determine weather a 3 point arc is to be drawn clockwise or counter-clockwise. I know the coordinates of the 3 points, and I have all ready found the center and the radius.I have tried doing it by comparing the angles between the points but I cant get a solution that works consistently.Any advise will be appreciated,Brian

Actionscript 3 :: Play A Specific Part Of A MP3 File Without Loading All Of It? stackoverflow.com

I have a project at office which is mp3 player when a user start a song from any point, the whole mp3 file gets loaded then start to play from the point user selected so now I need a solution to be able to play the mp3 from a specific time without loading the whole mp3 to be able to do that (You know like youtube when you click in the middle of a video and it starts to play from this point)