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
6 views
Wrong VBA date format in Excel cell
I'm trying to print out different date formats in my Exel sheet using VBA. However, I can't seem to output the "yyyy-mm-dd" format, or the "mmm dd, yyyy" formats. The cells don't seem to print out the ...
1
vote
1answer
6 views
VBA error loading .NET COM Visble library
So I am trying to register and use a .NET library that I have created in C#.NET and up until now I have been getting Visual Studios to "Register COM" on build.
I am now trying to go through the ...
1
vote
0answers
5 views
Cannot view records in form ms access after assigning record-source
Please help,
I have this table ‘Source_RM’:
Source.........Raw Material.....Waste Date.....Waste Quantity
Store.............Sugar...........13/06/2013.................10
...
0
votes
0answers
8 views
Two different colors in a same datalabel VBA
I have a chart on excel with a curve. The curve represents the price of a stock depending of the time (so basically I've a column A full of dates and Column B full of prices and a chart).
Now for ...
0
votes
0answers
8 views
Accessing Outlook email info into excel worksheet (VBA): body, HTMLbody, RTFbody is <> empty
Thank in advance for the help... my Googleness has failed me today.
I have found quite a few sources on accessing email info with excel VBA, and for the most part I can get them to work. But for ...
1
vote
0answers
5 views
Creating an MS Office add-in that adds a new tab to the ribbon interface and presents macros to the user as buttons on this tab
I wish to create a Microsoft Word add-in for use by others in my office which will give them access to a few macros that will increase productivity and possibly prevent the odd mistake from happening. ...
0
votes
3answers
16 views
Display all datetime fields within a database with multiple table before a certain date
I am looking to create a bit of VBA code which looks through my linked tables (to an SQL Server) and outputs a list of any fields which are datetime and have a date under the year 1990.
I think i'll ...
0
votes
0answers
9 views
Create a Microsoft Outlook Task from Lotus Notes
I want to create a Microsoft Outlook Task from Lotus Notes and assign that task to someone. I create the task in LotusScript and this works fine if don't assign the task to anyone. However, I can't ...
0
votes
0answers
9 views
Excel VBA adding lines to a word document table
I'm trying to find a way to add lines and information to a prebuilt table in a word document. The table is right now only two lines. The headers and a blank line (2 Columns). How would I go about ...
0
votes
0answers
9 views
can't use application.worksheetfunction.linest in a loop
i'm trying to make a function that calculates the LINEST for a different ranges of data within a big two dimensional array, everything works fine except for when i need to use the function LINEST ...
1
vote
1answer
9 views
Specific referenc on one Array-element in an 2D-Array in VBA
i wanna have a reference on one element in a 2 dimensional Array like this:
dim ary(5,5) as String
ary(1) = "Michael, Thomas, Bill, Mike, Pascal"
ary(2) = "Iphone,HTCOne,SGS4,SGS3"
...
0
votes
0answers
17 views
How to excute query on existing recordset?
I have a table "TableA" with column name Name,"Y/N","Value1","Value2". This data is in excel file.
And have multiple entries for each Name.
1.Want to add one column to this table and calculate value ...
2
votes
0answers
20 views
Move mouse pointer to center of active cell when navigating with arrow keys
I am attempting to have the mouse pointer move at the center of the selected cell when navigating from cell to cell with the Arrow keys
In Excel 2010 the following solution works perfectly
Public ...
0
votes
0answers
10 views
how to add identity coloumn in access VBA?
I ran this command
docmd.runSQL("alter table XX add id int identity")
the command succeeded , but the column is not auto number , but regular int
I tried also identity(1,1) - but this gave me a ...
0
votes
1answer
17 views
Retreiving data from listbox to a range
I have a code which displays a non contiguous range from range (A1:E10) in a userform listbox
Private Sub UserForm_Initialize()
Dim rng As Range
Set rng = Sheet1.Range("A1:E10")
With ListBox1
...
