file_name

G'Day all i am trying to loop through some worksheets and export the data into a txt file. the below code works but i need it to save the file in the specified location rather than open it. anyone able to help me out? many thanks Dave Sub CrText() Dim c00 As Variant Dim...

Hi all having an issue where i run the below code: Sub UpdateLinks() Dim Location As Variant Dim File_Name As String Application.ScreenUpdating = False Application.EnableEvents = False Call unprotect For i = 5 To WS_Admin.Range("C4").End(xlDown).Row File_Name =...

Hi Guys, I have an issue with this vba coding. So the purpose of this file is to import data from a folder of similar excel files (meaning all the excel files have the same structures and format but different values for the input data & different file name) into a single excel file. I managed...

I have written the SUB below - when I clicked [X] it is working all right - but the dialog box is appearing twice before saving. When I used the SAVE Icon - it does the same thing BUT there's a prompt that say "Excel has stop working" - when I ignore the prompt - it saves the file. I am trying...

I am trying to improve my overall coding. It took me a bit of time to get the code working properly and was wondering if there was a better way of doing what I did to handle if there is a duplicate file (goes to errtest: and keeps incrementing untill there isn't a duplicate file name.." Thanks...

Hi, I have the following VBA script that works perfectly. But it saves the file as an XLS file and I need it to save as an XLSX. I've tried just changed the "(*.xls)" to "(*.xlsx)" but that doesn't work for me. Please help! Thanks!! Sub Save_File() Dim file_name As Variant file_name =...

I need to open a folder with the name "File_Name_23Jan18" in that format.The Date changes everyday. Also, can i open the file with just the "File_Name"? Any help would do thanks.

Hello, I have a macro created to save the file but for some reason .xlsm is being included in the actual name of the file. Can anyone figure out how I can prevent that from happening...

I am trying to do some data entry which will use Excel. I'm hoping you can help me understand how to set up the system. I believe my inquiry is similar to, but not exactly like, the post at http://www.contextures.com/<wbr>xlDataVal11.html. I have a sheet like file_name | full_name 123...

I need this save as code to keep the workbook that I am working in open, and not open up the new workbook. currently it opens up the new file. I guess I essentially want to save the document as a new document, and then close it and reopen the old one. Sub SaveAsName()Dim save_as As Variant Dim...

Hi so I have this code, and it saves exactly like I want it to, but I dont want it to open itself up after it is saved, Id rather the current workbook I'm in to stay displayed. Sub SaveAsName() Dim save_as As Variant Dim file_name As String Dim ProgramName As String file_name = ProgramName...

Hi, I want to open power point using prompt option. however it is throwing run time error 429. It is working fine if i remove prompt. any help is appreciated. Sub DeleteAllPictures2() Dim ppApp As PowerPoint.Application Dim sldTemp As slide Dim lngTemp As Long Dim lngCount As...

Hi, I am trying to open power point using excel vba with the following code. it is not working. Can you please help Sub PPT_Open() File_name = Application.GetOpenFilename("Microsoft PowerPoint-Files (*.pptx*), *.pptx*") If File_name = "False" Then MsgBox "Stopping because you did not select a...