• 0

Save a file by macro

Asked by Wannes,

 Share

Question

Grand Master

Wannes

Posted
Posted

I would like to save my file by clicking a simple button in an macro-enabled Excel document. The file should be saved as "Date Today" "Value A1". For example: 13-12-2012 LORD HINTON.xlsx

At the moment I thought I had found it but when clicking the button nothing happens. What is wrong with my code? What do I have to change?

Thanks in advance for advising me.


Sub Button133_Click()
	Dim MyDate
	MyDate = Date
	Dim Test1Str As String
	Test1Str = Format(MyDate, "DD-MM-YYYY")
	ThisFile = Range("A1").Value
	Application.DisplayAlerts = False
	Application.Run ("SaveFile")

	ActiveWorkbook.SaveCopyAs Filename:="/Gebruikers/Naam/Dropbox/Folder1/Folder2 - Algemeen" & Test1Str & " " & ThisFile & " "
	ActiveWorkbook.Save
	Application.DisplayAlerts = True
End Sub
[/CODE]

Link to comment
https://www.neowin.net/forum/topic/1125596-save-a-file-by-macro/
Share on other sites

1 answer to this question

Recommended Posts

  • 0
Community Regular

mastermate

Posted
Posted

Has the code been assigned to the button you are clicking?

Does the code work without clicking the button?

Just to say, it does work for me, after removing the 'Application.Run("Savefileine and changing the destination folder path since these are specific to you.

This topic is now closed to further replies.
 Share
Go to question listing

  • Posts

    • Quantum computer does something for first time, creates "certified truly random" numbers

      By windowsNT · Posted

      Lottery companies can t wait for this haha
    • Here is Microsoft's 'exclusive' 50th Anniversary Windows 11 wallpaper in high resolution

      By danlu · Posted

      A Windows wallpaper as .webp? Really?
    • The official Funny Pictures thread

      By +Edouard · Posted

      What is happening in the WNBA!    
    • RapidRAW 1.3.5

      By Copernic · Posted

      RapidRAW 1.3.5 is out.
    • Microsoft Edge 139.0.3405.86

      By Copernic · Posted

      Microsoft Edge 139.0.3405.86 by Razvan Serea Microsoft Edge is a super fast and secure web browser from Microsoft. It works on almost any device, including PCs, iPhones and Androids. It keeps you safe online, protects your privacy, and lets you browse the web quickly. You can even use it on all your devices and keep your browsing history and favorites synced up. Built on the same technology as Chrome, Microsoft Edge has additional built-in features like Startup boost and Sleeping tabs, which boost your browsing experience with world class performance and speed that are optimized to work best with Windows. Microsoft Edge security and privacy features such as Microsoft Defender SmartScreen, Password Monitor, InPrivate search, and Kids Mode help keep you and your loved ones protected and secure online. Microsoft Edge has features to keep both you and your family protected. Enable content filters and access activity reports with your Microsoft Family Safety account and experience a kid-friendly web with Kids Mode. The new Microsoft Edge is now compatible with your favorite extensions, so it’s easy to personalize your browsing experience. Microsoft Edge 139.0.3405.86 changelog: Fixes Fixed an issue where MIP-protected PDF files from different sovereign cloud environments (including GCCH) failed to open and instead displayed the error message: “Need permissions. Contact the owner of the file to give you permissions.” Fixed an issue, which affected IE mode, including errors when displaying PDF files, running Java applets, and showing the Information Bar in IE mode. Improved reliability Fixed a browser crash that occurred on first launch when the BrowserSignin policy was enabled and configured to "Force (2) = Force users to sign-in to use the browser (all profiles)." Feature updates Open external links in another profile when recommended by external applications. When Microsoft Edge is set as the default browser to open external links from applications, Microsoft Edge must determine which profile to open the links. Users can control which profile to use through the “Default profile for external links” setting. Applications such as Microsoft Teams or Outlook can also recommend a profile for the links. Currently, the user setting is prioritized over application recommendations. With this feature, the application recommended profile is given priority, instead of the profile selected in the setting. Admins can control the availability of the feature using the EdgeOpenExternalLinksWithAppSpecifiedProfile policy. Note: This is a controlled feature rollout. If you don't see this feature, check back as we continue our rollout. Changes to Wallet in Microsoft Edge. Wallet is being phased out to support a streamlined experience within Microsoft Edge. This affects the Wallet feature in Settings and the Mini Wallet found by clicking the profile icon in the top banner. Users are directed to the new Passwords, Payment, and Personal Information management experience in Settings. Also, a new Password management experience is available in Settings. For more information, see Changes to Wallet in Microsoft Edge. Note: This is a controlled feature rollout. If you don't see this feature, check back as we continue our rollout. Introducing a new policy that can enable/disable Microsoft 365 Copilot Chat in Edge for Business from showing in the toolbar. Edge for Business now has a dedicated policy, Microsoft365CopilotChatIconEnabled, to enable and disable Copilot in Edge from showing in the Edge toolbar. When both this policy and HubsSidebarEnabled are configured, this policy takes precedence in determining whether Copilot appears in the toolbar. If this policy isn't configured and HubsSidebarEnabled is disabled, Copilot will remain hidden. In a future release, this policy is the sole control for managing Copilot's visibility in the toolbar. Real-time notifications for compromised passwords. Microsoft Edge is integrating an in-context password breach notification system. This feature proactively informs users if their saved login credentials have been compromised in known data breaches, enabling them to take immediate action to secure their accounts. Admins can control availability to this feature using the PasswordMonitorAllowed policy. Note: This is a controlled feature rollout. If you don't see this feature, check back as we continue our rollout. Edge Settings Improvements. Edge Settings is migrating to WebUI2 to boost page responsiveness and introducing a series of minor visual and content upgrades to improve overall usability and utility. This includes optimizing for concise wording of individual settings, simplifying the number of pages and reorganizing content, and creating a cohesive user interface. New Autofill Personal Information Settings Configuration. A web form field collection consent toggle will be available in Autofill settings (edge://settings/autofill/personalInfo). This allows users to consent to Microsoft Edge collecting web form field labels (e.g., "First Name," "Email") to improve Autofill suggestion accuracy. Only field labels are collected and not user-entered data. The web field labels are stored securely per Microsoft's privacy standards. This new setting is manageable via existing policies in Autofill (e.g., AutofillAddressEnabled), EdgeAutofillMlEnabled. AutofillAddressEnabledis the parent setting forEdgeAutofillMlEnabled. The EdgeAutofillMlEnabled policy is the parent of this new setting, thus turning off the EdgeAutofillMlEnabled policy turns off this setting. Web AI APIs for prompt and writing assistance. Microsoft Edge now implements the Writing Assistance APIs and the Prompt API (for Edge extensions) with a local language model, Phi-4-mini, that is built into the browser. These easy-to-use JavaScript APIs are made available via Edge flags (set to Enabled, by default only for the Summarizer and Prompt API for extensions) so that sites and extensions can apply AI capabilities on the web. The small language model is downloaded as the first time any of these APIs is used and later shared across all domains, serving local AI use-cases with reduced cost, network independence, and increased privacy (since data input to the model doesn't leave the user’s device). Admins can control the availability of these APIs via the GenAILocalFoundationalModelSettings policy. These APIs are currently not implemented in China. Read the announcement here, and feel free to provide feedback. Enhancements to Performance and Secure network. Browser essentials is now separated into two distinct experiences (Performance and Secure Network) - both available from the Settings and more menu (“…” on the menu bar). Reset Microsoft Edge enterprise sync. For users having problems syncing browsing data across other signed-in devices, they can reset sync data from the Microsoft servers via Edge Settings edge://settings/profiles/sync/reset. This option should only be used if the sync data is available on one of the user's devices or if they want to delete all sync data from the servers. Note: In Microsoft Edge 139, reset sync is enabled for users encountering a "No permissions" MIP error and in Microsoft Edge 140, reset sync is enabled for users encountering a "Service disabled" MIP error. Update to Microsoft AutoUpdate policy. The MAUEnabled policy allowed admins to continue using Microsoft AutoUpdate on macOS. Since Microsoft Edge now uses EdgeUpdate, the MAUEnabled policy is planned to be obsoleted in Microsoft Edge version 140. Policy updates / New policies EdgeOpenExternalLinksWithAppSpecifiedProfile - Prioritize App specified profile to open external links EnableUnsafeSwiftShader - Allow software WebGL fallback using SwiftShader MandatoryExtensionsForInPrivateNavigation - Specify extensions users must allow in order to navigate using InPrivate mode Microsoft365CopilotChatIconEnabled - Control whether Microsoft 365 Copilot Chat shows in the Microsoft Edge for Business toolbar OnSecurityEventEnterpriseConnector - Configuration policy for Microsoft Edge for Business Reporting Connectors Obsoleted policies KeyboardFocusableScrollersEnabled - Enable keyboard focusable scrollers (obsolete) SelectParserRelaxationEnabled - Controls whether the new HTML parser behavior for the SELECT element is enabled (obsolete) Download: Microsoft Edge (64-bit) | 180.0 MB (Freeware) Download: Microsoft Edge (32-bit) | 163.0 MB View: Microsoft Edge Website | Release History Get alerted to all of our Software updates on Twitter at @NeowinSoftware

  • Recent Achievements

    • Week One Done
      harveycoleman123 earned a badge
      Week One Done
    • First Post
      EzraNougat earned a badge
      First Post
    • One Month Later
      westDvina earned a badge
      One Month Later
    • Community Regular
      Bern@rd went up a rank
      Community Regular
    • Week One Done
      Joey Solo earned a badge
      Week One Done

  • Popular Contributors

    1. 1
      +primortal
      663
    2. 2
      +FloatingFatMan
      192
    3. 3
      ATLien_0
      154
    4. 4
      Xenon
      132
    5. 5
      wakjak
      98
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!