1004 error

[Steven811]

Hi

We run this successfully on a several Win10 pc's in my home office. I've set up a new user and get the 1004 error on this one new user and I can't see what's wrong. Any assistance would be much appreciated.

Please Login or Register  to view this content.

Thanks, Steven

[romperstomper]

Check that the value of

Please Login or Register  to view this content.

is what you expect and that the user has access to it.

[ByteMarks]

Is the activesheet blank?

[Steven811]

Hi Romperstomper

We have a two network folders, one for the saved pdf and another for the xlsx files wih permissions set for the user so unsure why it's stopping.

Or I have I misunderstood what the code is doing?

Thanks, Steven

[Steven811]

Hi ByteMarks

It is blank except for the email address on one the quotation page for testing. The primary address is blank.

I'm going to test it again and check.

Thanks, Steven

[Steven811]

Hi ByteMarks

I've tried again on a completed spreadsheet and still get the 1004 error.

Thanks, Steven

[romperstomper]

Or I have I misunderstood what the code is doing?

No, but absent any context, all I can do is suggest that you verify that the path created by those variables is correct when that user runs the code and that he has access to it.

[Steven811]

Thanks, I will check again.

[6StringJazzer]

Please show us the values of variables Path and publicName at the point the error occurs. How is the code assigning values to these?

I know you think the problem is in this one line of code because that's where the error occurs. But the root cause could be somewhere else. It would help if you showed us all your code. If you do so, please use code tags. (I added them for you in your first post for the sake of keeping things moving forward.)

[Steven811]

This is odd. I've changed the user permissions to administrator for testing purposes and still get the 1004 error.

I'm a bit stuck now.

Any suggestions always welcome.

Thanks, Steven

[romperstomper]

One other thing - does the user have a default printer set up? (Excel historically can be a bit funny about printers)

[Steven811]

Hi

The task the code should be performing is to send and save a pdf quotation to a customer. It appears to be failing at the saving bit, although I'm guessing at this. I've removed and added the permissions and still get the error, I've also created the recipient folder on the local drive and still get the error. I can run the same spreadsheet with another user, saving on the network and it works as expected.

A pdf is attached to an open email in Outlook and waits to be checked and then it's manually sent.

The failed request neither opens Outlook nor saves the pdf in a designated folder.

Our spreadsheet is very old and includes many snippets that have been added over the years

The is the code from the module:

Please Login or Register  to view this content.

I had no idea about the printer potentially being an issue but, now added.

Thanks, Steven

[ByteMarks]

There's no path separator between Path and publicName or between pathLocal and savedName, which might be causing an issue.

[6StringJazzer]

Definitely causing an issue. Could have identified quickly if we'd had a response to yesterday's post #9.

[romperstomper]

Or #2 or #7...

[6StringJazzer]

Yes indeed.

[Steven811]

Hi

Please accept my apologies.

I'm unfamiliar with the terms and can't seem to find a clear explanation as to what they are or what is missing.

My apologies again.

Regards, Steven

[PrizeGotti]

Interesting, yesterday the same error appeared on our machines for a similar piece of code. Has there been an update that has affected how Excel exports to PDF?

[romperstomper]

Not that I'm aware of, though there were a couple of recent generic printer driver bugs that affected sending pdfs via outlook from Access. It's conceivable that could have caused other issues.

[Steven811]

Hi

I have compared the code from two of the spreadsheets and they are indentical. A dedicated workbook functions for one user and the other identical workbook doesn't work for the other user.

We have run both sheets with me as a user on my PC and they work. When I set up one of the other user accounts on my pc both workbooks return the 1004 error.

I've endeavoured to ensure that the user permissions are set correctly and they appear so but, clearly something is incorrect.

Please forgive my naive explanation but, I'm new to this and although I really enjoy experimenting, this is driving me mad.

Thanks, Steven

[romperstomper]

You never answered my question about the default printer.

[Steven811]

Hi romperstomper, there wasn't a default printer set so I added one and the 1004 error issue remained. I've managed to get around it for now by reactivating and renaming an old user.

I have read that old excel files can be problematic. This file is very old and has had many changes and improvements over the years and I am exploring starting from scratch and rebuilding it.

Thanks to you and everyone for your advice, much appreciated

Regards, Steven