Convertion
 

Hi,

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

Bach


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=400694

"bach" wrote in
message
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.

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


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=400694

bach wrote:
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

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


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=400694

bach wrote:
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

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


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=400694