Convertion

  • Thread starter Thread starter bach
  • Start date Start date
B

bach

Hi,

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

Bach
 
bach said:
Hi,

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

Bach
Click to expand...

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 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
 
bach said:
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
Click to expand...

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 said:
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
Click to expand...

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
 
Back
Top