VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
1
vote
0answers
7 views
Loop in vba which will go through all sheets and get data
I would like to see if somebody can show me a cycle in VBA Excel that will do the following action:
Let's say that I have a variouse unknown number of sheets with unknown names and than one final ...
-1
votes
0answers
14 views
Excel Macro Slows to a crawl
The following Macro slows down very quickly - I am unsure how to update the code so that it runs more efficiently. Any recommendations/edits are appreciated. There is certainly some brute force in ...
-4
votes
2answers
26 views
How do you change the value of a cell in excel by clicking on it using VBA?
I've scoured google for some time now and I can't seem to find my answer.
I have a cell that says "In Service", once you click on it, using VBA, I want it to change to "Not In Service" and if you ...
0
votes
0answers
7 views
Powershell Connection to a server, open Excel macro on Server
I am trying to see if there is a way to open a direct connection to a server and open an excel spreadsheet and run the macro using the server's resources. I was thinking that windows powershell is the ...
0
votes
1answer
17 views
Excel - how to get min value in a group
I've simplified my example to be something like this:
ID Value MAX
Group1 2 6
Group1 4 6
Group1 6 6
Group2 1 3
Group2 3 3
Group3 7 8
Group3 4 8
Group3 2 8
Group3 8 8
...
1
vote
1answer
52 views
I need helping writing an excel vba Splat function
I'm using Excel 2007 and need some assistance / guidance on how to write a Splat user defined function function. The Splat function enables you to input data into a cell that contains a vlookup ...
0
votes
1answer
27 views
How to lock Excel cells in VBA?
I have an Excel worksheet that acts like an application, with form control buttons allowing users to 'navigate' through records. First, Previous, Next & Last cycle appropriately through one of the ...
1
vote
1answer
28 views
VBA to insert embeded picture excel
I have seen lots of posts about us xlApp.activesheet.Pictures.Insert(strImagePath) to insert pictures into a spreadsheet with VBA, which works great. The only problem is it inserts it as a linked ...
1
vote
1answer
44 views
VBA code to copy and paste certain data from sheet to another
I'm new to VBA and I know there has to be a simpler and more efficient way of writing this code, but not familiar with the correct functions (like how to paste to the next worksheet without pasting ...
2
votes
4answers
33 views
How do I return To Cell A1 after clicking a button?
I have a button at the bottom of my excel sheet that generates another sheet ounce clicked. That function works fine but I need to return to the top of the sheet after I click the button and not to ...
1
vote
0answers
21 views
VBA to paste values when formula changes
I have created a excel forecasting workbook which is mainly formula driven and works fine. The only thing left to do is for the workbook to automatically paste special values when the cell reference ...
0
votes
1answer
22 views
vba for Internet explorer - How to show error message box when Dropdown selected for month is empty
Here you have my code. I've put some remarks where I need to do check the empty dropdownlist.
Dim IE As Object Application.DisplayAlerts = False
Dim chromePath As String
Set IE = ...
0
votes
2answers
39 views
to get the sub-string which has common starting word and ending word in Excel VBA
I have a log file where I want to get the sub-string which start with <fullpath>" and ends with ". For Example:
Member ID=":LtWeek2:1133548" fullPath="Time.Latest Weekly : FOLDER.Latest 52 ...
0
votes
1answer
23 views
Automate download of a dynamically generated file after NTLM Authentication using vbscript/java
I am trying to automate to download a dynamically generated file on a server, so here are the steps what I have to carry out manually -
Login to the site using my credentials - It uses NTLM to ...
1
vote
2answers
34 views
VBA SaveAs Method
After browsing forums for well over an hour, I can't seem to figure out why my save as code isn't working.
My goal is to save a new copy of the workbook under a different file type. (The current ...
