Convertion

[bach]

Hi,

I need to convert an excel 95 spreadsheet to excel 2003. got any tips,
guidence etc.

Bach

 

[Gordon]

Hi,

I need to convert an excel 95 spreadsheet to excel 2003. got any
tips, guidence etc.

Bach

You don't need to "convert" it, just open it in Excel 2003.

 

[bach]

Thanks,

My mistake, wrong information passed to me. What I need is a MS Quer
Addin. I have looked around the spreadsheet uses this to connect to
database.

In excel 2003, there is no MS Query Addin in the Addin list, anyon
know where i can get this add in from search on ms no joy.

Bac

 

[Gordon]

Thanks,

My mistake, wrong information passed to me. What I need is a MS Query
Addin. I have looked around the spreadsheet uses this to connect to a
database.

In excel 2003, there is no MS Query Addin in the Addin list, anyone
know where i can get this add in from search on ms no joy.

Bach

I think you're right, there is no add-in - it's built in as a default.
Try going to Data-Import External Data and you have the option to either
set up a new quewry or use an existing one.

HTH

 

[bach]

Thanks for your reply,

The 'Querygetdata' is being called from within VBA with a SQL string
assigned with it. I need this to stay just update the querygetdata
with what ever is used within Excel 2003


Bach

 

[Gordon]

Thanks for your reply,

The 'Querygetdata' is being called from within VBA with a SQL string
assigned with it. I need this to stay just update the querygetdata
with what ever is used within Excel 2003


Bach

Sorry, I have no VBA at all so can't help you!

Cheers

 

[bach]

Guys I have an old excel spreadsheet which we need to run in excel 2003.
The spreadsheet was created using version 95.

The VBA code that I have having issues with is this one.


Code:
--------------------

Application.Run "QueryGetData", "", _
"SELECT tablename.tablefield" _
, , , , , False

--------------------


The issue is with the QueryGetData, this from what I have ascertained
is an old function within excel. It was used to query a database and
retrieve information.

I was wondering if there was a replacement function in excel 2003.

Bach