Recent content by Sonya810

Thank you. Let me try this

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.

Yes I am

No, not that I can see. My manager wanted an access database to update the power BI. I currentlyhave an excel table. I just created the user form he wanted to feed my excel table. Power BI wouldn't even allow me to import access, I got some errors.

Yes, that is correct

I just decided to create a user form in excel. This data feeds to a power BI report.

Ok. Thank you. I think I found a solution.

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

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

The problem is solved. There were issues with my files.

Oops! I actually need to keep column B, E and I and get rid of everything else up to Column J

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 <> ""...

The code loop to the first file and if the first file is already formatted it stops. I want it to loop through all of the files in the folder. If the first file is already formatted then move to the next file

Sorry, I think that did work! Thank you