Hi Ken, I have been using findlink.xla!!! but thanks for the tip, I can't delete the Modules or the VBA as I am using both in my workbook....
Hi Gavona, How do I find this very hidden worksheet? I can find the named ranges OK but there still seems to be this worksheet hidden somewhere because...
Ok all you experts out there - I need help!!
I have a workbook saved as a template (.xlt) file which has been linked to another .xls file using the Template Wizard and Data Tracking.
I want to remove the link and stop using the Data Tracking but can't find out how to do this.
I've already...
Excel created the Database file as part of the Template Wizard process so if it 'forgot' to create a table for itself...
Is there some sort of 'make table' process I need to go through?
(When using Excel lists in the past I have never had do to anything to them.)
Nikki
I have made a template using the Template Wizard function and have exported some data to an associated Excel List (stored as a .xls file). Now when I try to use Data\Get External Data to retrieve the data and run a query I get a message along the lines of 'Database has no tables'. I have tried...
I have a form in which Users type/select the criteria for a report. There is a Preview cmd button on the form which generates a SQL string based on the User's selections and opens a recordset.
The recordset is opening and returning the correct data.
HOWEVER, I can't find a way to then open the...
Thanks
it works but doesn't seem very elegant compared to what I would normally do in VB which is to use AddItem to add something to the combo box without affecting the database.
I have a combo box on a form which currently displays a list of values queried from a table.
I want the user to EITHER leave the field blank OR select from the list.
Unfortunately, once they have selected something from the list there is no way for them to set the field back to blank. I would...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.