Tagged Questions
0
votes
1answer
56 views
Excel Macro to search folders and return files containing specific keyword and most recent version
I am looking for some help on writing a macro that will search a folder in my computer to see if any of the files in the folder contain a specified keyword, then return the file name, path and last ...
0
votes
0answers
11 views
Excel 2010 VBA: find out if formatting style exists
I want to check if an formatting style exists in an Excel2010 document.
On Error Resume Next
Private Function checkStyleName(ByVal strStyleName As String) As Boolean
Dim objGivenStyle As ...
0
votes
4answers
69 views
VBA: Select column and apply “General”-format to all cells + put macro on a button
I am looking to do the following:
When pressing a button, the Macro should be activated. The Macro selects Column H (not the whole column, just until data goes. The last line with data can be ...
1
vote
2answers
44 views
Excel 2010 VBA: How to store an array of worksheets as a variable?
I am trying to have several arrays of my worksheets that I can call up in my code using.
ThisWorkbook.Sheets(Array("Sheet1", "Sheet3"))
ThisWorkbook.Sheets(Array("Sheet2", "Sheet5"))
I am wondering ...
0
votes
1answer
30 views
VBA: Paste chart with a different name
I use VBA to copy and paste a chart.
ActiveSheet.ChartObjects("Chart1").Activate
ActiveChart.ChartArea.Copy
ActiveSheet.PasteSpecial Format:="Microsoft Office Drawing Object", Link:= _
...
0
votes
1answer
23 views
How to select a chart by iterating through all the charts
I need to iterate and modify properties of some charts one by one, but for that I use ActiveChart ex.:
Target_str = ActiveChart.SeriesCollection(2).DataLabels.Item(1).Caption
Target = ...
0
votes
1answer
59 views
Excel 2010 VBA: Save file using value from cell to determine path and filename
I am trying to write some code that will save several tabs as a pdf document in folder specified by files within excell. I would like for cells within the document to dictate where this file is saved. ...
0
votes
1answer
23 views
excel error: invalid or unqualified error
Sub Macro5()
'
' Macro5 Macro
'
'
Dim wbk As Workbook
Application.ScreenUpdating = False
Set wbk = Workbooks.Open("g:\Work\EU Personal Assignment.xlsx")
Range("O2:R2").Select
...
2
votes
0answers
43 views
Excel VBA changing my formulas in a table?
Has anyone come across a situation where Excel seems to manipulate your formulas.
I have a sheet where I have an Index value in Column A. The First row starts with any non zero Value. Subsequent rows ...
1
vote
0answers
61 views
Loop through code for multiple data sets - stop when blank cell found
Ok, maybe I need to revise this to get more of a response ; )
The code below works fine and does the following;
It looks up the required data shown in columns B (with column C being the copy ...
1
vote
1answer
62 views
Copy Multiple Column data between workbooks using Column headers as Selection criteria
Ive two workbooks and im trying to copy data from a global sheet to a dashboard. Now i know how to do it using vlookup and index(match()) but i want to do it without formulas is this possible?
The ...
0
votes
2answers
39 views
Show background color in Row
Goal:
If finding the word "Total" in a cell, the current row with word "Total" as a start point (with letter D in the column) and all the way to the letter H shall have a light grey background color. ...
1
vote
1answer
71 views
getelementbyid via msexcel vba object required 424
I have been struggling to get the getelementbyid (or name) code working. What I want to do is submit login details without using sendkeys. Probably is just a matter of not understanding the website. I ...
2
votes
1answer
71 views
Excel 2010 VBA - Storing decimal in array and using to chart percentage of stored value
SO Community,
I'm looking to automate some of the metrics that are used at my work using VBA. I am currently trying to read through an array that I have my ticketing raw data stored in and then ...
0
votes
2answers
52 views
How to call another module without returning to the first one after completion?
This is probably the dumbest question I've ever asked here, but it's hard to find answers to things like this.
I have a program with a bunch of modules/subs that each calculate a different variable. ...
