I have a query in SQL, an excerpt of which might look something like
DECLARE @myDate DATETIME
SET @myDate = '2020-10-31'
SELECT * FROM myTable WHERE myDate <= @myDate + 1
I want to populate a cell in Excel (e.g. A1) named range "myCell" that will feed through to the SQL variable instead...
I have a spreadsheet with multiple queries linked to it. When the user wishes to refresh the queries, they press a "refresh all" button I have provided to them which just saves them the time of having to utilize the built-in menu options simply because they never remember where to find it. The...
I'm trying to do some predictive forecasting with parameters but I'm coming across an issue when using parameters into the future. What i'm trying to do is forecast the amount of people on a waiting list in the future but this can be altered by using parameters which will remove...
So, yeah, the question is in the title. Can I for instance write something like
Private Sub UserForm_Initialize(rowCount As Integer)
and call it in my macro with
and expect it to work ?
Thanks you for reading,
I've tried to use a parameter from Excel cell to modify an ODBC Query from AS400 Database like this:
BUPKTO = Kunde,
Quelle = Odbc.Query("dsn=AS400", "SELECT BBU00.BUFNR, BBU00.BUBHKZ, BBU00.BUPKTO, #(lf)FROM WWC400.WEXFILE.BBU00 BBU00#(lf)WHERE (BBU00.BUFNR='01') AND...
I was wondering how can I use a parameter in a query using the "Get & Transform" .
For simplification purposes, I have a saved query called 'dbQuery':
select * from Balances where Balances.CoprID=[Idpara]
IdPara is the parameter.
"Get & transform" doesn't recognize this query because...
The last parameter in VLOOKUP() essentially tells EXCEL whether the range being used for lookup is in ASCII order or not. If not, it has to plow through all the entries in the range, as opposed to doing a binary "search all" (of COBOL fame).
So not understanding this for a long time, most...
I have a workbook with a number of sheets and a second workbook containing data that is to be entered into the first workbook base on a selection parameter. This parameter I have called BC and is contained in block with differing numbers of parameters in Range ("A2") to Range ("A" & 2...
I have two named ranges I use as sources for their respective combobox lists.
Since the ranges are dynamic, I use a formula as reference ...
WHat is happening though, from within my VBA application, the worksheet will many times get altered...
Hi all, I'm trying to learn how i might be able to use parameters to build my source file paths for a variety of queries using Power Query...
I think i'm most of the way there, but getting tripped up on the last one, which is a query type parameter that i want to generate a list of values...
Think that it is possible for a function to know the name of the form that called it.?
think that function can be in at unknown project of a unknown programmer.
with an object like parameter i can found the parent, but in this function i haven't any object like parameter.
I hope you...
This is the current Power Query code: With the data coming from another Power Query table (tblDateCurrent) with only one entry.
Source = Teradata.Database("cdwp", [HierarchicalNavigation=true, Query="SELECT #(lf) DIV_DESC,#(lf) DEPT_DESC,#(lf) SUB_DEPT_DESC,#(lf)...
Hello guys. I have an issue. I have to sort the data, but optimised in order to be less than 100.000 but the sum nearest possible.
Virtually I need a way in order to have some data, I want that data selected by the excel (preference for the parameter of the data, but the main preference has to...
I want to VBA Solver search parameter array like as 5, 8, 11, 14, 17...60 step 3, I use SolverAdd code as follow but not work?Why
[W4] as parameter start 5
Range("step") = 3
SolverAdd CellRef:=[W4], Relation:=2, FormulaText:=2+Range("step")*Int([W4]/Range("step"))
Thanks in advance. I am an intermediate user of Access and have the following issue:
How do I omit the parameter windows show for SUMofPLANNEDSCREENS SUMofActualScreens SUMofACTUALMnhrs as part of Query A, that pull the data from Query B?
I have a query that pulls data from a Query B. Query...
In my dBase, I have three queries that have a parameter that is coded Like"*TUC*"
The dBase is designed to be used by various locations with different location coded. Is there a way to change the query parameter in these three queries via a script?
I need to open a protected book reading a BAT file, in a silent way, without messages or alerts.
Perhaps including the pwd as a parameter in the command line but I couldn't find how to do it.
Thanks in advance.
I am trying to use the INDEX function to select a reference range created by another INDEX function selected by the "Area_Num" parameter where that other INDEX function refers to an ISBLANK-wrapped reference range. For reference, I have the following Excel formula in Excel 2016 on Windows 10...
I have a large database and I am attempting to build a separate archive database. For now, while testing and building, I am just trying to start by writing an append query to a new table in my database. This table, tblArchiveItems, was created using the structure only of tblItems. I...
Fairly new to Power Query or the get data function. I am trying to set up a query from an Odbc data source with a dynamic parameter for the Schema. The server will always remain the same however the Schema (not entirely sure what that is?) is what will change then the table name will remain the...