How to open Quicken's exported CSV files in Mac Excel without granting access

jschaffe

I frequently export CSV files from a Quicken Mac register or report and open it from the file menu (or VBA) in Mac Excel. For the past several years, I have to go through two dialogs to grant access to each file in Excel. Has anyone else experienced this and is there a way to open the file without having to endure this?

Thanks in advance!

J

UKR

When creating the export file in Q Mac, what folder are you writing this file to? Your Documents folder? Somewhere else that you don't normally have access to?

jschaffe

https://community.quicken.com/discussion/comment/20442007#Comment_20442007

Will try double clicking and taking screen shots next time i get the chance

jschaffe

https://community.quicken.com/discussion/comment/20442091#Comment_20442091

I’ll double check, but I believe that it is a folder I created under my home folder.

jschaffe

OK, I just went through the process today, and here is a summary:

1. The csv files are saved to a sub folder under my home directory
2. Simply double clicking a new csv file opens the file in Excel without challenge
3. All the relevant file activity takes place in macros I've written to process the data from Quicken
4. In one of the macros, I create a new xlsx file and save it into the same target directory as the csv files with no challenge whatsoever
5. So the problem arises when one of the macros tests whether a file exists: DirResult = Dir(PathName) where PathName is the complete path including the file name.
6. I've attached the 2 dialogs this call triggers when testing for the csv (but not the xls) files.
   Grant Access Part 1.jpg
   Grant Access Part 2 copy.jpg

After clicking Select and then Grant Access (the target file is automatically selected, so that's a plus), the rest of the macro process sucessfully.

It's a bit of mystery to me. Next time I'll try just opening the file in the macro without using the Dir() call and see if the same thing happens.

Thanks!

jschaffe

True. I didn't realize it was macro specific until now, and my Google searches have not uncovered anything helpful to this point. Even so, I thought this community might include folks who were more likely to encounter the problem because of the export report features. Now that I know it’s related to VBA, my searches might be more fruitful! Thanks for your response!

jschaffe

Best I could find is to grant access to all my csv files at once: https://learn.microsoft.com/en-us/office/vba/office-mac/grantaccesstomultiplefiles . This reduces the 8 original dialogs to 2, so it's at least a nice improvement!

Thanks for everyone who thought about this!

retird

What about making the file a shared file….

jschaffe

How does one do that?

retird

Google share csv files in excel

jschaffe

Well, whether that prevents Excel from asking me to grant access or not, doesn’t it also mean sharing my files with Google?