Hi,
What i have currently is a query that fetches a table to a sheet. I want to build a macro that exports the table to a new workbook and saves it to a custom folder.
Therefore what i need to do is:
Determine What to save (Table), this is always the same table, even though the table range varies based on the query data.
Determine Where to save and with what name (which folder), this should be a box that the user determines the place
Determine the saved format as xlsx
As i am very new, what i have so far is:
>> This however saves just a "file", not even xlsx.
Could someone help me build a saving macro with the guidance above?
Thank you!
Bookmarks