Hi Guys,
I am having an issue where the macro runs but once it opens another workbook, it just stops at
Workbooks.Open OpenFile
Once the second workbook has been opened, the active workbook WBName is the workbook I would like active.
I initially had this in a worksheet to run when a cell...
Hi All,
Using Excel 2016, I would like to be able to insert a Google Map image for a given address. This could be either an embedded map or just an image of the map
The workbook may call for multiple embedded maps or images of maps for multiple addresses.
The Microsoft Web Browser add-in does...
Hi All,
I have a list on a webpage:
Coy 1
Coy 2
Coy 3
and I want Excel to "click" on Coy 3 and load the corresponding page.
With the underlying webpage code being:
<a href="/gdfd/Do/Something/FTRED" class="name" data-automationid="dashboard">Coy1</a>
<a href="/gdfd/Do/Something/hdYnd"...
Hi Guys,
I am trying to get the RGB values of a cell and I have found a function which does that here.
Function Color(rng As Range, Optional formatType As Integer = 0) As Variant
Application.Volatile
Dim colorVal As Variant
colorVal = Cells(rng.Row, rng.Column).Interior.Color
Select...
Hi All,
I have a list of dates which are assigned:
Financial Year;
Financial Quarter; and
Month.
What I am trying to do is identify missing months in each of the financial years in the table and add the dummy data into the tables.
In the example attached the months missing are January 2015...
Hi All,
I am trying to insert a calculated field where the values to be inserted are 50% of the total of a grouped set of columns.
I have found many examples of ungrouped pivot tables, but not on grouped tables.
In the example attached, I would like to add the calculated field of "Budget"...
Hi All,
I am having a little trouble trying to work out whether it is possible to perform calculations on grouped items within a pivot table and subsequently generate a pivot chart?
I have not been able to work out an "elegant" way to do it, just the clumsily put together example in the...
Hi All,
I am trying to work out how to generate a pivot table using only those accounts select and stored in two arrays (DataSet1Array() and DataSet2Array()).
The trouble I am having is using each account number in the array to determine whether an item should be visible or not. The best I...
Hi All,
I have recorded an SQL Query which I would like to amend to include a calculation where two columns in the table are multiplied.
The query:
With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _
"ODBC;DSN=MS Access Database;DBQ=" & fpth & ";DefaultDir=" & fdir &...
Hi All
Does anyone know of any resources which can teach me about preparing DB queries in excel using VBA? I have no idea and recording Microsoft Query macros will get me so far.
I have looked around, but most of the stuff I have found assumes I know more than I do. I need to start at the...
Hi All,
I have two tables:
COA; and
UPCOA.
The COA table is the table which the user works with to categorise various account (in cloumn G).
The UPCOA table is the imported table from a database which contains the latest information from which the COA table requires updating.
From time to...
Hi All
I have a situation where X people have given and received an amount of things amongst themselves. I need to be able to "net" off the series of related transactions.
In the simple example attached, person A has given 100 oranges to person B. Person B has given 70 oranges to person C. The...
Hi All
I have been tasked with challenge, manage a client list in Excel that will also manage Outlook appointments.
I have found some code which I have superficially altered:
Option Explicit
Sub AddToOutlook()
Dim OL As Outlook.Application
Dim olAppt As Outlook.AppointmentItem...
Hi All
I have some data which I am trying to chart which is spread across 3 revenue centres:
Property Sales
Project Sales
Property Management
Each of which has a series of associated costs.
What I am trying to do is create a dynamic chart which is dynamic in relation:
Months Charted -...
Hi Everyone
I am getting an run-time error when a my function then looks at a sub.
Would any be kind enough to please take a look, I have been unable to resolve?
Cheers
Shaun
Hi all
I am still trying to create a report in Word 2010 from data out of Excel 2010.
As part of report I need to apply styles to text within the report so that the table of contents updates correctly. Despite every effort I have been unable to apply the formatting.
In the following I am...
Hi All
I am trying to get data from excel in to a MS Word document and I have found some code which gets me most of the way, but I am not sure how to modify to take the data from the cells and enter into the table.
There are a few conditions for the Word table:
row one will always be the...
Hi All
I am trying to work out how many sleepers are required to build several retaining walls of varying shapes and sizes. I have a long holiday period coming up. The trouble is if I order too few sleepers and need to order more the colours won't match as each set of concrete sleeper is...
Hi Everyone
I am using a vlookup to consolidate what will eventually be 4 quarters of financial information. When a value is not available I am getting the error #N/A which I would like to replace with a 0.
In Excel 2003 there is the ERROR.TYPE() function which I have tried to manipulate so...
Hi All
I have a situation where an Index/Match evaluates to #N/A for each column in the same row. For each B1 value the #N/A will shift rows or not be present at all!
I have tried re-entering affected data manually, but this does not correct the issue. I have rechecked the formula and it...
Hi Everyone
I am having some difficulty with a series of charts where the x axis is a date series where not all dates a represented, typically Monday to Friday. This leaves gaps in the charts as the series is date formatted. After I set axis 1 category type to xlCategoryScale to remove those...
Hi All
I have a series of .csv files which I need import and save as .xlsx files. The .csv files over time will change with deletions and additions and the files getting additional data periodically. I have recorded and utilised existing code to cycle through the list of .csv files in the...
Hi All
I have a list of "jobs" to be completed, as the work comes in I enter the date the work came in (column O), from there the work is allocated out to various people. What I would like to be able to do is if I enter a date in say cell O3 "07/08/2013" (August 7) I would like Excel to force...
Hi Everyone
I am having a little trouble with some conditional formatting.
I have some due dates:
A1 `15/05/2014
A2 `31/03/2014
A3 `28/02/2014
A2 `31/10/2013
...and posibly some others
What I am trying to do is set a rule which fades from green to yellow to red the closer I get to...
Hi All
I am wondering if it is possible for Excel to obtain two specific pieces of information caontained with HTML source; Delta Whiskey and 7517.png from:
<td class='horse'><a class='GreenLink'...