Hi,

I am currently using Excel 2000 setting up a VBA process to load data
from a CSV file into a new worksheet. Everything was working great
until I tried to move some of my sub(routines) from ThisWorkbook to a
Module1.

I can't tell if the sub's in Module1 are running and if they are, they
are not updating my variables. I have everything declared as Public
including both my Subs and my variables so I don't think I have to pass
anything back and forth. What am I missing?

Any help would be great!!
B




---
Message posted from http://www.ExcelForum.com/

Hi BSchwerdt,

I think you have to know where is the point at issue.
First I reccomend to add "Option Explicit" at the beginning of your
code.
And run your code with [F8] key (step by step)
See the value of the variables at the Local window in VBE.

PLEASE NOTE: Public variables should be placed in a standard module,
NOT thisWorkbook module.


---
Message posted from http://www.ExcelForum.com/