I apoligize for having not read the entire thread, but I did notice that you
were inquiring how to create another instance of Excel, and I can answer
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
'Minimize this instance of Excel
Application.WindowState = xlMinimized
'Create new instance
Set xlApp = CreateObject("Excel.Application")
'Make it visible
xlApp.Visible = True
'Add a new workbook
Set xlBook = xlApp.Workbooks.Add
Hope that helps... I'll try to read the rest of your original post and get
back to you when I get a moment...
From: A list to stimulate discussion about the technical aspects of the
developme [mailto:[log in to unmask]]On Behalf Of Gafford,
Sent: Monday, March 19, 2001 11:46 AM
To: [log in to unmask]
Subject: FW: Pasting data from hidden worksheet
> -----Original Message-----
> From: Gafford, William L
> Sent: Monday, March 19, 2001 12:44 PM
> To: 'A list to stimulate discussion about the technical aspects of the
> Subject: RE: Pasting data from hidden worksheet
> Richard, how do I launch a new instance of Excel (not just create a new
> workbook). Currently when the user hits the "COPY DATA" button, the data
> conversion is performed, the data copied, and the application minimized so
> the user can start a new instance of Excel or start Word or wherever they
> want to paste the data.
> I could paste the data for them as you're proposing if I know how to
> start a new instance of Excel. The applications I develope don't look much
> like Excel (all toolbars, built-in menu's hidden, almost non-user input
> data protected), so I need to launch the new Excel application to give the
> user access to Excels tools. Often they'll mail out the copy of the
> worksheet to others.
> The code would be something like
> With Worksheets("CopySheet")
> End With
> Application.WindowState = xlMinimized
> .. launch new Excel instance
> .. paste data into new Excel instance
> .. hide "copysheet" in old Excel instance
> I'm not sure how to handle the ".." steps. I've tried setting the
> Workbook deactivate and activate events to trigger code to hide the
> copysheet, but those events don't trigger when the Application is
> minimized and then maximized. If anyone knows what event in Excel is
> triggered when the application is minimized and maximized, I think I could
> get the job done using those.
> Thanks for your suggestion!
> -----Original Message-----
> From: Richard Gates [SMTP:[log in to unmask]]
> Sent: Monday, March 19, 2001 12:19 PM
> To: [log in to unmask]
> Subject: Re: Pasting data from hidden worksheet
> Why not save the visible status of the copy sheet as a variable, set the
> visibility to true, perform your routine so you are copying visible sheet
> data, and, reset the original visibility after the copy.
> bSaveVisible = Worksheets("SheetWithData").Visible
> .. perform copy and strip..
> Just a suggestion.
> Richard Gates
> ----- Original Message -----
> From: Gafford, William L <[log in to unmask]>
> To: <[log in to unmask]>
> Sent: Tuesday, March 20, 2001 5:08 AM
> Subject: Pasting data from hidden worksheet
> > I've developed an Excel application for retrieving and viewing lab
> > from an oracle database at our plant. The data is retrieved from oracle
> > text (may be non-numerical results), and numerical data may include
> > characters indicating pass/fail status, target status, etc. Plant
> > want to be able to copy and paste the data as numbers in another excel
> > spreadsheet, so I have a conversion routine that copies the data to
> > sheet, strips any characters at the front or back, converts text values
> > number values, and then copies the data from the sheet for the user to
> > paste.
> > I'd like to keep this copy sheet hidden, but when I paste the data
> > another instance of Excel it hides the sheet. I tried turning screen
> > updating off, copying the data, then hiding the sheet, but if the sheet
> > hidden when the user pastes the data the sheet he pastes into is always
> > hidden. Even worse, if the user pastes in sheet 1, goes to sheet to,
> > hits the backtab to sheet 1, good ole Dr. Watson comes a knockin'.
> > Any suggestions as to how to handle this situation would be greatly
> > appreciated.
> > Bill