excel

[Veeru]

Hi

I am getting an error when i run this program( get data from excel from specified field), errors are 1. message filter indicated the application is busy and 2. unknown system error.

I get this errors randomly.pls give some idea

Thanks

[rsw]

Hi Veeru,

You are missing some SubVI's with the attached example but I think I can see where the errors may be happening, I'd recommend moving all the open and close functions outside of the for loop and performing the operations on the data within the for loop to allow the operation to work as quickly as possible. If you could include the missing SubVI's and an Excel spreadsheet that you are working from I can replicate it from here and advise further.

Kind Regards,

[Veeru]

Thanks Rob

I have attached the spreadsheet. sorry i dont know which subvis are missing.

[_Ian_]

The vis

Open excel and make visible

row col to range format

open new worksheet

open new  workook

are all missing.

However, give Rob's suggestion a go before uploading them all...it might save you some effort.

Ian