mypath

the below code is good but i need one for exact cell value for example pdf file 1000 in this code come to cell vaLue 1 and 10 and 100 and 1000 i need code to cell value 1000 only Code: Sub AddHypaerlinks() Dim lastRow As Long Dim myPath As String, fileName As String myPath =...

Hi...My name is Robert, and I am a schoolteacher who is taking a dip in the Excel VBA pool. I consider myself to be very knowledgeable of using spreadsheet formulas, but I am definitely an amateur when it comes to coding. I am trying to control my frustration of not being able to find the...

Hi All, I am trying to loop through files in a folder and Copy the first sheet to a new workbook. I want the first sheet in each file to be it's own worksheet in a master workbook. I managed to figure out the looping part, but am stuck on copying the first sheet to a new workbook. Any help...

Hello all, I am trying to create a macro, to do this: - macro will be placed on a new workbook, called "final". this workbook will have a lot of sheets "munchen", "wien", "paris" etc. - when run, the macro will find the newest file in a folder , will open the file, copy some data from every...

I'm running a bit of code to open all the *.xlsx files in the same folder as the *.xlsm file. But I keep getting the window that says: We can't update some of the links in your workbook right now. You can continue without updating their values, or edit the links you think are wrong. Here's the...

I have modified the following code to change the value of a specific field and auto increment an invoice number for all the files in a user selected folder. The code works great and saves the changes to the .xlsx file but I would like to save as PDF at the same time. I have tried examples from...

Hi All, I've a PDF file. I'm opening it through the below code. Before closing it, I wish to rename/Saveas the file with a different name (Lets say 'ABC.PDF). Can anyone help. Dim lMyNewNum As Long Dim strTest As String Dim XLName As String, PDFPath As String, READERPath As String...

I really could use some advice. I am new to this forum, so please forgive my mistakes. Thanks, in advance. I wish to have a button launched macro that saves my workbook to a new folder -both of which are named after cells on the active worksheet. So far, I can get the folder created (from...

Hi,I am trying to write the vba code to loop through eight (8) files in the same folder and copy and paste the data from one specific sheet into another workbook. I have it working except for the Loop part. Doing this also involves identifying the next empty cell. Can someone please help me to...

Appreciate highly, if any one help me in modify code this..

Hi, I have set up my own stock control with Purchase orders. Using a VBA I save the PO to a register and also save a pdf copy to another folder. i would like to open the PDF from the Register using a hyperlink (this i have completed), but it only opens the folder with the PO's listed. How can...

Hi Experts, I need your guidance. I have the below code whoch was written to cycle through all files in a folder. Now im faced with a challenge of having multiple sub folders upon sub folder within the parent folder. Is it possible to adapt this code to loop through Parent folder and its sub...

Hi Guys,<o:p></o:p> <o:p></o:p> I’m trying to open the latest .csv file from a folder using vba andthen to copy and paste some of the columns from the csv into a spreadsheet thatI have. The code that I ams using worksfine to open the lastest csv but once it copies ans pastes the data formatting...

Hi all, I'm fairly new to VBA and have been trying to muddle together a VBA macro to basically select a predefined folder, open any workbooks within that folder (ideally, i wouldn't even open the workbooks if possible but thought this would be far to complex for me starting out) and copy and...