-
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.
fpath
-
6
How do I stop formulas from referring to an old book when saved as a new one
This codecreates a new folder with a new name and saves various sheets from the book into the folder(SEE MACRO AT THE BOTTOM). The issue is, (SECTION "3" SEE FULL MACRO)I need two sheets saved in one book. This macro works, however, once saved in the newly created folder, the formulas inside...- 6TBM6
- Thread
- call file fname folder fpath
- Replies: 0
- Forum: Excel Questions
-
LoadPicture Controls Challenge
Hello All, I need help to figure out what I am doing wrongly here: I wanna load image control on my worksheet with this script but I think i am doing something wrongly since I can't get the result. Sub ShowPic () Dim fPath As String, sFile As String On Error resume next fPath =...- kelly mort
- Thread
- dir end fpath sfile sheet2.image1.picture
- Replies: 9
- Forum: Excel Questions
-
G
VBA for SaveAs workbook
I am using the following code to save a current workbook but I would like to modify it to save the current workbook as the new name and open that new workbook and close the original and leaving it untouched. Basically, using a Saveas instead. Currently it just saves the workbook as a new file...- GuyGadois
- Thread
- file fname fpath vbnewline workbook
- Replies: 7
- Forum: Excel Questions
-
A
Encrypting PDF documents using macros
Dear experts. Please can you help me with this macro. The below code converts the excel sheet to pdf. and then password protects the pdf. using passwords i already have in sheet1. My problem is that, i already have hundreds of pdf. letters in a folder that i need to have it password protected...- ANaidoo
- Thread
- dim fpath ftemp opdf pwd
- Replies: 0
- Forum: Excel Questions
-
looping through cells
I wanted to loop through this code : Sheet1.Image1. Picture = LoadPicture (fPath & "\" & Sheet1. Range ("B2") & ".jpg") Sheet1.Image2. Picture = LoadPicture (fPath & "\" & Sheet1. Range ("B12") & ".jpg") Sheet1.Image3. Picture = LoadPicture (fPath & "\" & Sheet1. Range ("B22") & ".jpg")...- kelly mort
- Thread
- fpath loadpicture picture range sheet1
- Replies: 7
- Forum: Excel Questions
-
W
SaveCopyAs
Hello everyone, I am new with all macros and I`m trying to create macro which saves copy of workbook. But I cannot get my head going how to create one bit.. how to check the location before saving and if file name already exist message will come "file already exist please check name field" and...- werevollf
- Thread
- check exist file fname fpath
- Replies: 2
- Forum: Excel Questions
-
N
Open folder with partial name
Hello! I just joined so I apologize in advance for any posting mistakes. Anyways, I want to search through a folder for a subfolder that contains a number input by the user. The subfolder name will have the format Projectnumber_TestNumber where the project number is always 8 characters and the...- nathank2
- Thread
- folder fpath input number test
- Replies: 8
- Forum: Excel Questions
