Global Variables Not Accessible

[John Baker]

Hi:

I am trying to define two global variables, thus:

Public wbpath As String
Public timesheet As String

My problem is that this set of commands isn't executing. I set the values in auto_open
macro, and these two commands are right before the auto_open macro, but the value of
wbpath isnt recognized by subsequent macros.

Where should I put them to ensure that they execute at startup of the spreadsheet?

Thanks

John Baker

 

[Colo]

Hi,

In standard module...like this.
if possible let us have your code.

Public wbpath As String

Sub Auto_open()
wbpath = "C:\Excel.xls"
'your code
End Sub

Regards,
Colo
http://www.interq.or.jp/sun/puremis/colo/CellMastersLink.htm

 

[John Baker]

The code looks like this:


Public wbpath As String
Public timesheet As String
Sub auto_open()
'
' auto_open Macro
' Macro recorded 11/25/2003 by John H Baker
'
wbpath = ActiveWorkbook.Path

timesheet = ActiveWorkbook.Name
'
Sheets("input").Select
Range("a1").Select


ChDir wbpath

End Sub

This module works fine, but others dont appear to pick up the variables.

Regards

John Baker

 

[Chip Pearson]

John,

If you edit the code after the variables are set, their values
will be reset. Perhaps this is the root of your problems.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[John Baker]

Chip:

Thanks, I think that's it.

In other words I need to close and restart after editing to make things work.

Makes sense.

Regards

John