Hi all,
The following script works like a charm on my workstation
<dummy_script.vbs>
Dim objExcel
Dim objWorkBook
Set objExcel = CreateObject("EXCEL.APPLICATION")
Set...
I have been getting this error lately when working with Excel 2000. Basically when you are trying to copy&paste I get an error that says "Cannot empty clipboard" and I can't figure out why th...
Hey all, I have been assigned a new project that will require a little VBA, and my VBA skills are very elementary.
I have 100 files (Book1.xls through Book100.xls)
All files reside in C:\T...
I have an Excel file with UsedRange = A1:CH102. The saved size is 4151 kB. I have found a way to reduce the size:
Option Base 1
Sub ReduceSize()
Dim lAntR As Long
Dim iAntK As Inte...
Hi,
I would like to know what should I do in order to save an Excel work sheet (Password Protected) to an Excel unprotected work sheet.
For example:
Excel file A is protected by pass...
I want to loop through each row of a spreadsheet and based on the value of cells in column b, copy the contents of the cells in columns a,b , d, h, j, and copy it to another workbook. I have...
We are slowly rolling out Office 2007 and have been experiencing problems with th eslow opening of spreadsheets in Excel 2007. We did have the problem that when you double click a xls or xlsx...
Trying to help a friend here. Every time he launches Excel (Office 2000 running on Win2k Pro) a box pops up with "Runtime Error 9: Subscript out of range".
Note that this is when launching...
I'm a newie in the Access world, so I need a little "push" to get me in the right direction. What I'm wanting to do is build an Excel spreadsheet that will ask the user a series of questions ...
I'm new to this forum and this is my 1st time to use VBA....
I've looked thru the forum and I found that the someone has answered similar question before but it only has the code posted . So ...
I asked the same question earlier, but perhaps this question belongs in this section.
I am writing a small piece of VB code for Excel to prompt the user to open the file he needs to work w...
Ok guys, I've come to you with another annoying (for me anyway!) Excel VBA combo box problem. First of all, this is just something I am doing for fun, I have no professional programming exper...
I have two monitors, so I like to compare speadsheets side by side.
When you open a Word document, it alwasy opens in a new window (adds a window to the task bar). Is there a way to get Ex...
Hi,
I have values in my excel spreadsheet that are DATE value. I.E. they are stored as Julian dates, and appear on the screen as "7/12/2006" etc.
If I convert this field to general text...
I have an Excel VBA macro which I am trying to get to run a batch file.
My code so far appears to open the dos window and immediately close it. The batch file does not appear to run.
As...
I have a spreadsheet that we download once a year from a source and then we go through and color code the sheet. I would like to develop code that based on a value in a cell at the end of the...
Experts, I would like to create a list in a UserForm using Excel VBA that fulfills the following requirements:
a) allow multiple selections,
b) only allow items contained within existing l...
I need to do a vlookup like function from within an Excel VBA procedure.
I am building the value to lookup from within the procedure, after that I simply want to do lookup on range, using t...
i need to urgently convert my xlsx files to xls. can anyone help me please ? my offcie3 2007 beta lapsed and i have not converted them back and im stuck now !
please reply soon.
Thank ...
I have an Excel document that gives the following errors message on any computer (Office 2002/2003):
"not enough system resources to display completely"
This is a very large document and I...
I want to create a chart with one x axis but multiple y axis points.
E.G. i receive excel spreadsheets for processses that our software runs. i would like to chart these results to anal...
Hi -
I have a report that gives me the date in this format:
12/7/2006 2:07:25 PM (dd,m,yyyy)
I need to covert it to mm,dd,yyyy and would also like to drop the time portion of the f...
Last week Charlotte found that she was no longer able to save a shared Excel spreadsheet which was about 6MB in size. It just said "Document not saved". Sometimes it says that the disk is fu...
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, is it possible to have Combo Boxes in cells in Excel? If so how? (I commonly program in MS Access, but not much experience in Excel.)
