Recent content by ireland13752

Yes, the steps work manually, I just cannot get it to process in the Macro. It will open the save box, but not populate the suggested name. [ Filename:=Application.GetSaveAsFilename("VBP PRMC 2013-MM.pdf") ]

Hello, Can you please help me figure out what I need to tweak to get this macro to work again? It worked great until I had to do a Migration from XP to 7. The code is pretty straightforward, so I am not sure why I cannot see it... Code (vb): Sheets("PRMC").Select Sheets("PRMC").Activate...

Hello, Can you please help me figure out what I need to tweak to get this macro to work again? It worked great until I had to do a Migration from XP to 8. The code is pretty straightforward, so I am not sure why I cannot see it... Sheets("PRMC").Select Sheets("PRMC").Activate...

After some sleep and fresh eyes, I figured it out! Thank you THANK YOU THANK YOU!!!!!!!!

Hi Debra, thank you for responding. I am sorry, I do not understand what you are saying. "If you have perfectly all sheets present in the workbook and no need to check any validation for "Sheet Name Not Exist" / "File already exits in the dest location" then, you can test below one too.." My...

Hello, I need to save selected tabs to a new file and then when finished delete those tabs. I have it all worked out except it is not saving only the tabs I have highlighted it is saving all tabs remaining in the file. Can you please assist me? Below is the code that I am using to save the tabs...

RESOLVED I was able to fix this part. Thank you

I thought I had with the Filename = Application.GetSaveAsFilename("DCT Weekly Review MM-DD-YY.xlsx" Piece. Is that not what this does?

Hi Dan, Not sure if you were able to find that code we discussed previously?

Hello, I have requested assistance on this once before and it worked for .pdf, however now I am trying to save as .xlsx. It is going through the motions, however the file(s) are not there after the fact. Here is the code I am using can you please assist me with the adjustments that need to...

Hi dan_I, Thank you for responding, I apologize for the delay, I got pulled into another project. Yes, that would be fantastic, except I have to be able to change the name of the file each time it is run, It will be "file name MM-DD-YYYY"

@ SirJB7 Using this, changing a couple things and adding couple more steps, it worked! Thank you very much! I am truly grateful!!!

Hello, I need to select the next cell from A1 using a Macro that will use filters for data and then input with drop down to last row. The issue I am running into is that the data will be in different rows everytime. The filter will remain the same and in the same column but it may be in row 9...

Thank you for your assistance, I apologize if I seem obtuse.... I get the dialog box, but it is still not taking me to the correct folder. Did I put this in the correct place? ChDirFilename = Application.GetOpenFilename(, , "\\phsfile\groups\QUALITY_INSTITUTE\1 DATA ANALYST & REPT\file1\file...

Good Morning, I am trying to save a file using the code within a Macro. I will need to do this several times within the macro and I would like to be able to have the Save As box open to the correct folder. I can get it to open the Save As dialog box, but not to the correct path. Can you please...