o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Creating an Excel spreadsheet from Access -

I'm not necessarily looking for code here, so if this board is for code only, I apologize.

Basically my question is on the portability of VBA between MS products. I've got an Access 2000 database, and I'd like to take the information from a query or table (haven't decided yet) and automatically generate an Excel spreadsheet based on that information. The spreadsheet would need to be formatted a specific way, and this would all be done automatically. Is this possible?

 

Creating an Excel spreadsheet from Access -
I'm not necessarily looking for code here, so if this board is for code only, I apologize. Basically my question is on the portability of VBA between MS products. I've got an Access 2000 database, and I'd like to take the information from a query or table (haven't decided yet) and

Populating An Excel Spreadsheet From An ASP Page -
I have a desktop application that, based on a query to an Oracle database, populates an Excel Spreadsheet. All of this works fine, is deployed, and has been in use for several months. Now, I've been tasked with transforming this application into a Web page that will be run off of

Strange excel occurrence. -
Hi Everyone, I currently have an vb program that is pulling information from an Access database and then writing that information to an excel spreadsheet. The excel spreadsheet is then being saved and closed. One problem I keep running into that I am not sure how to fix is the fac

Extracting url from excel spreadsheet -
Hi All, I am creating an automation script and have need some assistance please. Is it possible to extract a url from an excel spreadsheet and have it opened in the brower using VB6. (I will the do some basic rendering checks) then automatically move to the next url in the spre

Create an excel spreadsheet -
hi pirate.. creating new access database... that was cool.. is there anything like that.. for creating a new excel sheet... and also to delete that file .. when i close my vb application.. if ther any.. pls help me with code.. Thanks

Importing excel Spreadsheet -
Hello everyone, I need some expert advise about importing excel data into an Access Database. It goes like this, In my visual basic project I added an export to excel routine. The users can filter the records they want to export. Now after exporting the user can update the spreadsh

Creating Excel -
OK Who can help me with creating graphs from Excel in VB?? OR even better yet sending data from Recordsets to a spreadsheet in Excel then creating a graph from that data?? If you can help me with this you have done a great deed for the day.

Excel features via VBS -
Hi all, I created a vbscript that generates an excel spreadsheet based on information in a database. Now I'd like to add a header and footer to that excel spreadsheet as well as define all the page set up information for printing the spreadsheet before the script saves the spread

excel to access issue -
How can i rotate a spreadsheet in excel so i import it into access. The spreadsheet has the headings in the rows not in the columns. So i need to rotate the sheet to have column headings??? Is there an easy way of doing this in excel or access?

Excel to Access -
Hi, I am working on a project with VB 5 that has and existing "database" in the form of an Excel spreadsheet. Can anyone tell me how to transfer data stored in an Excel spreadsheet into an Access database? Thanks in advance.

Export to Spreadsheet, w/o Excel -
I see a few tutorials pertaining to exporting data into an Excel spreadsheet. Looks straightforward, however I do not own Excel. I use Open Office (hey, it's free). I'm able to open Excel spreadsheet within Open Office Calc. However when I write my code, and I goto reference Excel,

Code for updating cells in an Excel spreadsheet -
Hi all Anyone throw me a snippet or link to some code that examples populating cells in an Excel spreadsheet? I have (or will have) a template spreadsheet that will be filled programmatically from within Access 2000 ... Just wanted a little primer on do it ... Thanks. - Mike

Problem Killing excel Object...Used to be Access and Excel VBA intermingling -
Hey everyone, I got this button in access that exports data to a existing excel spreadsheet on my desktop. After it does this I need to run a macro to format the newly exported data. I was wondering if I could perhaps refine this process so that after I push the button in access it

Accessing Excel spreadsheet using DAO -
I am wanting to access data in an Excel spreadsheet using DAO, jsut like an Access database. I have the following code written to open the Excel sheet: Dim xl as DAO.Database Set xl = OpenDatabase(path, False, True, "Excel 8.0;") However, when I execute the code I get

Working with Excel Spreadsheet (*Resolved*No Excel Solution) -
I haven't done any of this before, so I'm a bit stuck. I need to create a small app that will allow the user to enter an item number, click find, and display the recordset to the user on a form. The info is stored in an excel spreadsheet. I would have done it using Access, but the

Creating Excel Spreadsheets and Graphs -
OK Who can help me with creating graphs from Excel in VB?? OR even better yet sending data from Recordsets to a spreadsheet in Excel then creating a graph from that data?? If you can help me with this you are goooood.

Importing an excel spreadsheet into Access using VB -
If I have the path to an excel spreadsheet is there a way I can import this file into an existing table in Access OR create a new table with the data. Is there a DLL in the Windows API or can I hook up to the import wizard in Access????

Importing Excel Spreadsheet into Access using VB -
If I have the path to an excel spreadsheet is there a way I can import this file into an existing table in Access OR create a new table with the data. Is there a DLL in the Windows API or can I hook up to the import wizard in Access????

Open Excel Spreadsheet as database -
I have some data that i need to look up in tables and translate that data onto an excel spreadsheet. The data that has to be looked up is also on an excel spreadsheet. I've been working on a Visual basic program to do this, but can't find a way to open an Excel spreadsheet (in co

[2005] Cut and paste in Excel -
Hi Folks, I am creating a tool which converts Excel spreadsheets to .csv format. I am building it in VB.net. The user enters a 5-digit job number in a textbox, then clicks "Execute." The file opens an instance of Excel, opens a spreadsheet. It then calls an Excel macr

Access Export To Excel via Insert Row -
I have an order tracking database I have been developing in Access, however I need to export Order Details to an Excel spreadsheet already developed. Is there not a simple line of code to insert a blank row (say row 15) in the Excel Spreadsheet during the Access Export?

Opening an Access Form from an Excel spreadsheet [resolved] -
I would like to be able to open an Access form (preferably without visiblely loading the whole database in MS Access) by clicking a command button on an Excel spreadsheet. Is this possible? I am proficient in VB and am currently scanning the net for answers. I will stick a [re

Transferring records in Excel to Access -
Is it possible to just copy existing record entries from an Excel spreadsheet file into an MS Access table? Assuming that the fields in Excel and Access correspond to each other, is it possible ot just transfer records from Excel all at a time without having to re-enter the records on

displaying results from excel to VB..help! -
Hi, I am designing an interface using VB to display the results from an Excel spreadsheet. I wish to know if it's possible to display results in 'table' form, as when it retrieves from the MS Access. Do I use Flexgrid or other components? I do not wish to display the whole Excel

Excel Sheet Into VB6 -
Is it possible to open an Excel spreadsheet from VB6 and extract certain fields from that spread sheet. We want to send, by e mail, to all our customers a spreadsheet which contains all their unique particulars, name address etc. if anything has changed they make the changes in the sp

importing external files from excel into access -
I have an excel spreadsheet which I am linking too through code in my vb application. Heres how I link: Set xlsdatabase = OpenDatabase("d:\paul_samson\pqrdatabase.mdb") Set tdfLinked = xlsdatabase.CreateTableDef("linkedtable", 0, "HR_12_00" & "

trying to write to an Open Excel spreadsheet -
Hi all. In my VB project, I've managed to capture a recordset from a SQL query and export it to Excel, opening a new Excel workbook on the fly. I've discovered Excel macros and it has made life wonderful for this project. My problem is that I have a loop created, which grabs new na

How 2 process current data From open Excel SS -
I am a programmer but never really programmed anything in VB6 or Excel but now I have a project that has to be done from an excel spreadsheet via a button or macro. From an open excel spreadsheet with data I need to call a VB processing program with at least two parameters, a data

A quirk in Importing Excel Spreadsheets -
When I run a macro that imports an Excel spreadsheet into an existing Access Table, it appends the data fine. The only problem is, the first couple of records are out of order. I tested it by putting a different date on each row in the spreadsheet. When I imported it into Access, the f

Modifying Excel data using Data Control Object -
This is a re-post of a previous message with a new wrinkle. I am creating a form filled with text boxes. These text boxes will contain values that are also cell values of an Excel spreadsheet. I have included a Data Control object on the form that points to the Excel spreadsheet. Ea

OWC Spreadsheet Control -
Hi I am unable to freeze the size of the spreadsheet component in Excel. I am using the OWC Spreadsheet control to display some data. Whenever I open the Excel application the size of the OWC Spreadsheet is increasing(both width and Height). Please help.

Unhiding an Excel Spreadsheet -
I am updating an Excel Spreadsheet with VB6. After all action is taken I save and close the Spreadsheet with the following code: xl2.Application.Workbooks(2).Worksheets("schedule start").Activate xl2.Application.WindowState = xlMaximized 'xlMinimized xl2.Applic

Specific cell in excel to specific cell in access dbase -
Hi, I'm new to the the forum and fairly new to access and VBA, so please excuse any ignorance. What I have is an access database that I update by going into excel spreadsheets and just copying data manually into a form in access and it updates the table. Each row in the table cor

Detecting last data row in Excel.Workbook Object -
I am reading in data from an Excel Workbook into an Access Database in Access. How can I detect what is the last filled row of the Spreadsheet? For example if the spreadsheet only has two rows populated, how can I stop the code from running down all 65000 rows?

Sizing an excel spreadsheet in VB -
Hi, I was able to put an excel spreadsheet in VB using OLE. The only problem is is that the data is being cutoff in VB. How do I make it to where it looks exactly like the spreadsheet in excel. All I use right now is OLE1.SourceDoc OLE1.Action I am new to this so any hel

VBA in MS Access needs Excel reference -
So I wrote some code in Access VBA to build a spreadsheet. It obviously needs a refernce added for MS Excel. The problem is when I give this to someone who doesn't have the same version of Excel it doesn't seem to work. Is there anyway aroundd this?

Spreadsheet XP Web Component Questions -
Hi, I am using the Spreadsheet - XP Web Components object in my VB application and have a few questions about it. - Is it possible to save the data the user enters into the spreadsheet so that it is there when they open the program in future? - When spreadsheet data is export

Microsoft Spreadsheet Control in Excel -
Hi I am using an Microsoft Spreadsheet cotrol 11.0 (OWC Spreadsheet) in an Excel application. I want to Wrap text in the spread sheet control and also apply filter, not the one which the component by default provides. But I want to apply the Normal filter what we have for Excel

Using VBA to directly upload the data Excel spreadsheet to MS Access -
I have a question regarding about MS Access database and VBA. I would like to build in a command button that would do the work for me in the way that I would push the data from EXCEL spreadsheet directly to the database. I know that I can do that by using VBA. Please give me some in

i got excel 2002 (office XP): how can i save a spreadsheet so... -
access 97 can open it ? with access i reference DAO 2.5/3.51 instead 3.6 and when opening with 2000 or xp, it asks me if i want to convert. but for excel, i have only one choice: Excel 10 library. any ideas ? thank you