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...
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 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...
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...
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...
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...
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...
Hi I presently have a difficulty with importing csv files into excel using VBA. I have created a macro which is meant to read each record from a csv file and put it into excel. The code also n...
Hello Experts,
Something weird just started happening: up until last week I was able to open files created with MS Excel 2007, but for some reason xlsx files cannot be opened with Excel 200...
I am looking for code to loop through a range and if the value in the range is numeric i want it to copy the entire row to a new worksheet. I have the prelimenary code below, but do not know ...
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 am wanting to use a formula in Excel that will calculate the difference, in percentage, between two times and either show it as an increase, or decrease..
The cells are formatted hh:mm:ss
...
Hi,
How can I test in VBA if the excel-cel is empty?
Now I have
if Cells(x,5).Value <> "" And Cells(x,5).Value <> "''" then ...
But this don't work. If the cell is empty he exec...
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 was trying to use Excel if statement for string using wildcard character. I was trying to use luke this
=If (C1="F*","F")
But, it didnot work. I know that LEFT command does this. But,...
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 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...
Each month for our income statement monthly report I run 4 reports from our report writing program and save the results as 4 separate Excel files. The problem is, the company officers do not ...
How do I insert a check box in Excel 2007?
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...
I am not able to convert a number greater than 24 into h:m:s
I use the formula =(H5/24;"hh:mm:ss") but this only works up to 24.
When I try this with 27.50, the result is 03:30:00 because ...
I have an excel file that needs to enter data into a web page. Click a button, wait for it to load the results and copy the results into excel.
Below is the source code for the site, and m...
Experts,
I want to understand how to use a radio button in Excel/VBA.
I want it so that if I select a radio button the contents of a cell changes according to the code. For example from ...
Yesterday I thought I understood isblank, but I was wrong.
Today I am 100% sure I really really understand it which means I'm sure to be wrong again.
Will someone just check this out and...
