save workbook no queries or formulas

[rjmdc]

i have a workbook created of worksheets with tables created by queries
i want to save the workbook no queries no formulas just the worksheets with the tables
what do i do
i tried so many ties and keep failing

 

[bferraz]

You can save it as .CSV file

 

[rjmdc]

i need to copy the book as is and remove the queries

 

[bferraz]

If you save your workbook as a .csv file or .xls for example. It will remove all queries because those aren't supported. Your records will be stored as values but make sure you have a backup first.
Otherwise the other solution I see is using a VBA code to copy all cells and paste in another workbook as value.

 

[rjmdc]

can anyone assist
copy workbook as xlsx remove all queries and connections

 

[Joe4]

If you save your workbook as a .csv file or .xls for example. It will remove all queries because those aren't supported. Your records will be stored as values but make sure you have a backup first.
Otherwise the other solution I see is using a VBA code to copy all cells and paste in another workbook as value.

That won't work if it has multiple worksheets (as the original question implies), as a CSV can only save a single worksheet (since it is a flat file).

I would probably try creating VBA code to loop through all sheets and do a Copy --> Paste Special Values on each entire sheet, and then save the file.

 

[rjmdc]

what would be the correct code?

 

[Joe4]

what would be the correct code?

That depends. You mentioned saving as an "xlsx".
If you want that, then the VBA code would have to be in a different workbook, as "xlsx" files cannot contain VBA code.
If you want the VBA code in the same file, then it must be saved as an "xlsm" or "xlsb".
So which option do you want?

If you want the VBA code in another file (or your Personal Macro Workbook), how would you like it to identify which file to apply the code to?
Will the file already be open, or do you want a prompt to select it?

 

[rjmdc]

hi
i want an xlsx
no formulas
no queries workbook
just all the worksheets with tables
i cannot figure it out

 

[Joe4]

If you want my help, please answer ALL the questions from my previous post.
Also, when you say "Queries", what exactly do you mean? Querying from where/what?
Are you using Power Query?