- Local time
- Today, 03:59
- Sep 21, 2011
No reason why it cannot be on your desktop?As you indicated, it is exactly the same as what I have, infarct, it is default
except for Decimal, symbol which I now changed
View attachment 91467
It seems to export as expected.
I would really like it to be saved on the desktop instead of the current project path and also would like it to open as soon as it has been exported
Thank you so much for the assistance, i know I usually get all frustrated then I don't listen , causing frustration on your side
change strExportFile to
strExportFile = Environ("UserProfile") & "\Desktop\CS Order Line Items.csv"
Then Google/research on how to open the csv file.
Search here, as there is code that will open any file depending on the extension using it's default program.
Do you actually have an export spec called Order Line Items now that can be used like this, as normally it is not the simple save Spec, but you have to use the Advanced option, which is confusing.