I am not sure...

What version of Excel is on your developers PC?

What version of Excel is on the PC(s) you are having an issue with?

Mark

"Leanne" wrote in message
...
Hi Mark,

I did not have these checked on my development computer. What difference
there is between excel is 2000 & 2003 version. I do not know what the
other
users will have but would guess they will be the same or newer versions.


"Mark Ivey" wrote:

Is there anything different about their version of Excel?

Did they get a full install?

You may need to get out the Installation CD and see if there were any
features overlooked during install that may be causing a problem with
this
issue...

One more thought... do you have both the basic Addins checked (Analysis
Toolpack, and the Analysis Toolpack - VBA)? Reaching, but it may help...

Mark Ivey

"Leanne" wrote in message
...
I have tried this but I am not to sure how to change the file path.
When
the
first box comes up in edit it lets me chose the new location but then
after
entering the dates it gives me the following messsage [Microsoft][ODBC
Excel
Driver] and then the file path is an invalid path but will not let me
do
anything more. Either that or I get a runtime error!

Please help


"Leanne" wrote:

Hi All,

Thank you all for your comments. I was hoping to make this file plug
and
play but I guess that will not be the case and I will have to install
it
on
each computer myself - the users will not get it right! If only they
were
networked..............



"Leanne" wrote:

Hi,

I have the following code to refresh a query and it works fine until
I
install the file on another PC.

Private Sub CommandButton1_Click()
Sheets("Invoice Due").Activate
Range("A7").QueryTable.Refresh BackgroundQuery:=False
MsgBox "Refresh complete"
End Sub

It shows it failing on line
Range("A7").QueryTable.Refresh BackgroundQuery:=False

Can any one help?