Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Read specific cell value and same value named Folder/file into c
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Read specific cell value and same value named Folder/file into c
Resolved · Low Priority · Version 2007
Reply Thu 9 Feb 2012, 12:11Delegate Palvinder said...
Palvinder has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Read specific cell value and same value named Folder/file into c
I read a specific cell Value in my current worksheet.
This cell value happens to be the same name of the FOLDER and FILE name in a specified path on the C: drive.
If found (only got one sheet in it) I want to copy and paste values
into my current workbook in a specified named work sheet.
Otherwise display file not found.
Appreciate you help on this
Kindest Regards
Pal
For upcoming training course dates see: Pricing & availability
RE: Read specific cell value and same value named Folder/file in
Hi Palvinder, sorry for the delay in getting back to you. Your query involves several different aspects already covered in our course material, such as moving data from one sheet to another and error trapping. One addition, however, is testing to see whether a file or folder exists which these links should help you with:
http://www.ozgrid.com/forum/showthread.php?t=43256
http://www.excelguru.ca/content.php?157
Hope this helps,
Anthony
Thu 23 Feb 2012: Automatically marked as resolved.
|