bla

I have a very long SQL statement which I'm trying to put into my VBA code. In my VBA I have the following format for SQL: With ActiveWorkbook.Connections ("Database").OLEDBConnection .CommandTest = Array ("Select * bla bla bla") I looked through some web information and it was suggested...

I have a spreadsheet I am look for a macros to some thing in this. I am very new to macros and this was originally written by some one else. The macro is below The Macros is to sort the dispatch worksheet by date Newest to Oldest range A13:L38 after being updated ' it is then to put in a...

Hi. I hope someone can help me. 1. I need to get the specific amount next to the word Principal For example: A1: bla bla bla xxx xxxx blabla bla bla bla blaPrincipal:1,000 xxx bla bla xxxx xxxx xxxxx bla bla bla 11/14/2017538.95Interest and bla bla bla Basically, all of the data are pasted...

Hi all Trying to do a bit of code where it would go thru the column and if it finds more than 7 spaces in a cell, it would copy that row and insert it under it I've tried something like this but doesn't work llr is last row Range("e3", "e" & lllr).SelectFor Each c In Selection c.Activate if...

Hi Everyone, This is an interesting problem and I think it is a bug. I have a structured table (listobject) that has a hidden column(s). When the table is filtered I cannot delete multiple rows. If I unhide the hidden column I can. <tbody> To demonstrate the issue setup a structured table...

Hi Everyone, This is an interesting problem and I think it is a bug. I have a structured table (listobject) that has a hidden column(s). When the table is filtered I cannot delete multiple rows. If I unhide the hidden column I can. <tbody> To demonstrate the issue setup a structured table...

Guys, I am trying to create a document, where if I double click on cell A2 for example, it will create an Outlook email with B2 as the Subject line and C2 as the body of the email (which would be more than 255 characters most of the time). Same with A3-B3-B4 etc The email to which I will be...

Hey Everyone! Can't seem to figure this one out for the life of me. I click submit, an e-mail is generated, the macro takes value's from text boxes in user form to create the "To", "Subject" & "Body" fields, but I also need it to attach the file listed in the PO text box (txtsspo.value). I've...

Hi, I understand it's not possible to format text in a vba textbox, I need to copy the textbox content to a cell eg. in the textbox I have: 1. bla bla bla 2. bla bla bla 3. bla bla bla What I want to see in the cell is: 1. bla bla bla 2. bla bla bla 3. bla bla bla Is it possible to do this...

HI Guys! simple one but I cannot get there :/ If column B contains text like "10,00%" (Ex. "Discount 10,00% was granted") insert number 21 in column Q of the same row. Output should look like this <tbody> A B O P Q 1 BLA BLA 10,00% BLA 21 2 BLA BLA BLA 3 10,00% 21 4 BLA...

Hello, We are having two databases we would like to compare, does anybody know a good formula or solution to give the Desired result? So basiccally what I would say it should compare the numbers and than give the complete cell of the Table to compare the data with. <tbody> Description Desired...

I have two worksheets and the internal cell reference is identical for each worksheet. When I run the macro and I am on Sheet A to start with, everything works fine. When I am on Sheet B, the macro crashes on the AFilterCell line and gives me a Runtim91 error. What is causing this to fail. If I...