Start macro "on load all information"
 

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)

Start macro "on load all information"
 

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

wrote:
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)

Start macro "on load all information"
 

On 27 aug, 16:35, JW wrote:
Don't have a whole lot of info to go on, but try placing DoEvents at
the top of the code. Worth a shot.



wrote:
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)- Tekst uit oorspronkelijk bericht niet weergeven -

- 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!