save this file in folder and run macro and the new file created will be
saved in the same folder automatically
On Tue, Jun 7, 2011 at 8:25 PM, Greg wrote:
> Ok, I've added Microsoft shell and the error message has gone away but
> no file is created. I look into the folder I selected no Excel
>
Ok, I've added Microsoft shell and the error message has gone away but
no file is created. I look into the folder I selected no Excel
spreadsheet is created. Isn't that the way it suppose to work?
On Jun 7, 10:01 am, ashish koul wrote:
> have you added Microsoft shell control and automation in r
have you added Microsoft shell control and automation in refrences
tool -> reference -> Microsoft shell control and automation
On Tue, Jun 7, 2011 at 7:11 PM, Greg wrote:
> Thanks Ashish for your reply. When I use this macro I get the
> following error message:
>
> Compile error: User-define t
Thanks Ashish for your reply. When I use this macro I get the
following error message:
Compile error: User-define type not defined.
The following line in the macro code is highlighted:
Dim objShell As New Shell32.Shell
-Greg
On Jun 7, 2:22 am, ashish koul wrote:
> try this
>
> http://akoul.bl
try this
http://akoul.blogspot.com/2011/02/merge-data-from-multiple-sheet-from.html
see if it helps
On Tue, Jun 7, 2011 at 2:37 AM, Greg wrote:
> Hi,
>
> I am trying to use a macro which copies multiple workbooks into a
> single workbook. However, something is going awry. The only thing it
> d
Hi,
I am trying to use a macro which copies multiple workbooks into a
single workbook. However, something is going awry. The only thing it
does is create a blank Worksheet is created.
Can someone explain why this is happening? I copied the macro from the
following weblink:
http://excelribbon.tip