Tagged Questions
0
votes
0answers
8 views
VBA- Data from Webpage not accessible after Login
I am trying to access a web page which uses POST method. Once I enter into the
site, the user has to provide the Login and Password. Once it goes to the main
page , am trying to copy the entire ...
0
votes
4answers
15 views
excel 2007 VBA Subscript out of range
I am using the code below to identify duplicates in a column and delete ALL duplicates if found. I have the exact same code in another workbook and it's working fine. However, I am receiving ...
1
vote
2answers
18 views
Excel VBA code modification so only alert me once for same item
I manage a contract log that list out all of my company's contracts with the effective and expiring date.
I've written VBA code that alerts me whenever any one of the contracts is about to expire; a ...
0
votes
1answer
20 views
VBA Macro to insert Average in the last row of each column with dynamic ranges
I have a number of columns (in Excel file) that represent months of the year; each column has a number of records and I'd like to be able to run a macro that would insert a cell in the last row of ...
0
votes
0answers
21 views
Trying to create a key for spatially related records using a VBA loop
So what I have on my heads is an excel file with several hundred thousand rows created by a programmer with no concept of analysis / relational databases. This file essentially contains three separate ...
0
votes
1answer
18 views
Excel VBA: Waiting for another application to complete an OLE action when macro tries to open another workbook
A little background to the title: I've written a macro that gets called on workbook open. It opens a [shared] workbook on a shared directory and pulls in some information to the workbook the user is ...
1
vote
2answers
18 views
Excel VBA application.inputbox workbook
I am trying to get the name of a workbook and worksheet from the Application.InputBox command in excel so that I can switch between the Active Workbook, and the workbook I have selected values from ...
0
votes
2answers
38 views
Custom function will not update automatically (settings are set to auto calculations!)
I have a custom function that detects if a cell is bold
Function isBold(cellBold)
If cellBold.Font.Bold = True Then
isBold = 1
ElseIf cellBold.Font.Bold = False Then
isBold = 0
Else
...
0
votes
0answers
28 views
form not load succesfuly from vba
I´ve been reading for a couple of days and I found out that maybe my problem has something to do with a bug, but I don´t know how to fix it.
I have two Sheets, each one has a button called ...
0
votes
2answers
28 views
Wrong VBA date format in Excel cell
I'm trying to print out different date formats in my Exel sheet using VBA. However, I can't seem to output the "yyyy-mm-dd" format, or the "mmm dd, yyyy" formats. The cells don't seem to print out the ...
0
votes
0answers
14 views
Accessing Outlook email info into excel worksheet (VBA): body, HTMLbody, RTFbody is <> empty
Thank in advance for the help... my Googleness has failed me today.
I have found quite a few sources on accessing email info with excel VBA, and for the most part I can get them to work. But for ...
0
votes
1answer
16 views
Excel VBA adding lines to a word document table
I'm trying to find a way to add lines and information to a prebuilt table in a word document. The table is right now only two lines. The headers and a blank line (2 Columns). How would I go about ...
0
votes
1answer
15 views
can't use application.worksheetfunction.linest in a loop
i'm trying to make a function that calculates the LINEST for a different ranges of data within a big two dimensional array, everything works fine except for when i need to use the function LINEST ...
2
votes
0answers
27 views
Move mouse pointer to center of active cell when navigating with arrow keys
I am attempting to have the mouse pointer move at the center of the selected cell when navigating from cell to cell with the Arrow keys
In Excel 2010 the following solution works perfectly
Public ...
0
votes
1answer
23 views
Paste cell by cell into word from excel - loop help please
I need some help in getting this macro to repeat copying content from a cell in excel over to word multiple times please. Working in Word VBA.
Goal: I have a range in an excel workbook about 250 ...
