How to position to a specific sheet before saving

  • Thread starter Thread starter Pete Kipe
  • Start date Start date
P

Pete Kipe

I'm creating an Excel workbook from VB6 that contains exported SQL Server
data. The workbook can contain more than one sheet - when I'm ready to save
it, how can I reposition to the first sheet? I've tried the following code,
but when re-opening the workbook it opens to the last sheet created:

Set oSheet = oWB.Worksheets(1)
oWB.SaveAs (msExcelPath & msExcelFileName)

Any help would be appreciated. Thanks!
 
Try...

Set oSheet = oWB.Worksheets(1)
oSheet.Select
oWB.SaveAs (msExcelPath & msExcelFileName)
 
Many thanks, Jim. Works perfectly now. Pete

Jim Thomlinson said:
Try...

Set oSheet = oWB.Worksheets(1)
oSheet.Select
oWB.SaveAs (msExcelPath & msExcelFileName)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Sheet Values to new workbook 20
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
How to move worksheet into specific position? 3
save worksheet data to alternate closed workbook - next row 1
How to prevent a graph update 2
Save specific sheets to new workbooks adding tomorrow's date to na 1
Save only changes in a specific sheet, leave other sheets alone 2
saving 3 worksheets in a workbook to a separte workbook 6

Back
Top