Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite. If your question is specifically about programming Excel, Access, Word or Outlook, use the appropriate tag: excel-vba, access-vba, word-vba or ...
0
votes
0answers
10 views
How to create an Access DB with vba / c# (DBMS)
I have seen some tutorials but everything that I am trying is not working.
I want a simple project with just one textbox (where the name of the database goes) and a button that creates theAccess DB ...
3
votes
2answers
16 views
Copying a discontinuous range from one sheet to another
VBA rookie here (and first-time poster) with what is probably a pretty basic question. However, I haven't found an answer anywhere on the internet (or in the reference books I have) so I'm pretty ...
2
votes
0answers
14 views
Outlook Get Other Emails in Email Thread
I am using VBA to format all outbound email messages in a certain way before sending. For example, I want to remove the first column from all tables which are embedded in the email. I use the ...
1
vote
1answer
17 views
Conditional formatting on entire sheet via Macro
Need your help. In my Spreadsheet there is a macro that when activated test to see if a cell color in the entire set of data is pink. If one is found then the fist cell is marked pink, alerting me to ...
0
votes
3answers
17 views
Endless Loop - VBA Script That Runs when MailItem is Added to Sent Folder, then Creates Copy
I recently completed an outlook vba script that will scan the subject line of each mailitem added to the sent folder, looking for a project number in the subject. When detected, the script extracts ...
1
vote
1answer
15 views
Data validity checks
I have a document that I want to check a number of columns to see if they are formatted correctly. For the values that are incorrect I want to have a msgbox that displays the values and locations ...
0
votes
1answer
12 views
Check if field contains any numbers?
Hi I'm trying to write some VBA so that it checks whether one of my text boxes contains a number. The text box is called: CustomerName. Here's the code I am currently using:
Function ...
1
vote
1answer
19 views
Weird Excel bug when deleting sheet with named ranges?
I have an excel workbook that includes 2 worskheets, wkshtA and wkshtB. They both have local named ranges (the scope of each named range is just the parent sheet). Some cells in wksht B reference ...
0
votes
0answers
17 views
VBA (QueryTables) Error: Expected ')'
Getting an error: "Expected ')'" on Line 22, Char 60 (i.e. right at the "connection" in the QueryTables.Add function). This VBA is being called by a batch file. I'm trying to understand what is wrong ...
0
votes
0answers
12 views
Access Graph dropping series (and how to repair programatically)
I'm having a very strange problem with some graphs. There are 4 columns, the first column is the X-Data, the following 3 columns are y-data (Y1, Y2, Y3)
When I go to display the data it ignores the ...
1
vote
2answers
28 views
VBA - open excel, find and replace, delete row, save as csv
I am trying to write a program in VBA so that I can remotely manipulate an excel file from SAS (a statistical programming software). I want the program to accomplish the following:
open the ...
0
votes
2answers
36 views
Copy a column from one table into another table
I have tried this with ALTER TABLE to create the column followed by INSERT INTO. This kind of works, except each subsequent column starts after the previous column has ended. I guess this is how ...
1
vote
1answer
26 views
Need SQL to update table with data from another table IF numbers match
I have this function below that is letting user choose excel file and it imports the data into a table(MyTable). Its just a single column excel file. The table it imports into contains 2 ...
-1
votes
0answers
19 views
date rangy with sum quantity macro
Hi friends i have one doubt i have date range like 1-7,8-14 and so on,and i want sum of quantity month wise and grand total also,i do`t know how to create macro,please send me the code!
Output
Date ...
0
votes
0answers
18 views
Insert Image as a shape in Visio - VBA
I want to be able to import an image as a shape in Visio using VBA. I've tried to insert an image using the following, but it doesn't work...
myShape.Import(imagePath)
However, ...
