-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
filesinpath
-
D
Compile Error: Method or data member not found
I'm getting the "Compile Error: Method or data member not found" error on the following line of code on my co-workers computer but I have no issues on my computer. We are running the same version of Excel (2016 on a MAC), any idea what the issue could be? Error on mybook.Close...- DWhit217
- Thread
- dim end filesinpath fnum string
- Replies: 4
- Forum: Excel Questions
-
D
Bypass Apple's Excel 2016 Sandbox Requirements
I have the following macro which increases/decreases material pricing from one "Master Key" to multiple files (pricing templates) in an "/Update/" folder. This macro worked fine for Excel 2011 but when we moved to Excel 2016 it is asking permission to open a folder and I can't select the folder...- DWhit217
- Thread
- dim end files filesinpath fnum
- Replies: 1
- Forum: Excel Questions
-
D
MAC Excel 2011 VBA File Name Limit of DIR function
I'm running into an issue where I can't use VBA to open a file to inject new data unless the filename is shorter than I believe 28 characters. Is there a workaround for this? Below is my code for reference. Sub FactorChange_Price() Dim MyPath As String, FilesInPath As String Dim...- DWhit217
- Thread
- dim end files filesinpath fnum
- Replies: 1
- Forum: Excel Questions
-
D
VBA Batch Transfer Data of Old File Template to New File Template
Using Mac Excel 2011 btw which is why you see a ":" instead of a "/". I'm trying to take the data from a batch of files in a subfolder called "Old" which is located in the directory below my template file. Copy and paste the data from those files into my active workbook which is a new template...- DWhit217
- Thread
- dim end files filesinpath fnum
- Replies: 1
- Forum: Excel Questions
-
D
VBA To Add Values to a Current Range
I have code that is supposed to add price changes to current price values for all workbooks in a certain file location but I am having trouble getting it to work. Sorry, am a VBA noob. Here is the code: The BOLDED is the line that is giving me issues. Sub FactorChange_Price() Dim MyPath...- DWhit217
- Thread
- dim end filesinpath fnum mybook
- Replies: 2
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
Excel VBA Parse Column A into multiple columns help but with conditions
- Started by BalloutMoe
- Replies: 59
Hello, I have a TXT file that gets imported in excel and it always ends up in column A. I am trying to split the data up however. The middle... -
Data with Different score
- Started by sksanjeev786
- Replies: 30
Hi Team, I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data... -
Looping a macro through all visible sheets?
- Started by GlennJ
- Replies: 29
I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated. [CODE=vba] Sub... -
Loop through Column, looking for an array of values, If NOT found, delete entire row
- Started by blbat
- Replies: 29
So I tried to modify some good code from Joe4, but ran into some walls. I'm trying to modify his working loop to cycle through Column "D", find... -
VBA to extract values starting with specific character
- Started by sncb
- Replies: 21
Hi all, I paste two cells of data into A1 and B1 with different formats and spacing like below and I need to extract only those values that start... -
macro/vba fix for not a blank, blank in Go To Special
- Started by LorettaAlsop
- Replies: 20
I am writing vba code (thru using macros) to format a ws. In a portion of the formatting I identify the blank cells and replace them with the cell...
