Search results

  1. A

    Automatically Overwriting Files

    Yes, I would actually prefer to use VBA as well. I am a little more familiar with Ruby and Python. I want to learn VBA but I seem to have no clue how to make a script play. Here is what I am doing: I go to Access 2010, in the "database tools" area I select the "visual Basic" icon...
  2. A

    Automatically Overwriting Files

    also, the folder where my file is located in is read only.
  3. A

    Automatically Overwriting Files

    I actually took a look at this about a week ago and copied the code to the best of my ability. this is the code I used: ----code below-------- Public Sub KillProperly(Killfile As String) If Len(Dir$(Killfile)) > 0 Then SetAttr KillFile, vbNormal Kill KillFile End If End Sub ----code...
  4. A

    Automatically Overwriting Files

    Hi everyone, I have set up a temporary macro named "AutoExec" that outputs a predefined query to an HTML file and an excel file. These files need to be updated often so our website is as current as possible. The issue has become the annoyance of these two prompts that pop up that ask the...
Back
Top Bottom