I have a vbs script, opens a spreadsheet, reads some data and
uses that to launch some other scripts.
For a long time, it's worked just fine.
All of the sudden, after the script has read the data,

I have the following grid setup:
                  Amount 1   Amount 2
1/1/05          $500.00     $400.00
1/2/05          $425.00     $325.00

Greetings to all,
Not very experienced in vba at all, just enough to be dangerous.
Willing to learn, however.  Here is my problem: I have a Worksheet wit
a multitude of sheets, each with a Unit name.  There is a table in th

I am trying to write an Auto_Open query that will refresh a workbooks
MSQueries (activeworkbook.refreshall) but ONLY if it is opened before 9:00
AM.  I do this because I have a scheduler open a number of files before I
get into the office and want the refreshed done before I get ...

Dear users,
I have made a userform with a DTpicker that I use to insert time into a
cell. If I run the macro and open the userform I can enter the time but
besides hours I have to scroll through the minutes to set the time on hh:15,

Someone in my area created a macro a couple of years ago that did th
following:
1)  Copy / Paste Special Values the selected ranges in the worksheet
2)  SaveCopyAs a new, predetermined file name (with the hard-code

Hi,
I am right now working Excel using VBA.  I am using DAO for reading a
external sheet data.  I am not getting the output.  Can some one hel
me in fixing this problem.  Following is the code snapshot:

I have used the following code to disable all menu bar items except File and
Help. Is there a simpler way of writing this code. My code works but I am
just curious.
Any help is appreciated.

Hi, I am looking for a way to select a printer when code is run.  This file
may be run from different computers which have access to different printers.  
I'm wondering what the best way is to have the printer window appear and
allow the user to choose their printer??  Thanks much

If an end user email out an invidual worksheet from a workbook, is it
possible to tell where the worksheet came from? Basically, I think an
ex-employee turned competitor is using our excel application to make
money. I have a copy of the worksheet that the ex-employee emailed to a

I am running a macro that I wrote a year ago. I didn't make any changes. But
it dosen't work this time!
The problem is, for all the variables I haven't defined explicitly, it gave
me an error message "Can't find project or library". What's more, when I was

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Range("R2").Select
Application.CutCopyMode = False

I wrote a library of utility functions in an XLA that have been in a
particular network location for about nine years.  IS now wants to move the
XLA to a different location, which will of course break all existing uses,
since Excel embeds the path when a workbook is saved, ...

Sorry about the last post... when I submited I got an error.. and
cannot figure out how to get it out of here..
So I will try again..
I have the following macro. The section that deletes empty sheets work

I have created a userform to manage a simple database.  On the userform is an
image control which shows a (small) picture from the current record.  As I
scroll through the database, the image changes happily.  So far so good.
I have now added a click event to the image which loads ...