Search results for query: *

REPOST - -- Could use any help available.... I am using an excel workbook that has a customized data refresh process. To refresh the workbooks contents (several sheets) you would press a "custom Refresh" button that is on the top ribbon. If I manually press the button the procedure runs. When...

I have updated the code to call the macro in this way Application.Run ("Filename.xlsm!sheetname.GVaction") Application.Run ("Filename.xlsm!sheetname.GVaction") Application.Run ("Filename.xlsm!sheetname.GVRefreshWorkbook") Application.Run ("Filename.xlsm!sheetname.GVaction") Application.Run...

I am using an excel workbook that has a customized data refresh process. To refresh the workbooks contents (several sheets) you would press a "custom Refresh" button that is on the top ribbon. If I manually press the button the procedure runs. When I record a macro to see what the button is...

Hi I have some code that filters and cuts my master file into individual files. The code accomplishes this fine; however, in the NEW files generated - it references the master data file and does not have the filtered data (which is present in the target file). Can someone lend some assistance...

Hi I have some code that filters and cuts my master file into individual files. The code accomplishes this fine; however, in the NEW files generated - it references the master data file and does not have the filtered data (which is present in the target file). Can someone lend some...

I am trying to run a procedure to print my reports but I am getting a Runtime error 3141 - The Select Statement includes a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect. Here is my code: Public Sub RunReports() Dim strRptFilter As String Dim...

When I run my code it runs through the report records but nothing is printing and it is not creating any folders to put the reports into. First it should create a folder for CompMgr and add uniquely named PDF files for each employee. VBA Experts can you please help me with this? Have been...

I could use some help trying to determine why this code is not adding the records to the table: When i run this I get null values... it should fill bx1, bx2, ect. based on the Nmbr field in the table. Sub AddBalls() Dim Bx1 As String Dim Bx2 As String Dim Bx3 As String Dim Bx4 As String Dim...

In Sharepoint Designer I see this code around a field that I need to change the FONT color or even the Field background color. How do I modify this code to show a different font color for that field? <[highlight #FCE94F]FieldRef Name[/highlight]="Plan_x0020_ID"/&gt Any help would...

Thank you PHV. I changed that and also realised I could use the String variable type. The code complies fine but does not give the correct result. For instance when I check it in the immediate window I get: [highlight #FCE94F]?GETHITS(123,012,321,213,231)[/highlight] [highlight...

I could use some help trying to figure out why I am getting a type mismatch error. My code: Public Function GetHit(Digi As Variant, Draw As Variant) Dim B1 As Variant Dim B2 As Variant Dim B3 As Variant Dim Var1 As Variant Dim Var2 As Variant Dim Var3 As Variant Dim Var4 As Variant Dim Var5 As...

So Skip, I am not so sure about the SQL structure to include this in my overall query. Can i call it like this: FROM[ref_Stock Index] SELECT[Close], WHERE [in query].[VestDate] = [in lookup table].[Stock Date]

Hi I have recently converted my access database tables over to SQL Server 2008 and in the process of converting my queries to views on the server as well. I am having difficulties converting this access vlookup function and could use some help with the SQL Syntax: DLookUp('Close','[ref_Stock...

I could use some help here with this small function. Checked all of my variable names so I am not sure where the zero in the results are coming from. Public Function GetTaxTable(TotalComp As Double, TargetComp As Double) As Double Dim LTIPercent As Integer Select Case [TotalComp] Case...

Ok, wow I feel stupid. Thanks you both. Had a long partying weekend. Appreciated.

I am running this function in a query and I am getting zeros as the result which is not correct in all instances. Can you take a look and give me your opinion on the code: Public Function GetEESSI(YTDSS As Double, EstTax As Double) As Double Dim SSIMaxPay As Double Dim SSIEeBasis As Double...

Thanks again for your insight MajP. This adjusted code is working perfectly now. It reads between the two points and returns the exact result as Excel! Awesome. I really appreciate your help. Function NewTrend(Payout1 As Double, Payout2 As Double, Achieve1 As Double, Achieve2 As Double...

Thanks again MajP. I adjusted the arrays but I am still getting th e Type 13 Error. Here is how I adjusted the code. Is this what you meant? Function NewTrend(Payout1 As Double, Payout2 As Double, Achieve1 As Double, Achieve2 As Double, performance As Double) As Double On Error GoTo...

Thanks MajP, I actually did read on that as i was trying to trouble shoot this. I figured since I was not passing anything as the const that it was defaulting to true. So now I added that variable to my code but now I cant get any values returned; however, I do get a "13 Type Mismatch" error...

Hi, I could use some help in determining why my TREND formula in Vba brings a differnt result than the EXCEL trend formula. I use the same parameters: (y,x, new x) I use a High and Low threshold value to compare to the Payouts at those threshold levels: Arg1(1) Arg2(1) Arg1(2)...