macro notice

[max_max]

Hi to all.
This macro in a network path, create 4 tables from a database:

Please Login or Register  to view this content.

it is possible that after the creation in active sheet:
in B4 an alert appears:
tables present if present
tables not present if not present
in C4 an alert appears:
table SK1
table SK2
table SK3
table SK4
thanks in advance.
max_max

[Keebellah]

Hi max_max,
Sure, I would suggest that you do the import table table as Function and that returns a True or False if the table was created/imported correctly.
Add a count ind if the count is equal to the tables then it's all true and you place the message in the cell saying that the tables were all created or not.

[max_max]

Very difficult for me
max_max

[Keebellah]

What is so difficult? You already have the macro

Check the text in RED

Please Login or Register  to view this content.

[max_max]

Hi Keebellah
Thanks for the change, I can not try the macro only tomorrow at the office.
For the notice in the cell, that's okay?

Please Login or Register  to view this content.

max_max

[Keebellah]

No problem we'll hear it tomorrow.

But you must learn to simplify your code do not add unnecessary lines

Please Login or Register  to view this content.

[max_max]

to try here at home in the counter I added your change to another macro.
It gives error here:

If Workbooks Is present Then contare = contare + 1

undefined variable.
max

Please Login or Register  to view this content.

[max_max]

Dim Increase As Variant

Dim contare As Integer

Dim present As Object


No error but no advise

max_max

[Keebellah]

Sorry, I hoped you had a little more imagination.
This is TEXT you have to enter the paramateters you use to check if the

I do not know what the cells are and so
If your text and fomula or code to check if true = True Then contare = contare +1

[max_max]

So I find out that they are present, without dim present as object

Please Login or Register  to view this content.

[Keebellah]

I was just giving a tip, you found the right solution.
Great.
See, it's not that difficult after all

[max_max]

A greeting.
max_max