Search results

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...

Thank you very much this worked perfectly. I am most greatful for your patience and assistance

File

I entered this =LOOKUP(999,SEARCH(A:A,U2),A:A) With my list being in column A and my combined data in column U and my lookup in cell D2... I got a 0 as my returned value. And I can see the value listed there.... I am sorry if I am being obtuse, I have a bit of a headache and am not thinking...

Okay, what is the 999? What does it do?

Shrivallabha let me try this.

Okay, I think I am missing something, I put in the code =LOOKUP(LEN(U:U),SEARCH(A:A,U:U),A:A) With my list of codes to search for in Column A and my collection of codes to look for in column U, I got an #N/A. Would you like me to attach and example file?

This is not a one code per cell situation as I stated in my original post, so a lookup will not work. If more than one code is found it does not matter which is returned so long as the one returned is in the required listing.

This is going into a Macro, ... I have to admit I am very uninformed as to VBA, so if I can add the code to the Macro then yes, or if you can help me with applying the VBA then yes... The only limitation with that is my ignorance of VBA, I think

This is the list for now; they will always be the same until January then they will change, and occasionally there maybe some additions and/or subtractions but for the most part they will always be the same. I have a whole seperate list that I will do the same thing for but can apply the same...

Good Morning. I am working on a complex formula that I may have found a fix for, but am not sure if/how to apply it. I have data that comes out of another program as a column collection (meaning that it takes several rows of data and combines them into one cell in Excel.) this is causing an...