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
3 views
Run Time error 1004 :Method name of object _chart failed
I am getting a Run Time error 1004 :Method name of object _chart failed while I try to name my chart. The issue is that it runs sometimes and sometimes it doesn't. Here is the part that causes the ...
0
votes
0answers
4 views
Is it possible to run VBA code only affecting one row in a continuous form?
I have a continuous form that display the results of a query. I'd like to include a button on each line of the form that expands that line of the form to show some supplamentary data. I want to do ...
0
votes
0answers
12 views
SharePoint / Excel Data?
I have dozens of excel files on a SharePoint site. The purpose of these files is for employees to log complaints in them. There is a different file for each company location. I was wondering if it ...
0
votes
2answers
13 views
Setting a delimiter to generate an export
I found a VBA code that almost fits my requirements to export data to a CSV file. I am having problems with the delimiter function.
I have the following function:
Function DelimitRange(ByVal XLArray ...
-1
votes
1answer
13 views
Get and edit a file directory
I'm looking to retreive the directory of a txt file and then remove it's filetype suffix. The reason for this is so I can input additional text to the file name (which will be saved as, later in the ...
-1
votes
0answers
6 views
split orasql query into multiple workbooks in Excel using VBA
I am trying to split my ORASQL query into multiple workbooks with a specified number of entries for each book. I am using office 2010 if that matters. I think I should use what is below (from a ...
1
vote
0answers
10 views
Moving Files in MSOffice Access 2010
I am attempting to create a button on one of my forms in Access that will move a file from one folder to another. The filepath of the item is stored in the database. My current approach is using VB ...
0
votes
1answer
16 views
Modifying and appending to SQL tables using Excel VBA
OK, so I have some VBA I am wanting to use to update and add data to a table on an SQL server. I have been muddling through with limited knowledge of this functionality within VBA all day, searching ...
0
votes
2answers
23 views
Adding an Offset Row to a Given Range. Excel VBA
I have a variable which at the beginning is set to a given range.
I want to have a loop statement that would take the next row down from the end of the given range and add it to that range.
ie:
...
-1
votes
2answers
25 views
Referencing sheets with spaces
I am having an issue with referencing the sheet name through =Branded!$A$1 Notation in VBA. For a while I have passed in simple sheet names like:
Dim SheetName As Integer
SheetName = "Pizza"
("=" ...
-3
votes
0answers
7 views
ActiveX GIS control for Microsoft Access [on hold]
I'm looking for an ActiveX control to display a map within our Access database. Features I want to achieve are:
Display a map, and place waypoints from a query within the MDB file on the map, along ...
-4
votes
0answers
27 views
Chiinv function in VB [on hold]
I'm having problems writing the formula for the CHIINV function I had on excel.
I'd like to find out the equivalent of the excel function CHIINV which is useable in Visual Basics.
I attempted the ...
0
votes
0answers
10 views
MS Access two-listbox control
What is this side-by-side listbox control called? Can it be used in MS Access 2010, or do I have to make it from scratch? (this question has nothing to do with the query wizard--I am trying to see if ...
0
votes
4answers
32 views
Excel VBA setting cell value to a formula
Hey Everyone I have some hard code in excel vba that will set a given cells value = to a formula and i have multiple lines of code that does this for each cells value but changes the formula to look ...
0
votes
7answers
48 views
How to delete entire row in Excel if a cell contains a specific value
I have the following dataset:
A B C
1 dog232 cat3e12 mouse23
2 cat4234 cat21 mouse12
3 mouse312 mouse13 dog32313
I want to write a VBA subroutine ...
