3 Questions - No Answers - Help me please

1) I need to open up some source workbook on opening my main form but would
like it hidden if possible, can't even open it yet!
2) I keep getting the following message on saving "Excel cannot complete
this task with available resources. Choose less data or close other
applications" on clicking OK i get "Unable to save external link values" I
don't want to save external link values how can i stop it doing this at all.
It still saves properly regardless so i don't see the point.
3) On close I need to sort an area of 7 columns by 500 lines by column A
with the sort regarding text as numbers, can i get that to work?

Cheers Adam, In gratitude

Adam,

Answer to question number 3:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Columns("A:G").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("A1").Select
End Sub

Regards,
Peter
"Adam Harding" <[email protected]> schreef in bericht
news:[email protected]...
> 1) I need to open up some source workbook on opening my main form but
> would
> like it hidden if possible, can't even open it yet!
> 2) I keep getting the following message on saving "Excel cannot complete
> this task with available resources. Choose less data or close other
> applications" on clicking OK i get "Unable to save external link values" I
> don't want to save external link values how can i stop it doing this at
> all.
> It still saves properly regardless so i don't see the point.
> 3) On close I need to sort an area of 7 columns by 500 lines by column A
> with the sort regarding text as numbers, can i get that to work?
>
> Cheers Adam, In gratitude