Error Saving Excel Sheet - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Error Saving Excel Sheet

Michael Medici

15 months ago

Hi all,

Firstly thanks to everyone for their time and support.  I try not to bother too much :)

I've run into a problem.  The goal is that when the user hits submit on their order I want to create and save an excel sheet with their order and email it out.  Creating the excel sheet is not the problem.  It opens up on my screen, but I always get an error 1004 and saving error on the sheet.

The code I have for saving is:
xlapp.DisplayAlerts = False
    xlBook.SaveAs ExcName
    xlapp.DisplayAlerts = True

ExcName is built as ExcName = CurrentProject.Path & "\" & RecordSource & ".xlsx"

Now this is on a corporate computer that is using OneDrive, I don't know if that has anything to do with it.

Appreicate the help.

	Kevin Robertson @Reply 15 months ago
Try renaming your variable. RecordSource is a Reserved Word.

	Michael Medici OP @Reply 15 months ago
Tried that and made it as simple as possible: Filepth = CurrentProject.Path & "\test.xlsx" But still getting the 1004 error. I am suspecting that the use of corporate OneDrive is causing the problem. Any thoughts?

	Kevin Robertson @Reply 15 months ago
OneDrive might be syncing files in the background, causing conflicts when you try to save. Try saving to a local folder outside OneDrive (like C:\Temp\) Example `ExcName = "C:\Temp\" & Filepth & ".xlsx"` If it works, OneDrive is the problem. You might need to adjust sync settings or move the default save location. File Sharing Which line is highlighted when you click Debug?

	Michael Medici OP @Reply 15 months ago

	Michael Medici OP @Reply 15 months ago
the debug runs fine with no errors, so this does not seem to be a VBA code issue. Windows error attached.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View