Search results for query: *

Hi team, I have vba sub that gets called from a change in a value of a cell: ie: Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False If Target.Address = "$C$5" Then nonupdating BU ... end if Where nonupdating is : Option Explicit Public Sub nonupdating()...

Hi Guys, I have an API that fetches data from a URL and posts it into an array format. I would like to have that array write to a table. Questions: Do I need to create the table definition first? How do I place the data from an array format into a table structure? Any guidance would be...

Hi Guys, I have an API that fetches data from a URL and posts it into an array format. I would like to have that array write to a table. Questions: Do I need to create the table definition first? How do I place the data from an array format into a table structure? Any guidance would be...

I have a loop that calls the following proceedure Public Sub sortert(rx As Integer, cx As Integer) ' ' Macro2 Macro ' Dim r As Range Dim sortrange As Range extr = rx + 17 extc = cx + 7 sc = cx + 5 With sortrange = Range(Cells(rx, sc), Cells(extr, sc)) End With With r = Range(Cells(rx, cx)...

Hi , I have this form where if someone enters a one time payment, i want it to go into the [down payment] column and also the [total payment] column for that user. Any advice? Thanks

Hello, I need to change the font size within a combo box in excel. Not sure this is the right forum but any help would be greatly appreciated. this is not the active x combo box, this is the standard combobox in excel 2007. Thanks

Hello All, I have a report that is the following Customer Item amount Chris - Apples - $100 Chris - Oranges - $100 Bobby - Apples - $1000 Jim - Apples - $1000 Total # of people 4 - Total $ 2200 I would like to count distinctly the # of customers. regardless of the # of times they appear...

Hi Everybody, I have a code that converts a CSV to a XLS within outlook. This is needed because it runs in conjunction with a rule i set up. Everything works fine, however when i try to open the file, it refuses to open and I have to CNTL+ALT+DEL my way out of Excel just to open the file...

I saw this in a database i recently took over and never saw it before.... Its a TABLE of Names with Ids, which links to another table of IDs to Sales Accounts.... Thing is, within the table view of Names has a + sign in the beginning of the row, once i click on that, it shows me the linked...

Hello, I have this small vba code that takes the value of a named range and tell it to change that field to that given value in a pivot Sub CarrierControl() Sheets("pvts").PivotTables("Master").PivotFields("network operator").ClearAllFilters...

Trying to make some groupings on a date field in a query like this : case when (CAST(FLOOR(CAST(date AS FLOAT)) AS DATETIME)) >= getdate()-8 then '7 days' when (CAST(FLOOR(CAST(date AS FLOAT)) AS DATETIME)) >= getdate()-15 then '14 days' when (CAST(FLOOR(CAST(date AS FLOAT)) AS DATETIME))...

All, I have a query that gets run in Excel, and everything works fine and dandy, however, sometimes the query takes a bit long in MS SQL. Is there a way for excel to alert me when the queries I placed are done processing ?

I saw this months ago, but I cannot find the page again. I am looking on how to have VBA from excel copy a chart then paste it into the body of an email. has anyone done this and is this doable? Thanks!

Hello, I have a form that is linked to a table, however when ever it starts up, it displays a record in that data (like the 3rd or 4th record, i dont know why) I would like the form to be completely blank but still be able to link to that table. is this possible? #2, I'm having people put in...

Hello all, I had admin rights to Microsoft SQL studio 2003. I am trying to delete a table or namely a database. However I corrupted a table and it will not allow me to view or delete anything withing the database. I was uploading about 200k records from an access database, when I accidentally...

Hi I have most of this automated so I just need the sniplets of code. 1) code that runs a particular query and exports it in excel 2) code that then attaches that excel spreadsheet into a outlook email. Has anyone done this before?

Is this possible?

Greetings, I have a macro set up to run a series of emails, and I would like to pass into that macro a specific range from excel and place it into the body of the outlook email. I looked online and it says i have to pass it as an HTML using a worddocument editor. I am quite confused. Some...

Hi Heres the question, I have 2 columns of data in a pivot table and i want the % of the subtotal Fruits: Apples - 5 Oranges - 10 Peaches - 5 Total: 20 Vegetables: Broccoli - 10 Corn - 10 Total: 20 I want the % of the sub total...

Hello all, This is my first post so be gentle. I am creating a form in access, and I have a drop down combo box with a list of choices I made from a Value list. Next to it I have a button. I want the button to read the selected value from the combo box and run the appropriate code. The only...