Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting Images from certain File Folder Take2
Previously i asked about inserting all images from a folder, Now my problem is that when i run the code, it pops up a window, not at the specific folder i defined, but at the My Documents folder. How does one fix this problem? below is a snippet of my code ------------------------------------------------------------------------------------------------ Picturestring = Application _ .GetOpenFilename("D:\AAA Elder Zornes Documents\01 To Be Processed\CSM Process Folder\All Files (*.jpg),*.jpg", , , , True) ------------------------------------------------------------------------------------------------ Thanks for any and all suggestions/replies Ironhydroxide |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting Images from certain File Folder Take2
You need to perform a chdrive and then ad chdir like below. You can automatically get each of the filename in the code below rather than use getopenfilename. If you use getopenfilename you cna modify your code to allow multiselect so you can select more than one file at a time. Drive = "D" chdrive Drive Folder = "D:\AAA Elder Zornes Documents\01 To Be Processed\" & _ CSM Process Folder\" chdir = Folder Picturestring = dir(Folder & "*.jpg") do while FName < "" 'add your code here 'the filename for each picture is Folder & FName Picturestring = dir() loop "ironhydroxide" wrote: Previously i asked about inserting all images from a folder, Now my problem is that when i run the code, it pops up a window, not at the specific folder i defined, but at the My Documents folder. How does one fix this problem? below is a snippet of my code ------------------------------------------------------------------------------------------------ Picturestring = Application _ .GetOpenFilename("D:\AAA Elder Zornes Documents\01 To Be Processed\CSM Process Folder\All Files (*.jpg),*.jpg", , , , True) ------------------------------------------------------------------------------------------------ Thanks for any and all suggestions/replies Ironhydroxide |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting all pictures from a certain file folder | Excel Programming | |||
Inserting Many Images | Excel Programming | |||
Inserting images into excel conditionally | New Users to Excel | |||
How do I un-embed images in Excel and save them to another folder. | Excel Discussion (Misc queries) | |||
inserting images in excel | Excel Programming |