Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-27-2016, 10:34 AM
IAMCHEESE IAMCHEESE is offline Save Excel file with specific cell value by using VBA code Windows 10 Save Excel file with specific cell value by using VBA code Office 2016
Novice
Save Excel file with specific cell value by using VBA code
 
Join Date: Oct 2016
Posts: 1
IAMCHEESE is on a distinguished road
Default Save Excel file with specific cell value by using VBA code


Help!! I am trying to finish a new tool to use in our shop and I have a couple of steps I can't figure out......

1) I would like to create a macro that will save a file using the contents of a specific cell (customers name) as the file name. I found this script that works, but I can't figure out how to execute the command!

VBA code: Save Excel file with specific cell value

Private Sub filename_cellvalue()
'Update 20141112
Dim Path As String
Dim filename As String
Path = "C:\Users\dt\Desktop\my information\"
filename = Range("A1")
ActiveWorkbook.SaveAs filename:=Path & filename & ".xls", FileFormat:=xlNormal
End Sub

and

2) I would like to record a macro that exports the .xlsm file into a .pdf, so I can send it to the customer in that format, not an excel file.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Save Excel file with specific cell value by using VBA code Save as File for Excel 2010 mbesspiata Excel Programming 2 02-03-2016 07:10 AM
Save Excel file with specific cell value by using VBA code Save as File for Excel 2010 mbesspiata Excel 1 11-18-2015 08:52 AM
Save Excel file with specific cell value by using VBA code Code for mail merge to reference saved excel file jtemp57 Word VBA 10 12-16-2013 11:02 PM
Save Excel file with specific cell value by using VBA code VB code: populate combobox from columns in Excel file billybeach Outlook 2 04-27-2013 04:38 AM
Insert an item to excel specific cell apjneeraj Excel 0 01-18-2011 03:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft