Start macro "on load all information"

[sjoerd.jump]

I made a macro that uses input from an import file.
but i need to use the same file to run the macro.

this is what happends.

I use an application, then export the data.
When i use an On load or on open function, the macro runs before all
data is exported, thus leaving me with an incomplete worksheet.

Is it possible to wait till all info is imported in the worksheet
(say, fixel) to run a macro on another sheet (say, fixel_overview)

 

[JW]

Don't have a whole lot of info to go on, but try placing DoEvents at
the top of the code. Worth a shot.

 

[sjoerd.jump]

Don't have a whole lot of info to go on, but try placing DoEvents at
the top of the code. Worth a shot.








- Tekst uit oorspronkelijk bericht weergeven -

Hmm, the trouble is is that the code is executed before all the data
is loaded into the fixel sheet.

See it like this...

1 - I got an application with x y and z information from products.
2 - I export the information to excel using the export function
3 - When all information is loaded i want to execute my code to sort,
count and lookup all the information that i want.

at this moment, the code is executed before all the information is
loaded

cheerd!