Search results

Tring to bypass bitdefender. Tech loacted xls file on desktop with an exclusion but instead we wget “The operating system is not presently configured to run this application” Any suggestions? TIA

Surely they have a backup?

Method 2: Open a standard excel from protected exe Public DestinationWorkbook As Workbook Public SourceWorkbook As Workbook 'Set file path Set DestinationWorkbook = Application.ActiveWorkbook Dim XLSPadlock As Object Set XLSPadlock = Application.COMAddIns("GXLSForm.GXLSFormula").Object Filepath...

If you were to open another exe protected file from your original exe - (Need to declare public variables first:) Public Declare Function ShellExecute _ Lib “shell32.dll” _ Alias “ShellExecuteA” ( _ ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _ ByVal...

There are two possible causes. Most likely their anti virus/malware is false detecting the exe as a ransom ware. This is easy to check by going to the antivirus and checking actions/quarantine. To solve this you need to add an exception to the folder containing the exe. It may take 24 hours for...

Code has now been uploaded in post. Sorry for delay

The firts lot of code is in (Microsoft Excel Objects) > ThisWorkbook Sub Workbook_Open() Application.Run “Test_if_File_Open” End Sub The following code is in normal modules Private Sub Test_if_File_Open() 'Test for when file open is already open 'Check to see if file is open Dim SourceFile As...

Yes I find the same. Manual signing works ok.

But you can open the exe version of the XLSC file through VBA

I had this issue in the past but solved it through a simple workaround. Upon opening the xls padlock file it will check if a text file exists “FileOpen.txt” If the file exists it warns the user to not proceed. And asks if they want to close the application. If they select “yes” it closes with...

The string is if you wanted to set a saved file name and pathway by default. This is instead of asking them to save a filename. I just realised you need the filepathcode as well You need to have '“Do not allow loading or saving of other workbooks” unticked. Also as a tip for debugging when I...

See the manual section 11.8 about saving to other workbooks. You are missing crucial code. Try this: Dim DestinationWorkbook As Workbook Dim SourceWorkbook As Workbook 'Add the string file here or in the strFile = Application.GetSaveAsFilename("", “Excel workbook (.xlsx),.xlsx”, 1) 'If...

Changed all the applications to have separate GUID. Thanks to Golfer on previous topic replay

I have four xls padlock applications. Open last save will open the very last application regarless of which exe file is selected. Is there a workaround?

For the workbook_Open module you have to move all the coding to Microsoft Excel Object (above forms) The last tab under sheets should be ThisWorkbook Place all the required functions here as well as required workbook open macros Your sub will be: "Sub Workbook_Open() Not sure about after save...

Or use shellexecute if the second file is an exe file eg 'open xlspadlock protected file Dim TargetFilepath As String TargetFilepath = PathToFile(“SafeBUDDY Graphs.exe”) Application.DisplayAlerts = False Application.AskToUpdateLinks = False 'Call Shell(Filepath) Dim...

Yes. But anytime the user navigates to a page (worksheet) by clicking on icon - running vba macro, effectively the timer resets for a further 5 minutes Public RunWhen As Date Private Sub Save_Required() 'allows save when idle Dim TimeSave As Integer Dim TimeSchedule As Date TimeSave =...

My programming was wrong - Rookie Error!

Dan, I have code that auto saves when idle every 5 min without bringing up save dialogue box. let me know if interested.

Thought someone might be interested as it was a long and hard search to finally get a startup sound in wma happening (mp3 file size are too large) I wanted to make a professional app so in addition to the splash screen I added a startup sound. The wma file is obviously added at install time. In...