Answer Questions

• kered pople vlookup

  I am using vlookup and I want to obtain the value in column B for the second occurance of the lookup value This code comes up with error DestCity = WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) _ And WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) If I use the first part before the "And" it will find the results to the first occurance. Please help! Hi As an alternative if you like WorksheetFunctions you could try With Range("CPARSdata") DestCity = WorksheetFunction.VLookup("Line#1 CITY", .Range(.Cells( _ WorksheetFunction.Match( _ "Line#1 CITY", .Range(.Ce ...Show All

• Ather. Protecting formulas in cells

  Hello, Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten Thanks Chrstdvd Andy, All my sheets with formulas are protected. I do not password protect them because I would always have to drive xteen zillion miles to fix mistakes. Like "I forgot to post a price change before I posted end of day fuel running totals". Even though I can put a message box up that asks "Are You Sure There Were No Fuel Price Changes Yesterday." Hardly anyone looks at the screen, they just punch in numbers. Even ME, when I am in a hurry, and I close a file by hitting the ...Show All

• S10n i want a code for file transfer by ws2_32.dll library

  i am using vb6 and i am searching for a code for client and server for file transfer using ws2_32.dll library Hi, don't have the code but do a search for WinSock Examples or Windows Sockets Code etc and your bound to find examples. ...Show All

• BarryDay Sum of hours using select statement & VBA

  Hi - ok here is my question: I have an activity recording form that records hours logged against a company. I have added a field called 'sumactivityhours' to the table and the form.  what i would like to do is when a user selects a company from the drop down list (thanks derek and duck thing for your fantastic help with that problem) it automatically populates the 'sumactivityhours' field with the total number of hours worked thus far with that company  so that the user can see the total hours and then writes that information into the 'sumactivityhours' field in the table. as i gradually begin to learn a little more about VBA im guessing that i should create an on exit event on the companyname combo box that re ...Show All

• A kid Using Access XP VBA to post a file to SharePoint

  Good afternoon, I've looked high and low for a solution to programatically, through use of VBA in Access XP, post a file to a SharePoint site. I am a "Contributor" and can manually post a file without issue. I tried a straight copy to the the sharepoint directory via VBA, but always get a strange message that says the file already exists. Any assistance would be greatly appreciated. Below is the code I tried without success. FileCopy "C:\Data\Report.xls", " \\sharepoint\sites\ Report.xls " Thank you in advance, Manny Don't use file copy.....Get a clue. You can use Sharepoint Web Services for VBA...it's a library for VBA that le ...Show All

• nhaas Adding records and incrementing the date

  Hi Newbie here..I have two tables in access, the parent table has a start date and an end date and uniqueID, the child table has one date field and the same uniqueID as the parent is also has other fields that would start out blank. I would like to run some code the create one new record in the child table for each day in the parent records date range. I.E. PARENT RECORD UniqueID001 Parent StartDate = 1/12/2006 (1st of December) Parent EndDate = 5/12/2006Total Days = 5 CHILD RECORDS (5 of them) UniqueID001 - Date = 1/12/2006 UniqueID001 - Date = 2/12/2006 and so on until UniqueID001 - Date = 5/12/2006 Its probably quite simple for a gurue! In vba, you run action queries to do t ...Show All

• Thibaud Help with a formula

  I need to write a formula for Excel that calculates the amount of fuel that is in a tank. Here is what it is for. We have cylinder tanks that lay horizontaly. Each month we put a dipstick into the tank to measure how many inches of fuel is left in the tank. I need a formula that will take that and calculate it into gallons. Here is the formula I have to work with. / -1 r - h \ V = L * | [ r^2 * cos (--------)] - [sqrt(2rh - h^2) * (r - h)] | \ r / Any Help is appreciated (BTW I am not the best at math so if possible an explination of this formula would be greatly appreciated) You need to u ...Show All

• Artmark Creating data with a loop based on current info in worksheet

  I have an excel file (.xls) that already has data in it. I have already got my VB app to open the source XML file and change it to a XLS file and delete the top row (blank and not needed) and add a new column in for my new data. The new column needs to have data that will loop down until the other rows have no info. The naming will be generated based on a number. vp0001.jpg vp0002.jpg vp0003.jpg vp0004.jpg and so on until it comes to the last row. This data will be put into column A and it will check column B for the last row. Thanks! No one has any ideas Hello Dustinto, There are many experienced and learned people using this form and (I'm not one of them). But you have not really explained your problem in any detail tha ...Show All

• Daniel Segerdahl [OTP] VBA Using combobox in Excel

  H i there,   I'm working on an engineering spreadsheet (Excel) and need some help in manipulating comboboxes / dropdown list.   Say i have 2 list, where list A has the list of countries and list B has the list of cities for the country chose. If all the data source (i.e. countries and cities) are to be extracted from the Excel spreadsheet, is it possible to make list B dependant on list A (that is to say when user selects a country in list A, list B will automatically gives the respective cities) WITHOUT creating a userform If so, please advise how.   Hope you can understand what i'm trying to ask here. Fyi i have minimum VB knowledge so a "dummyproof" explaination would be really ...Show All

• Krutika Help with a formula

  I need to write a formula for Excel that calculates the amount of fuel that is in a tank. Here is what it is for. We have cylinder tanks that lay horizontaly. Each month we put a dipstick into the tank to measure how many inches of fuel is left in the tank. I need a formula that will take that and calculate it into gallons. Here is the formula I have to work with. / -1 r - h \ V = L * | [ r^2 * cos (--------)] - [sqrt(2rh - h^2) * (r - h)] | \ r / Any Help is appreciated (BTW I am not the best at math so if possible an explination of this formula would be greatly appreciated) Tiger, forgot ...Show All

• A.Russell Problem with CWnd::RunModalLoop(DWORD dwFlags) in wincore.cpp

  Hello, We have created a VC++ application that has 2 menu options. - submenu 1 opens the VBA IDE - submenu 2 opens a Modal Dialog to execute a functionality (say FUNC1) Whenever we directly select submenu 2 the application executes properly. But the application hangs whenever we select submenu 1 (opening the VBA IDE) and then select submenu 2 (having the VBA IDE still open) On debugging we find that in the problematic case (in which the application hangs), the control fails to come out of an infinite loop inside the mfc source code wincore.cpp The details of the code flow are given below for this problematic case: The modal dialog is created using the function INT_PTR CDialog::DoModal() (present in mf ...Show All

• Joseph Stalin Userform Controls

  I have created a data request form for the company in Excel. The form has quite a lot going on (e.g. frames, option buttons, tick boxes etc). I've created all the necessary code and event handlers so that the form behaves as it should. In an attempt to record the user's input, I've then gone on and written a bit of code, which executes when the user clicks OK after completing the form. This bit of code loops through each control on the form and, depending on the control type, writes its caption or value to a blank spreadsheet. The issue I'm having is the order in which it loops through the controls. The tab order for the whole form, including that within frames, is spot on, yet this bit of code loops through some of the controls in ...Show All

• Sharath paleri Configuration Failed: Windows SharePoint Services 3.0 (Beta)

  Downloaded SharePoint Services 1.I selected Basic Button “install single server stand alone using default settings 2.Closed SharePoint Service Install and checked to start the configuration wizard. 3.Next I said yes to the popup message: The following services may have to be started or reset during configuration: Internet Information Services SharePoint Administration Services SharePoint Timer Service Choose yes to restart the services if required and continue with the configuration wizard or no to exit the configuration. 4.It starts to configuring SharePoint Products and Technologies. 5.Then I get: Configuration Failed One or more configuration setting failed. Completed configuration settings will not be rolled back. Resolve the problem a ...Show All

• K.Kong Visual Basic for Excel

  I have several hidden workbooks loaded at startup that contain excel macros used to modify certain special workbooks. I also have a number of modules that are universal and contain procedures and functions I'd like to use in any project that I load. The file containing common modules is S.XLS and special workbooks C.XLS and D.XLS VB for Excel recognizes each sheet as a project. As I read the on-line help, to refer to procedure TestSub in module MySubs in Project S.XLS from procedures in project C.XLS the code would be: sub UseTestSub [S.XLS].[MySubs].TestSub end sub This produces an error that the file doesn't exist. Is there a correct way to access SUBs and Functions from another project Should I be doing something diff ...Show All

• Nick Colebourn run-time error '1004' Method 'Range' of object '_Global' failed wen using refedit

  I have looked around the web and cannot find a solution .. hope somebody can help.. I consistantly get run-time error '1004' Method 'Range' of object '_Global' failed when I hit the Range command. The refedit contanis text somthing like (select a range of cells with my mouse) 'Sheet1'!R5C2:R15C2 But I cannot turn that into useable information. My code is launched from a command button through a Form Public Sub CommandButton1_Click() Dim freqRange As Range Dim respRange As Range Dim psdRange As Range freqRange = Range(UserForm1.RefEdit1.Value) 'error occurs here! respRange = Range(UserForm1.RefEdit2.Value) psdRange = Range(UserForm1.RefEdit3.Value) TextBox1.Value = (Module1.sumpsd(freqRange, respRange, psdRa ...Show All