Open Spreadsheet

[Dickx]

How to open an Excel spreadsheet to a specific worksheet and cell address.

 

[xlbo]

save it on a specific worksheet and cell address

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question

 

[TheLad]

Rather than explaining it, I would suggest that you record a macro of you doing exactly that manually, then you can view the code for yourself.

-----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------

 

[DPlank]

Put the following code in the workbook_open event

Private Sub Workbook_Open()
Worksheets("YourSheetHere").Range("YourCellHere").Activate
End Sub

To put this code in place, press Alt+F11 to open the VBA editor, right click on the ThisWorkbook and select Edit Code. From the options at the top left of the right hand pane, select Workbook. Put the code above in this space.

Save file.



Cheers,
Dave

Probably the only Test Analyst on Tek-Tips

animadverto vos in Abyssus!

Take a look at Forum1393 & sign up if you'd like