Export data to Excel Template

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Nov 2006
Posts: 1
Reputation: hamerw is an unknown quantity at this point 
Solved Threads: 0
hamerw hamerw is offline Offline
Newbie Poster

Export data to Excel Template

 
0
  #1
Nov 16th, 2006
Hello

I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden.

Does anyone know why and how to stop this from happening.

thx
Wayne
Reply With Quote Quick reply to this message  
Join Date: Dec 2006
Posts: 1
Reputation: gourav_ajmani is an unknown quantity at this point 
Solved Threads: 0
gourav_ajmani gourav_ajmani is offline Offline
Newbie Poster

Re: Export data to Excel Template

 
0
  #2
Dec 1st, 2006
Originally Posted by hamerw View Post
Hello

I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden.

Does anyone know why and how to stop this from happening.

thx
Wayne

HI can u plz provide me with the code for exporting the data to excel from jsp.

I have a jsp page I am setting the data from bean in jsp ,n i have a button there on which if i click it shoud display the o/p in excel..


regards
Gourav
Reply With Quote Quick reply to this message  
Join Date: Mar 2007
Posts: 4
Reputation: Rupeshba is an unknown quantity at this point 
Solved Threads: 0
Rupeshba Rupeshba is offline Offline
Newbie Poster

Re: Export data to Excel Template

 
0
  #3
Mar 31st, 2007
Originally Posted by hamerw View Post
Hello

I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden.

Does anyone know why and how to stop this from happening.

thx
Wayne

Hi...

have u use macro for that

goto macro
Action:OutputTo
Object Type:Table/Query/Report/.......
Object Name: Table Name/Query Name/Report Name......
OutPut Format: *.xls/*.doc/*.rtf/..
OutPut File: c:\.... ' Path were u want to store that file
Auto Start: Yes


Save that Macro

GoTo Forms
Make Button and call that Macro

IT will automatically transfer the file to there

*********************

if ur excel file is hide than
Windows 'Menu Bar
Unhide File


if ur facing problem again then
mail me

bye...
Rupesh
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:




Views: 12296 | Replies: 2
Thread Tools Search this Thread



Tag cloud for MS Access and FileMaker Pro
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC