VBA code not saving into FilePath

**Keith Edgar** · 01-22-2014, 08:11 AM

Hi,

I have this code which basically exports PDF files, which is great. I have been trying to combine a couple of macros to adapt it so that it creates a new folder and saves the pdf files into that new folder. The new folder should be contained within the filepath the current workbook is saved on.

I think I may have lost the plot somewhere though, as currently this coding is creating a new folder, but saving the pdf's into the same filepath as the original workbook, rather than the new folder created.

How do I tell it to save them into the folder created?

Any help greatly appreciated!

Please Login or Register  to view this content.

**Keith Edgar** · 01-22-2014, 08:28 AM

Didnt realise that, sorry. Have adjusted my original post now

**Steve@Rugby** · 01-22-2014, 09:58 AM

Hi

Try this

Please Login or Register  to view this content.

Regards
Steve

**Steve@Rugby** · 01-22-2014, 10:07 AM

BTW, a few variables in previous code that i left in as assuming this is only a small part of larger code?

If not this is the slimmed down version

Please Login or Register  to view this content.

Regards
Steve

**Keith Edgar** · 01-23-2014, 11:32 AM

Hi Steve,

Thanks so much, this seems to work. I am hoping to adapt it slightly but I keep getting some errors. Basically for each of the UCase statements, I want to save those worksheets in a different directory.

So for example, everything is saved under Sourcwb.path & P&L Report, but then for REV > a folder called revenue, for HC a folder called Headcount.... and so on... so that it basically sets up each file in the file path... This is what I have currently...

Thanks so much for any help...

Please Login or Register  to view this content.

**Steve@Rugby** · 01-23-2014, 11:55 AM

Hi kieth,

Affraid i cant look at this until tommorrow now, hope its not too urgent. Maybe soemmone else can help you tonight if it is.

Regards
Steve

**Keith Edgar** · 01-24-2014, 05:12 AM

Thanks for your help Steve ! really appreciate it.

**Steve@Rugby** · 01-27-2014, 08:14 AM

Hi Keith,

So sorry for the late reply I was very busy at work. I cant seem to get your code to go wrong in my tests, it seeems to work fine. Could you attach your excel file for us to view and test with?

Regards
Steve

VBA code not saving into FilePath

LinkBack

Thread Tools

Rate This Thread

Display

VBA code not saving into FilePath

Re: VBA code not saving into FilePath

Re: VBA code not saving into FilePath

Re: VBA code not saving into FilePath

Re: VBA code not saving into FilePath

Re: VBA code not saving into FilePath

Re: VBA code not saving into FilePath

Re: VBA code not saving into FilePath

Thread Information

Users Browsing this Thread

Similar Threads

VBA code trouble adding variable to filepath to open copy & paste from another workbook

[SOLVED] Including VBA code to copy filepath to cell range

[SOLVED] Copying files from a selected filepath to a filepath mentioned in a worksheet's cell

code for variable filepath

[SOLVED] Store FilePath Inside Code

Bookmarks

Bookmarks

Posting Permissions