.xlsx

i have a data which is in xlsm. by clicking command button i want to save it as a new .xlsx file macros should not save on .xlsx file

Hey all, Having a small issue with my vba code. The code is supposed to throw up a bunch of prompts to confirm saving and then clears out the forms and vba codes and then is supposed to open the new file and then closes the application. However, no matter where I put the Workbooks.open line...

Hello guys, I am new to this forum. Thanks to everyone who is making a contribution, and sharing their knowledge. I have a whole network of Excel files linked between themselves. At the beginning of every month, I am making copies of each file, reflecting the month and year in the name of each...

I have about 10-15 CSV files stored on a network folder that I want to combine. When I try to do so it is throwing this error DataFormat.Error: There were more columns in the result than expected. Details: Count=7 I believe this is because there are now commas on the csv file. The...

In my script below it saves each tab in Excel as a separate worksheet and titles the file the same as the tab name. Is there a way to make it save as an .xlsx ***e unstead of a .xls file? Thanks in advance! Dim wks As Worksheet Dim newWks As Worksheet For Each wks In...

Hello Everyone, I need some help with a macro that I am working on. I use the Macro within one workbook to open up to 33 other workbooks, copy information and paste it into the initial workbook. The problem has come up that within the 33 workbooks, some are saved as .xls and others are saved as...

I have a macro enabled document (.xlsm) that I want to save as a standard macro-free document (.xlsx). I am able to do it but it creates a popup asking me if I want to do it and lose the macros. Is there a way to avoid the popup and have it just save the document without the macros...