😀 Excel.CurrentWorkbook() only returns defined names (only those referring to a range) and table objects, not sheets. If you want to get...
Thank you very much! The full path is not an option for me because I don't know, where the other members save their file. Anyway thank you very ve...
Okay...sometime Excel is so annoying... here is how I fixed the problem: As I supposed, the error was created by the query from the list of the ...
Perhaps it's the query which is generated from the legay query, because the legacy query has not really a table, and is just a connection. Is there...
Hi Catalin, sorry I've posted last answer in the old topic. The legay import is not the problem. It works with autoupdate fine. Just the "imp...
thank you for your help, but at my side it looks a bit different: quotation: [Expression.Error] We couldn't find an Excel table named 'Query!Reje...
My employer hast restricted access to different datas. The legacy import is the only way for me to download the SQL data. The problem doesn't occur...
Hi Mynda, first I want to thank you for your support and by now I've watched already 3 Webinars from you on Youtube... Awesome!!! I want to than...
Thank you very much. They wouldn't change any access types ;( Anyhow I continue searching why the error occurs by switching active workbooks 🙂 Tha...
Thank you for your help. I work for an international employer and direct access to SQL-Server is restricted. That's why even the usual feature "Import...