parameters

In my workbook I have a set of status boxes with code that allows users to check them based on the current status of that tab. The code is the same, so recently I pulled it into its own module. This code is called on every page of the workbook. Recently, I've been getting "Out of Stack Space"...

Hello All new to this and wondering if someone could assist me? I have the below formula in a spreadsheet with a view to calculating a month value from a year and week # the formula below is linked to a parameters tab and I am nowhere near savvy enough to figure this error out. my main...

Hi, I need to calculate latitude and longitude for given speed and heading. First value of latitude and longitude is provide rest of the values need to be calculated for given other parameters such as speed and heading d1=speeds(1)*stept1; d2=speeds(2)*stept2...

I am trying to set a query in Excel from Data\From Other Sources\From Microsoft Query - I am able to get the base data to load fine. The issue becomes when I am setting a parameter based on a Cell value. In this case C5. The cell has valid data in it. If I hard code 'SIR%' I get results...

Hi everyone, I have a set of numbers that must be analized with the comparison operators. It would be really efficient if I could pass these operators as paramaters. I tried to solve this with the Evaluate function and it works when I compare whole numbers but when I switch to decimal numbers...

Hi everyone, Can VBA be used to "control" Power Query, or can there be dynamic query parameters? I'm relatively new to Power Query (in fact, still using Excel 2010 version). For example, if I have a standard SQL query that would need to be updated for different users, can I parameterize it...

I would like to show the xlDialogOptionsListsAdd dialog and retrieve the name or index of the custom list that was selected. I can show the dialog easily using: Application.Dialogs(xlDialogOptionsListsAdd).Show but I'm guessing that if I want to know what value the user selected, then I have...

Hello, I've the following problem. I use the following code. Function SumAll(ParamArray var() As Variant) As Integer For i = 0 To UBound(var) MsgBox var(i) Next End Function When I execute this function =SumAll(4,3,2) it displays the following messages:4,3,2. This is fine, but...

I'm using Excel 2010. I'm getting an error every time I try and pass a parameter straight through to my SQL query so I don't have to use VBA (very long SQL Code). I'm using an ODBC connection that I connected with the "From Microsoft Query" tool that's available. What I'm trying to do is use...

Hi Experts, Been trying to look all over the net for this solution for months already but to no avail. :( Wish I can have some answers from the experts here. Here's my story. I have a long list of insurance policy numbers which I extracted via MSQuery into Excel sheet. Then, I need to get each...

PROBLEM: I'm using an Access form with a team of ten (10) users to automate data input. The form contains a number of tables (about 7) and an equal number of queries. Each user has been assigned a User ID so that the work they receive is uniquely their own. Each time the form is updated, the...

I am currently working on a project using data for a trucking company that ships nationally. We are trying to figure how much a new toll bridge being implemented would have cost us last year. In each shipment load there are multiple movements that results in multiple toll bridge crossings, even...

Is there a way to set parameters so that your formulas do not go past? I want to set multiple parameters based on the location of a date. The date is the heading. There are multiple dates and I want to use the offset and index/match formulas for each date section.

Via VBA, I am trying to run an executable that has parameters and a file name. Dim strProgramName As String Dim strArgument0 As String Dim strArgument1 As String '//This is the executable strProgramName = "C:\Dir0\Dir1\Dir2\Dir3\MyExecutable.exe" '//These are the required parameters...

Hello fellow members of this forum, this is my first time posting a question, but I've been a constant reader of your posts. I'm currently working on a Min function with a conditional, if you want to check the code it works like a charm... but my problem comes when I try to make it look more...

I am using MS Query in Excel and the query runs fine. It has parameters and is detail records. When I change the number column to be a summary instead of details, I get errors saying the: Invalid column name 'period'. Statement(s) could not be prepared. 'Period' is the name of the parameter...

I have a data connection in my workbook that returns customer data. The connection executes a stored procedure on SQL Server that accepts four parameters. The fourth is a true/false value that I have populated using a checkbox tied to a cell listing the checkbox value. That cell is listed as...

Hello, I am using MS Query to extract data from a QuickBooks company database. The query is complex enough that it "can't be presented graphically." Therefore, I cannot add parameters to it, at least not initially. After I get the data into Excel, I can then edit the Command Text within the...

Hi everyone, I've been coming here a while now, and I can see my question has been partly answered. I'm looking to have an excell file shared on a windows network to a simple LAN (samba sharing), and then for a user to be able to click on a HTML link that will launch that excell pile, and to...

Something like... dim retArray (0 to 1) as Long reDim retArray ( 0 to 1) retArray = doSomething(wSheet, searchVal, rngStart, rngEnd) ( Function doSomething(w, srch, begin, end) () retArray(0) = 100,000 retArray(1) = 5 doSomething = retArray End function The psuedo-code...