Need help in saving files multiple time together from an excel tool

Hello Experts,

I am new to VBA/MACRO as well as to this Forum. Need your help in resolving one of my issue in Excel VBA.

We have Excel tool(TICKLE) from my company which is made of 1000s of MACROs and 100s of files and is extremely slow because of being such a heavy tool. We use this tool many times for multiple Scenarios to calculate multiple things. So as this tool is very slow I have made another tool which runs TICKLE multiple times automatically with different inputs which is running pretty good. TICKLE tool has one macro which is used to collect all the relevant info from all the files and export this to single file which can be imported later for usage. To save this file it prompts and asks for location and filename to save it.
So when I run my new tool to run TICKLE multiple times, it everytime asks for location and filename which stop my continuous running tool. Below is the syntex to export/save this file:

Please Login or Register  to view this content.

Now, My question is, how we can modify above syntax to stop this prompt to ask for location and filename? I want this MACRO to take location and filename from the specified location and save it without prompting anything and If i run it 10 times in a single go, It should save 10 files at the specified location.

Thanks in advance.

Hi, and welcome to the forum.

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

That said, don't use the GetSaveAsFilename, just use the ActiveWorkbook.SaveAs FileName:="whatever"

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Replace that code with just this...

Please Login or Register  to view this content.

This presumes the file name in that cell changes each time you run the code.

Originally Posted by Ashwani05

Hi AlphaFrog,
Your syntax is only for assigning the name to the file.. correct? not for saving the file.

Yes, syntax is only for assigning the name to the file.