Saving Workbook in newly created directory

Unfortunately this didn't work completely. The directory is created with the correct name and the workbook is saved with the correct name however the workbook is saved in "My Documents" and not in the newly created directory.

The workbook with the macros is saved at

S:\sgreni\AnyJob\anyjob_rfiform.xls

This subroutine is trying to create a new directory with newly saved and named workbook.

S:\sgreni\anyjob\east_rfi_x\east_rfi_x.xls

Currently the directory is created however the workbook "east_rfi_x.xls" is saved on c:\mydocuments

I should also say that I am working off of the S:\ drive which is a network drive, and the C:\ drive is my local harddrive. I can assure you that I am logged in to the network and can have access and permissions.

Any insights would be helpful. Thanks.

Regards,

Sterling

Please Login or Register  to view this content.

I thought I would also mention that I've tried something else. This places the newly created workbook in S:\sgreni\AnyJob\east_rfi_x.xls. Thanks again.

Please Login or Register  to view this content.