current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

0
votes
1answer
9 views

Simplifying code to simultaneously perform functions on 12 worksheets quickly

I am using the following code which is working successfully. Sub Button2_Click() Application.ScreenUpdating = False Dim rngMyRange As Range Dim cell As Range Sheets("Jan").Activate ...
-3
votes
1answer
18 views

Compare and arrange data

I have two data: Data A and Data B. I am required to arrange them using VBA Before Arrangement After arrangement Data A |Data B Data A ...
1
vote
1answer
22 views

Hide 1 row above and 8 rows below a cell which changes based on picklist from another sheet

I'm trying to automate a reporting form. Text values selected from from a validation dropdown list on Sheet1 designate (by way of formulae) whether or not cells on Sheet9 have a value of "" or a ...
0
votes
1answer
13 views

How to connect ms excel-2007 with mysql.

How to connect excel-2007 with mysql. I am on windows 7, 64 bit. Using excel-2007 32 bit and mysql version 5.1 , 32 bit. Can Anyone help me how to import my mysql table data in excel file. Thanks in ...
0
votes
0answers
24 views

In VBA is there a way to use a UNC path with App.NameSpace.Copyhere without causing an object error?

I am using Ron De Bruin's VBA method for creating a zip file from MS Excel 2007. My zip sub is as follows: Option Explicit Private objApp As Object Sub ZipFile(srcPath As Variant, tgtPath As ...
0
votes
1answer
46 views

List or Enumerate MSForms.dataObject Clipboard Format Identifiers

Is it possible to list or enumerate the format identifiers within a MSForms.dataObject Clipboard? Currently using Excel 2007 VBA... I have the correct references set up and am able to set the text ...
0
votes
1answer
16 views

Adding activeX Combobox untill the last full line

how can i add activeX combobox into a column "List Name" untill the last line of a grid? knowing that in the grid the only column that is always full with values is "C Type" I tried this : For Each ...
0
votes
1answer
37 views

Copying cell data between Worksheets based on condition

I have a Worksheet (main) with 2 columns that looks like the below: Name Nationality John Smith British Chris Banks American Jean Pierre French My requirement is to transfer the cell data in ...
0
votes
0answers
20 views

Excel VBA File not Found right after Excel listed the file from directory [duplicate]

I have written a VBA Programm that searches for certain Excel Files in a directory that the user has chosen. This produces a list of files, each of which is afterwards openend, some data copied and ...
-1
votes
1answer
26 views

Copying row specific conditional formatting formula [closed]

I have a lot of data in Excel (2007 if that makes a difference) and I need to conditionally format it so that my overall value in W5 to W115 will change colour if it is not equal to the sum of X5 to ...
0
votes
0answers
17 views

How to detect whether all 2 set combination of “n” items exist in two adjacent columns of excel sheet i.e,“nc2”

Suppose, I have data like below in two columns: Richard - Joseph, Maria - Mitchell, Joseph - Quinn, Richard - Quinn. Here we have a combination of Quinn, Joseph and Richard. I am poor at VBA. If ...
0
votes
1answer
22 views

Using VBA to create/delete chart via a toggle button

Embarrassed that the code doesn't work, anyhow: I have the objective of creating a specific chart using VBA via toggle buttons. If the toggle button is selected/pressed, the chart is created and ...
0
votes
0answers
119 views

Error loading DLL when trying Unprotect VBProject from VB code

I'm trying the code provided in this post by @SiddharthRout. But it generate an error Error loading DLL at line xlAp.VBE.CommandBars(1).FindControl(ID:=2578, recursive:=True).Execute . I'm ...
1
vote
1answer
47 views

Merging PDF with pdfforge.dll in VBA on Windows x64

So I'm working around a macro that should merge some pdf. The code is pretty simple and work well using a dll given by PDFCreator setup (pdfforge.dll), but only on Windows 32Bits (XP or 7). Here is ...
0
votes
1answer
29 views

Using a VBA- looking to construct a code that, depending on entered or chosen information in excel, will auto-populate a sentence in word

Using a VBA- looking to construct a code that, depending on entered or chosen information in excel, will auto-populate a sentence in word. For Example... In Excel: Question ...
-2
votes
0answers
22 views

Hyperlink to filter out the data in another excel sheet

I have a excel sheet titled "Summary" in a workbook and another sheet titled "User account" in the same workbook. The sheet "Summary" contains the columns 'UI', 'Functional' & 'Data Validation'. ...
1
vote
0answers
50 views

Two methods of selecting sheet2 and finding the last used row using a command button in sheet1 both fail

I have been trying to select Sheet2 from Sheet1 using a command button click macro. The final part of the macro is designed to find the last used row (offset by 1) and return the row number using ...
0
votes
1answer
26 views

Excel 2007 VBA copying matching rows loop

I've got a workbook with one "source" worksheet and several destination sheets. essentially the source sheet contains information that I need to match and split out to team members. I've got the ...
-7
votes
2answers
44 views

Convert a number to HH:MM in excel

From few hours i am trying to make a Time Sheet where a person can enters his TIME IN/OUT. I have asked the employee to enter the details of number of hours they have worked. After addition of all ...
2
votes
2answers
69 views

Table of 4 column (x,y,z, value) to matrix table

I would like convert data that has 3 columns to matrix table. I've tried to use offset formula and it works but my data is too large (about 100,000 cells) and it crashed. So, I wound like to try to ...
0
votes
1answer
31 views

Else without If Compilation Error

I'm not sure why this is throwing a compile error and telling me that I have an Else Without If. The error is on ElseIf lines. Everything else seems to be working. Any suggestions? If ...
1
vote
0answers
28 views

excel 2007 vba, delete matching folder name

I'm trying to zip through a folder and delete sub folders that match a name. The directory has a structure like this. <starting path> <starting path>\<main folder> <starting ...
0
votes
1answer
45 views

Run Macro on All Checkboxes in Excel from a Single Checkbox

I have the following code (credit Tim Williams, here Check box to select and deselect all other check boxes in spreadsheet) Dim CB As checkbox For Each CB In ActiveSheet.CheckBoxes If CB.Name ...
1
vote
2answers
45 views

Find and Delete all Comboboxes in Excel Sheet

I want to use VBA to delete all comboboxes in a sheet (form control type not active X) I have For Each s In ActiveSheet.Shapes s.Delete Next s The problem is it deletes all my shapes, and I'm ...
0
votes
1answer
27 views

Code causing formula not to work properly

I have a worksheet named data and several worksheets in the same workbook that are staff names. The data worksheet contains the summary of the individual staff worksheets. On the data worksheet ...
0
votes
3answers
53 views

importing data from many workbooks in different folders

I am looking to import/copy data from many workbooks into a summary workbook. The workbooks are arranged in different sub-folders, I.e C:\data1\results_2001.xlm C:\data2\results_2002.xlm ...
0
votes
0answers
33 views

Customize Excel Automatic Form Layout

I would like to create a UserForm that has the same functionality as Excel's built-in Form feature, but with a slightly different layout. Is there a way to alter the built-in form or to access its ...
0
votes
0answers
19 views

Refresh/script button not working all the time

I'm running an Excel 2007 report that queries a database, it draws data from 1 cell in the file . When I run script, it updates the connection string with the value I'm passing through it, and now ...
0
votes
1answer
31 views

How can I set a variable range to a table in excel VBA 2007?

I am exporting a data set weekly that needs to be set as a table, however there will be a varying number of rows each week (columns will not change). Here is what I have so far: Sub ...
0
votes
1answer
25 views

Formula to find 2nd lowest value with additional criteria

In D1 of my worksheet, I want the name of the worker with the 2nd to last (2nd oldest) assignment date/time. Column A lists Employees Column B lists the last Date/Time a task was Assigned Column A ...
0
votes
2answers
73 views

Countif formula with multiple criteria

In my workbook, I have a 4 spreadsheets - Data, Amy, Betty, Connie. Data has the following columns: Column A Column B Column C Column D Row 3 Employee Total ...
2
votes
2answers
32 views

How can I replace several Data cells with the same cell when they have a equivalent identifying cell?

So I am very new to VBA, so I apologize for my terrible coding. I have been searching for several hours to find an answer to this seemingly simple question, and I may have already run across it, but ...
1
vote
1answer
56 views

Excel VBA Adding 'paste special as value' icon to right click menu (cell context menu customization)

I wonder how to add new icon to right click menu using VBA code which will be the shortcut to paste special as value Excel functionality (which can be found in Excel 2010, but not in 2007). Adding ...
0
votes
1answer
58 views

Stop Font Color From Changing When Adding Conditional Formatting With VBA in Excel 2007

So I am adding conditional formatting to a column of cells that is dynamically created by the user with VBA. The problem I am having is that after the first format is added, any subsequent formatting ...
0
votes
1answer
51 views

Vba function or formula to extract last edit timestamp from a cell

There is a file with 100's of hyperlinked cell in excel, which the link gets updated on a weekly bases from multiple individuals. I was wondering if there is a formula or vba scripts to get the date ...
0
votes
0answers
27 views

vba Excel 2003 format to Excel 2007 format

I changed the file Excel 2003 xls format to Excel 2007 xlsx format. I was able to change, but there are some files that I cannot open. When I open specific file. It says "excel removed part ...
0
votes
1answer
21 views

Excel Macro 1004 error on vlookup function from 2010 to 2007

I'm new here but excited to find the community. I'm new to macros, so forgive me if this seems rudimentary but I haven't been able to find an answer in any of the forums yet. I recorded a macro in ...
0
votes
2answers
33 views

Colour shapes based on value in array

I am trying to automate colouring shapes in excel dependent on values in a table. The approach I have taken is to read the table into an array, then I want to use this to determine how to colour the ...
7
votes
0answers
150 views

Why are EXCEL XLSM format no longer a valid ZIP format?

Files saved in Excel as XLSM files are no longer valid ZIP files, preventing editing of the Ribbon. XLSM files saved on or prior to May 23, 2014, can be renamed .ZIP and edited. XLSM files saved ...
0
votes
0answers
40 views

Excel External Data into a Table

I am working on an excel spreadsheet that takes data from a CSV file (produced automatically by an external system). I have used: Data->Get External Data->From Text And it works perfect ! However ...
2
votes
1answer
51 views

How to copy data from variable Excel workbook with VBA?

I want to copy the content of variable other Workbooks depending of the scenario (example: I want to copy the data from Workbook data2013 or data2014, etc). I've been able to do it with a specific ...
0
votes
0answers
38 views

Object Library not registered

I am using Access(2007) vba to process an Excel(ACCDB) workbook on a Sharepoint 2007 document library. In the process, I update two properties using the ExcelWB.ContentTypeProperties() proerty. It's ...
0
votes
1answer
50 views

Hide Rows when a specific string is in a cell

I have a problem with VBA in Excel 2007. I need a macro to hide rows when a specific string is in a cell. (e.g. "System PPP cancelled") My macro: Sub HideRows() Dim Cell As Range If ...
-1
votes
2answers
38 views

Conditional cell disablement in Excel

I'm using Excel 2007. I want the following behaviour: If cell A2 is empty or contains value "Create" then cell B2 is inactive and the user cannot enter a value. If cell A2 contains the value ...
0
votes
1answer
60 views

Coloured charts - VBA Excel 2007 - data source colours to be reflected within the charts

I have worksheet which contains several bar charts, and the source data for those charts is colour coded and on the same worksheet. I have the code below which I was hoping would turn the colours of ...
0
votes
1answer
62 views

VBA Font Conditional Formatting in Excel

So I thought it would be relatively simple to format a grouping of cells as I create them in VBA though I guess I was wrong. My aim is to black out a group of cells unless a certain value is entered ...
1
vote
1answer
101 views

How to to add powerpoint slide titles?

The code below takes the ranges specified in excel and imports the range to PowerPoint. My struggle is that i am trying to add a slide title for each slide in the code but the syntax below doesn’t ...
0
votes
1answer
36 views

Microsoft excel calculates the time based on their own Excel Serial Number which prevents to calculate

Microsoft excel calculates the time based on their own Excel Serial Number which prevents to calculate the split seconds. Suppose a time format 56:23.34 (mm:ss:00) format where last "00" is split ...
0
votes
1answer
43 views

boolean variable being returned by UDF is not recognized by stock Excel OR function

Alright, I have written a UDF, which searches a given cell for a specific sub-string. It then returns TRUE is the sub-string is found in the cell, and FALSE if it is not found. Here is the code for ...
0
votes
0answers
52 views

Insert file names from directory into Excel

I found the following code to insert the names of files in a directory Option Explicit Sub GetFileNames() Dim xRow As Long Dim xDirect$, xFname$, InitialFoldr$ InitialFoldr$ = "C:\" '<<< ...

1 2 3 4 5 … 20