VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
6 views
Excel/vba find character, replace and make two characters after superscipt
What I want is to find "#" char, remove it and make 2 characters after it superscript.
I`ve got this code:
pos = InStr(mycell.Value, "#")
If pos > 0 Then
mycell.Replace What:="#", ...
1
vote
1answer
11 views
copy multiple columns from one sheet to another
I have a time sheet for my workers who log their time using the sheet having below order
Categories Washing Cleaning Office Duties Baking Cooking
Date Hours Hours Hours ...
1
vote
1answer
18 views
In Visual Basic 2010 - System.Net showing error on certain kind of web links
My aim was to create a small application which when given a website link such as
http://digikey.com/product-detail/en/ATF1502ASV-15JU44/ATF1502ASV-15JU44-ND/1008571/
it will extract datas from its ...
0
votes
1answer
36 views
VBA Code to rename & save
I work in a sales office and currently we use hard copies of all sales quotes and file them alphabetically. I have made an excel version of our quote paperwork to hopefully make everything more ...
1
vote
2answers
67 views
Workbook_BeforeClose across Application
I have Workbook_BeforeClose in 'This Workbook' of my addin, and when I open several workbooks in the same excel instance and try to close each one of them, Workbook_BeforeClose does not get called for ...
-1
votes
0answers
38 views
VBA Excel - Get suggestions for misspelled
I have a huge amount of words in txt file. Many of these words are misspelled and I want to check them by Microsoft checker via Excel macro. So I need to save all suggestions to another file or sheet.
...
0
votes
0answers
45 views
Excel macro that automatically highlights which values in a range are not ignored in formula/calculation with conditions
I need a excel macro that automatically highlights which values in a range are not ignored in a sumproduct formula with conditions or an if formula; for example in range A1:C1 if only values in cells ...
2
votes
1answer
15 views
Send data using msxml2.xmlhttp.3.0 to web to select Datepicker in EXCEL VBA
The following is the HTML of part of a web page.
"input name="ctl00$ctl00$AllContent$ContentMain$ucMktStatCtl$txtDate" type="text"
id="ctl00_ctl00_AllContent_ContentMain_ucMktStatCtl_txtDate"
...
0
votes
1answer
55 views
Get filenames FSO with comparision of filenames to sort first by specific namestructure. EXPERIENCED ADVISE REQUIRED
In the code below I could wrote a code to display filenames from a folder. The problem is now that I should display them in the correct Row. For now they are displayed in random sequence and that is ...
0
votes
0answers
12 views
How to Filter a column having greater value than the previous column using vba in Excel?
I have created a worksheet. I have a master sheet in which I pasted links of different worksheet. So I need to filter a column. But the condition is value should be greater than the previous column by ...
0
votes
0answers
24 views
Excel Web Data Import
I want to import News from a specific website for a given two dates to excel worksheet.
When I input Dates to B5 to B6 cells and Click on a CommandButton, Excel Might import all news from that page ...
-1
votes
0answers
40 views
Replace cell contents with multiple cells
Is there any way to replace a cell with multiple cells and have them relate to other multiple cell substitutions?
Worksheet A:
With a substitution logic in Worksheet B where the items in column A ...
0
votes
1answer
23 views
Excel Worksheet Change VBA to update formula range in a worksheet for changing input data
I have found this answer on SO that is close to what I want to do, but my knowledge of VBA is too basic to modify for my specific situation.
Automatically copy formulas as data expands
The ...
1
vote
1answer
18 views
Is it possible to change the backcolor of a activex checkbox to match the background color of the excel worksheet?
I am trying to get my ActiveX checkbox to match the same color on my excel worksheet. It would be better if the backcolor would be clear. Is there a way to accomplish this?
2
votes
2answers
36 views
#Ref error when delete one of the sheets
I have sheets from 1 to 50 and a summary sheet that has formulas based on sheet 1 to sheet 50 (very long formula!). However, whenever I run the macro, the macro will delete one of the 50 sheets and ...
