VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
8 views
Excel vba macro to insert rows only functioning properly on first worksheet
I have a macro to insert row of data above a date if that date isn't today. It then adds today's date in the date column. This is done across 30 worksheets but only the first worksheet is properly ...
0
votes
1answer
17 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
0answers
9 views
Excel closes when I close the main window in wpf
I have a Excel adding project which parses excel workbook and pops a wpf window. the problem is that when I close the window. closing action closes the workbook too.
the code is something like this ...
0
votes
1answer
10 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 ...
1
vote
0answers
7 views
How to make two buttons in Microsoft Excel sort a table upon click?
I have a spreadsheet with 5 columns (A-E). The first is "TEST YEAR", the second is "FORM", the third is "QUESTION, the fourth is "TAGS", and the fifth has no header title, but it still has data. At ...
0
votes
0answers
8 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 ...
1
vote
0answers
9 views
How can I prevent a user from copying cell protection in an Excel worksheet
All,
I have an Excel workbook that contains some protected cells and some unprotected cells. Everything is working great, except when an end-user is copying from another worksheet that contains cell ...
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
19 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 ...
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 ...
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 ...
0
votes
1answer
29 views
VBA Excel - List of Prime Numbers less than User Input
I want to make a macro in VBA Excel, that will generate list of all prime number equal or less than user input...Please give me the Idea, Thanks RS
0
votes
0answers
18 views
PDF print out code
I am trying to "print" multiple sheets into a PDF but am getting a 1004 run time error on the following code. Any help would be greatly appreciated.
Private Sub CommandButton3_Click()
...
-1
votes
1answer
24 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 ...
