Tagged Questions
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
1answer
4 views
Excel VBA InputBox not returning range values in loop
I have used this code in the past, but today it is not working for some reason. I have scoured the internet for answers, and from what I have read my InputBox is set up correctly. When i use the hard ...
0
votes
1answer
15 views
How to make REST call with VBA in Excel?
I tried to follow this example: http://libkod.info/officexml-CHP-9-SECT-5.shtml
but it gave this error
on this line:
Dim objHTTP As New MSXML2.XMLHTTP
I tried to use this example: How can I ...
0
votes
1answer
7 views
EXCEL - My code only runs some times, is there a way to call a private sub by clicking a button on my sheet?
How do I call this function by pressing a button on my sheet? I want to be able to make sure that my macro runs, and currently it only runs if I open the code and then press enter after the last end ...
0
votes
0answers
7 views
Add watermark on word template via VBA
How can I add watermark on word template(.dot) (2003) via VBA of MS Access 2007.
I have MS Acess application that generates letter and templates are stoared as .dot files. I need to add watermark via ...
0
votes
3answers
15 views
What are all the properties that i can assign to “with outlook” with VBA?
Like in VBA we can create object to run and manipulate other applications, i was trying to do few jobs in Outlook by writing a MACRO in excel.
Eg -
With OutMail
.Subject = " Event 1 "
...
0
votes
3answers
21 views
Excel Replacing Cell formatting with VBA
OK so i would like to figure out a way to change the cells within the worksheet behind the scenes of Excel 2007 with VBA so if i have something in Cell A1 and B1 then C1 will automatically populate a ...
0
votes
1answer
11 views
Group simultaneous data in a Summary Table using VBA
I have an ID column (A) and a column of variable data (B) as shown below.
A B
1 0.1
2 0.1
3 0.1
4 0.2
5 0.3
6 0.3
7 0.2
8 0.3
I need ...
0
votes
1answer
18 views
select all non-blank rows and cells using VBA
I'm new to VBA and I've been trying to figure out how to open an input file and copy those contents to a hidden sheet on my workbook, I saw an example on how to do this but the number of rows and ...
2
votes
1answer
13 views
Applying Button+Macro across all worksheets
Forgive my ignorance (newby and little knowledge of VBA)...
I have developed some macros that are attached to buttons, and working in one worksheet in a workbook. The macros perform various jobs on a ...
1
vote
1answer
20 views
Run-time error '1004' : Method 'Range' of object'_Global' failed 6
Okay. Just this last issue I hope. I have my code in another area and was getting some great help. I am assuming he (Ratafia) is very busy and have not heard back today.So I thought I would repost ...
1
vote
0answers
21 views
ACCESS 2010 System Resource Exceeded
My team were working with access 2000, where we have our MDB project. This application(ERP) could open around 20 access forms. After we decide migrate our entire system to Access 2010 to its new ...
0
votes
0answers
25 views
cut and paste between worksheets macro
Newbie to VBA.
I have a workbook w/2 sheets. Sheet 1 has the data below starting in A1
A1 B1
Storeroom Balance
ALF-Main $100,000
Sheet 2 has a list of storerooms and ...
1
vote
2answers
17 views
string with sheet names convert to array formula (code)
I have a formulated cell containing one string specifying only the worksheets where I want to modify certain cell under certain conditions:
Notes:
Worksheets "Total", and "Test1" through "Test20" ...
-1
votes
1answer
23 views
Methods for comparing monthly reports in Excel
I have been given a new task at work and it is a bit of a new area for me.
We are having our annual slow down and to try and keep me on the QA team some of my time is being loaned to the Reporting ...
3
votes
0answers
23 views
VBA event raise only once (intermittent)
Context
My VBA code often replace worksheets inside the Workbook. Therefore I can't use code directly in the worksheet module as it would be eventually deleted in the process.
I use a user-defined ...
