Search results

  1. S

    My db has a csv linked file how can I share with others

    My Access db has a csv linked file for updating the csv file in my documents folder. When others try to open it they get an error that the file is located in my documents folder. I split the db and changed the tables back to csv linked file. It works for me, but not so much for others.
  2. S

    How to link a excel sheet to a table

    I want to link an excel sheet to a table, so when the table gets updated the excel sheet is automatically updated.
  3. S

    Saving Outlook file to a folder

    I am trying to look for a specific file in Outlook and save it to a folder in my Documents. Can someone please help.
  4. S

    Macro stop working

    I created a macro to loop through a folder and format all the excel files in that folder, but the formatting part isn't working any longer. It worked fine on Friday. It's suppose to delete certain columns and rows: 'Loop through each Excel file in folder Do While myfile <> ""...
  5. S

    Do while loop for certain value

    I have a Do While myfile <> "" which looks through a folder for all excel files and then formats them. But what code do I include if I don't want each file formatted if it has a certain value in A1. I still want the code to loop through each file, but only format the files if the value isn't in A1.
  6. S

    RunCode with two functions

    I am trying to run a macro that use two functions. The first function formats all of my excel files. The second function is suppose to import all excel files into an access table. The first function works, but when I go to create the macro adding my second function, I get an error "The...
Top Bottom