Hi - am using the following querytable code to retrive data from a internet
site into excel where qurl is my webaddress.
                With DataSheet.QueryTables.Add(Connection:="URL;" & qurl,
Destination:=DataSheet.Range(qStart))

How to skip the: "Do you you want to save changes you nade to....."
notification??
(automatic " No" answer for files which are read only for all usesr)
thanks

Is there a list that can tell me which code brings up which colors? The only
ones I know for sure (based upon other code that I've seen are the following):
3    'red
6    'yellow

I have a listbox with 20 columns per row, what code would I need to select a
cell, every time I click on members name in the list box I would like it to
choose the activeCell on the sheet ("Members") the cell would always be in
Column "I" i.e.

I don't know if this is doable but I would like to use an Excel chart to
display in a component on a Windows form. I'm using VS 2005. Is there a
technique to do this?

Have been using excel spreadsheet for 2 years,now suddenly I get the
message "Can't find projects or libraries" programs were written in
Excel97 now using Excel2000. Can anyone shed some light. TIA

I currently use an old macro program (.xlm) to extract the closing prices
and their volumes for a list of 20 stock codes from the daily market price
list which has thousands of stock codes. I am trying to re-write the same
program using VBA which I am beginning to learn and ...

I have designed a complex Excel spreadsheet app in which I am not the end
user that uses heavy vba including a calendar control. It was designed with
Excel 2003 and will be used on PCs with Excel 2003 and XP. I demonstrated the
app on a PC in which everything worked fine, however ...

I'm trying to use the GetSaveAsFilename to grab the filename to use
with SaveAs. However, I keep getting the following error:
Run-time error '1004':
Method 'GetSaveAsFilename' of object '_Application' failed

How can I refer to a workbook in a macro if the name of the workbook
changes over time?  The workbook contains most of the data I use to
create new workbooks, however its name is changed to reflect the
version (date) of the data it contains.  If I refer to the name in the

Hi, Can someonr help me with the following?
It's variable mCol.  I'm after the background color of the cell
(which isn't .Font.Background).
Thanks - Kirk

I have a few macros which perform the same tasks.  How can I measure
their speed of execution (start to finish), so I can only use the
fastest and delete the others.  Also, would this be a good method of
identifying how efficient a macro is i.e using different looping

I have a worksheet with following coloumns:-
C2                          D2                                F2
Movement              Start Time                   End Time
No Movement          07:45:12                     9:12:45

Sorry that I could not even name this problem properly.
Please see tables below. The requirement will be quite obvious. Know
how to do this manually but not sure programmatically.
Thanks for the help.

Hello developers!
I have a workbook with 8 different sheets and the macro below allow the
user to restore earlier backup csv-files. My question is:
Can the backup be stopped if the file don't have the right name? What am