VBA To Check Version Of Created XLSM File?
Jun 21, 2013
I'm creating a template xlsm file that has built in marcos. This file will be used by the Engineer as a template, where they fill in the data, and then send it to the team. when the case in finished, they will use clear data macro.
The Problem I want the template to have a macro runs with startup of the file that checks for the lastest template in a network folder (shared folder where they will have read only access). If the used file is the latest one, OK. If not, give a custom msg with the location on the network.
View 6 Replies
ADVERTISEMENT
Jul 21, 2009
The other day, I had posted a macro, which copies one of the sheets from a workbook, on to a blank sheet, and then saves it with a name obtained from the value of cell E7. I required certain modifications to it, before I could implement it.
You will find it here and the code looks like this:
View 10 Replies
View Related
Sep 7, 2007
I am running Excel 97 on one PC and 2003 on another, both need access to a workbook and both need to amend that workbook.
In my Macros I have a line in the Workbook to save etc
Workbooks("WB Name").Close SaveChanges:=True
When I run the macro on the 97 PC I get a message stating that the "file was created with a newer version of Excel Continue with save Y/N"
I have tried
Application.DisplayAlerts = False
Workbooks("WB Name").Close SaveChanges:=True
Application.DisplayAlerts = True
but the file does not save.
View 4 Replies
View Related
Feb 25, 2014
I have a macro enabled file with some functions. Now I want to create a fillable pdf file from this file.
I am able to create a pdf file from Excel 2007, but not able to make a fillable one
View 1 Replies
View Related
Oct 22, 2013
I have a macro-enabled template file in Excel 2007. I would like the user to be unable to save in any format other than macro-enabled. They should be free to choose a path and filename, but not the file type.
I presume this means some VBA code in the before save event, but I don't know what.
View 2 Replies
View Related
Jan 29, 2014
I have a file that I save with a new version number each time I make major changes. The file name currently is: "Telephony Equipment Inventory v26 (Summary).xlsm". The "26" is the variable number. give me the vba code to ensure I open the file with the highest version number?
View 6 Replies
View Related
Feb 16, 2014
I made the excel file with the VBA source code, saved it, opened it many times, and all at sudden I cannot open it anymore. When I try to open the file I get the following screen:
actually, Excel asks me if I want to enable macros or not, but this window is different than usual window:
when opened file with macros works fine.
So, in my case I click the Enable Macros button of the first picture and my file seems to open in some hidden instance, because the file name isn't writen in the title of the Excel window.
When I close the Excel window it asks me if I want to save changes to my file, and that proves that it was opened in some hidden instance of the Excel.
I have to say that I was not playing with the security options of hiding any part of the file that I want to open, and which doesn't open properly.
View 1 Replies
View Related
Aug 3, 2014
There are two excel files abc.xlsm and xyz.xlsm enclosed. download these two excel files to your desktop. Then open abc.xlsm and run following code.
[Code]....
After running code above you will see that you have a new file in your desktop named xyz.rar. Everyhing is okey until now.
Now, delete abc.xlsm, xyz.xlsm, xyz.rar from your desktop. Then download enclosed file named klm.xlsm to your desktop. Then open klm.xlsm and run following code.
[Code] ....
After running code above why there is no klm.rar file in your desktop? Is it not possible to create a zip file running code includes same workbook? I mean why I cant zip excel file, from same excel file?
Attached Files :
klm.xlsm
xyz.xlsm
abc.xlsm
View 1 Replies
View Related
Aug 1, 2013
I'm trying to save an Excel file to be opened on Excel 2003, but with some VBA formulas. What is the compatible format? 2003 doesn't open in .xlsm format.
View 1 Replies
View Related
Sep 13, 2012
I am using the macro below to save a file. It works with the extension .xlsx but not xlsm. I get a message that I can't use this extension for this file type. I am missing something fundamental.
Using Excel 2010
Sub testsave()'
Dim a As String
Dim b As String
Dim c As String
Dim d As String
b = "Myyfile"
c = b & ".xlsm"
a = ThisWorkbook.Path
d = a & "" & c
ActiveWorkbook.SaveAs Filename:=d
End Sub
FYI - there are no macros in the file I am trying to save.
View 1 Replies
View Related
Feb 2, 2008
how to get version number of the .dll file (in the path C:program files....) using VBA code. The properties of that .dll file has a tab named "Version". so i need the version number displayed on that tab.
View 3 Replies
View Related
Mar 22, 2012
Excel 2010, Win 7. I have attached a .xlsm file to an email. The contained macros run perfectly, and one of them is "public" so it shows up in "Developer - Macros", and "Customize Quick Access Toolbar" lists.
If the recipient clicks and drags the attachment to a folder, or copy/pastes the attachment, it works fine. (Macros are enabled, etc.)
However, if the recipient right clicks on the email attachment, and selects "SAVE AS" from the item list, the file saves, has the right name and extension, looks ok (the icon has the exclamation point, etc), and it is the correct size, but it simply will not load. You can double click, do a file open, etc. but it will not load. It's a hidden workbook, but if you "open it" and Alt-F11 to show the VBA editor, it isn't there!
It's not stopping the project - we simply tell them to click/drag, etc. but I totally do NOT understand why that happens.
View 5 Replies
View Related
Dec 11, 2012
how I could amend the following code so that my target worksheet includes file versions? The worksheet range "Folder" contains a string specifying the target folder and the worksheet range "IncludeSubFolders" is either TRUE or FALSE. I can trap FilePath, FileName, FileSize and DateModified fine but not File Version (I'm working with DLL libraries).
Code:
Dim iRow As Long
Sub ListFiles()
iRow = Range("DatabaseStart").Offset(1, 0).Row
Call ListMyFiles(Range("Folder"), Range("IncludeSubFolders"))
End Sub
[Code]......
View 1 Replies
View Related
Feb 11, 2013
I'm on excel 2010 and I have a small group excel files I open everyday. Most of the files are static in name and location. I've got a macro created to open those files, which works fine with workbooks.open and the file path.
There are two report files I want to incorporate into my macro of workbooks to open. The files are created weekly and the files names have the following format: "Report Name (YYYY-MM-DD).xlsm". I don't want to use the file's last modified date because older files may get edited after the more recent ones are created. The files are also not always created on the same day, so the solution needs to be flexible enough to not refer to a specific day of the week or anything.
Macro open an excel file based on the latest date found in filename.
View 9 Replies
View Related
Dec 21, 2012
I have a file that is on a server. When I open it on my excel it opens an old version of it and not the newest copy. If I open it on a coworkers computer, it does open the correct newer version. How do I change this?
View 4 Replies
View Related
Mar 5, 2013
I am using excel 2010 on windows 8. I load a file which has been sent to me via e-mail and save it with an upgraded name, I then do a large amount of data input and save the file again, I do this regularly and even test load it at times to check it has saved, finally I save and close the file and then on reloading I discover the version I have is the first one I saved! all the work I have done on it has disappeared! I also sometimes find random .tmp files with non-sensical names in the folder to which I have saved, but I do not have the rights to open these .tmp files.
View 2 Replies
View Related
Dec 16, 2008
I have tried to use the "FileSystemObject", but i just dont understand the concept around it.
The reference to use it as been selected.
In time, this directory maybe huge, so i want a fast macro to find out the name of the last created file.
View 9 Replies
View Related
Jul 1, 2014
I have an issue with saving the file at the desired location below is the code i have currently used . I have given the destination as "D:New folder". The new file does get saved at location "D:" but not inside the "D:New folder", instead names the file as "New folder".
View 3 Replies
View Related
Sep 13, 2006
I have a folder called 'Refresh'. Every week a new file is dropped into that folder. Instead of me placing that new file into my workbook, i would like my macro to just grab it. Is there a way for VB to grab the most recently created file that comes into my 'Refresh' Folder.
View 9 Replies
View Related
Apr 17, 2007
Is there a way I can check an excel workbook's created and last modifed dates using a macro in that same workbook?
View 3 Replies
View Related
Jul 4, 2014
I am creating 4 Sheets from a Main Sheet by Filtering Data based on different values in a fixed column, then the Filtered Rows are automatically pasted in the respective sheets.
Then these 4 Sheets are creating another file.
The same thing done manually by Grouping the 4 SHeets and then Move Copy into a New workbook also makes the file heavier.
Everything works fine however though the data is not much the file is very heavy, so what do i do to make it of appropriate size ?
View 1 Replies
View Related
Jun 3, 2014
i have a Macro, its creating unwanted inverted commas at the start and end of the File.
File:
"SunilManual|123456790|DrivingLicence|908567543|Sunil|Manchan
|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w
|w|w|w|w|w|w|w|w|w|w|w|ww|w|w|w|w|w|w|w|w|w|w
|w|w|w|w|w|w|w|w|w|w|55|55||4|SR-1161||1234567890"
Expected File:
|SunilManual|123456790|DrivingLicence|908567543|Sunil|Manchan
|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w|w
|w|w|w|w|w|w|w|w|w|w|w|ww|w|w|w|w|w|w|w|w|w|w
|w|w|w|w|w|w|w|w|w|w|55|55||4|SR-1161||1234567890|
VBA:
Option Explicit
Sub txtt_export()
Dim buf As String, col As Long, r As Long, ws As Worksheet
[Code]....
View 2 Replies
View Related
Nov 18, 2009
In the code below, I am trying to add code that will verify that the file to be opened is actually there. If it's not, I want a message box to tell the user that the file is missing or not there. My efforts have XXXXXXXXXXXXXXX above and below my inserted code. Sorry, but I'm lost and need a method of advising the user via a message.
View 3 Replies
View Related
Oct 4, 2006
How do I check to see if a particular file exists using Visual Basic
View 2 Replies
View Related
May 26, 2014
I want to create something like this: macro checking if file aaa.csv isn't open, if it is macro should stop and show message box "Close aaa.csv", and if file isn't open it should continue to work.
The file aaa.csv is stored in the same folder as workbook with my macro.
View 3 Replies
View Related
Nov 8, 2007
I have an excel spreadsheet used to populate word documents based on a template file that is loaded like this....
View 9 Replies
View Related
Nov 7, 2008
It checks to see if DataImport2, 3 and 4 exist and then executes code.
Currently DataImport4 does not exist so it should not execute anycode but for some reason the code is still trying to execute it and select Sheets("DataImport4").Select
View 5 Replies
View Related
Oct 2, 2012
How can I check if a file exists with VBA?
View 3 Replies
View Related
Apr 11, 2014
I have some code which works perfectly and emails the active workbook (which the code is within) as an xlsm to a email address. All is well.
However - how do I change my code so the workbook is sent as a CSV?
[Code] ....
I thought putting the following would work after 'ActiveWorkbook.FullName' but it did not:
[Code] .....
View 1 Replies
View Related
Aug 23, 2008
My office just converted to 2007 and I am running into a problem with code used to save a workbook. I need to use a dialog box as the file could be placed in several different locations which the user needs to choose.
When the save as dialog box opens it defaults to being saved as the xls type. I would like to modify the following code so the file type drop down defaults to the xlsm type. Below is my code.
Sub SaveFile()
Dim Fdate As String
myDate = Range("HeaderPage!B13")
myFile = Range("HeaderPage!b8") & "_" & Range("HeaderPage!b9")
Application.Dialogs(xlDialogSaveAs).Show myDate & "_" _
& "_" & myFile & ".xls", 1, , , , False
End Sub
View 9 Replies
View Related
