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

3 Questions - No Answers - Help me please
 

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" schreef in bericht
...
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