Hi,
I would need to do some file operations when using form in Excel.
I need to:
1) Get path of file specified by user (jpg) - This I can do
The following I do not know how
2) Copy this file to another location with another file name
3) Create new text file with specific name
4) Append text to text file
Could you point me to appropriate help chapter (I honestly can not find anything that would match this tasks) and give me some clues on how to cope with this.
Regards,
Cris
You can do this sort of stuff with filesystemobject:
Please Login or Register to view this content.
Thanks,
Is there a place where I can find a list o methods available for filesystemobjet in Excel VBA?
Or will it be the same list of methods as for FileSystemObject in reference for Windows Scripting available at:
http://msdn.microsoft.com/en-us/libr...=vs.84%29.aspx
Cris
Yeah it's the same.
Hi,
I had made some progress but still did not managed to get tins work.
I have a problem with coping file.
I used this example as base.
http://msdn.microsoft.com/en-us/libr...=vs.84%29.aspx
my code is:
The file gets copied but I have problem with it's filename.Please Login or Register to view this content.
As you can see filename is created out of a number and I want it to be formmated 0000.00.jpg (for easy sorting in directory). Corresponding number is stored in excel cell (this is a database, and jpg are pictures of things in it). After coping filename is 0000,00.jpg (with coma "," instead of dot). Coma was placed by format function as decimal separator and I know it can be changed with /. but will I have a problem when I will try to get appropriate picture to form image?
I suppose I can have problem if decimal separator in application options will be set to . instead of , that is on my computer.
Also will this second dot "." in the filename be a problem when fileextension is in question?
Cris.
Last edited by kmeld; 12-12-2013 at 07:19 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks