I have a workbook and I want to delete the entire row if the word "Program" appears in the text string. In column A there are thousands of rows of data. I want to delete the entire row if the ...
Hi all,
I am looking for function or routine in Excel/VBA that will search for any part of a text string in a given range. Like, in collumn E I observe that a cell contains: DANSKE BANK A/S ...
I am writing an Excel macro to save a file as *.xml. I need to keep the SaveAs path relative because my clients may store these files anywhere on a shared drive or web server. I am not sure of...
Title says it all. I have a client with over a thousand Lotus 123 wk4 books that I want to batch convert to Excell 2003 workbooks. And yes, I know Excel 2003 can read these workbooks, but I...
I'm trying to insert a value in an Excel 2007 worksheet cell from a VB.NET 2008 application. It looks like the value is being written into the cell correctly, however all the formulas that re...
There is one user who accesses excel spreadsheets via a network share who often gets error message: "filename.xls is locked for editing by the username(its the user themselves) click to notify...
Hi,
I am trying to programmatically create a pivot table to run from a macro button on a instruction page. I have attached my code. It is a recorded macro and it does not work. I recieve e...
Hi All,
Anyone have an idea on how to get an Excel Macro to do the following:
1) Go through a worksheet and select a range of rows based upon keywords in cells.
2) Copy and Past...
I have 34 pivot tables sharing 6 pivot caches.
Each pivot cache is linked to SQL server query and I update each of the 6 caches by changing the date in MSQuery SQL line. For example, here ...
I have recorded a macro that copies a range of data and then goes to another worksheet and moves to the end of the existing range of data and pastes the data. This will be repeated daily and ...
I am developing an excel timesheet for my organization. I have two units A and B
Unit A :
--------
Work Start Time : 9:30 AM
Work End Time : 7:00 PM
Tea Break Time 1 : 11:45 AM
...
How can I add/remove the data labels on a pie chart through VBA? I am attempting to make a template for all of my managers to use. However, they will not all use the same categories, so I am...
Hi,
I wish to change the colour of groups of rows where a particular fields value is the same to colour number 1. When this value changes, i wish to change the colour to colour number 2 and...
Basically, I have a workbook with 4 sheets and would like to have a macro that saves one of the worksheets as a tab/semicolon delimited text file to a specified location once the workbook is e...
whenever i am trying to save excel sheet into ms access database 2003.it is throwing exception i dont know why?kindly help here.
using System;
using System.Data;
using System.Configuration;...
When I try to preview an Excel 2003 document, I get a message "Margins do not fit page". When I OK thru the message, it looks like each individual cell is going to print to a separate page. ...
I am looking for a VBA that will find the first empty cell in a column and copy the cell directly above it and then go on to the next and do the same until the end of the spreadsheet.
Ideal...
I am having trouble with an Excel Macro. I need to save the current file with the same name in it's current directory. I also need to save the file as *.xml with the same name in a second dire...
I would like to be able to format the data series for the attached formatting macro:
I would like to add a case so that GNE+Contractor is a dashed line, So that data will not be obscured if...
My client has a Windows Server 2003 R2 hosting a shared directory. The share has an excel spreadsheet that everyone had "Write" access to through NTFS permissions. The top level share has Sh...
I have an excel 2003 spreadsheet. one sheet is password protected. I have the password but when I go to tool/protection the choices unprotect sheet and unprotect workbook are subdued. I cannot...
I've setup Track Changes in Excel to monitor changes by users for a spreadsheet. Was wondering, besides the Worksheet_Change Event, is it possible to write some VBA which at any point in time ...
Hi,
Excel file too large takes long time to open,save etc.Can all the macros be saved some where and i should be able to run them when required.
Can i have all macros in some folder.When r...
Hi!
I installed Office 2003 SP3 on many PCs of my company.
When I launch Excel, the error "System Error &H80004005 (-2147467259). Unspecified Error" appears.
To close the error form I need ...
Hello all.
I need to count the number of characters in a cell. I say characters because the field contains numbers (formated as text, because of leading zeroes) and a dot.
So you have a...
