Hello.
I am trying to open a folder with shell.
When I use the following code in the immediate window it works properly.
however when I put in this code in the module I get a syntax error.
Please Login or Register to view this content.
I tried to remove the "(" & ")" from the equation however it stops working.
Please advise what I'm doing wrong.
Thank you for your help in advance
In regular VBA code, no symbol is needed preceeding the Shell command. Here is a link to the MS spec sheert.
https://support.office.com/en-us/art...6-6832EADD3C63
It looks like you might have the path and file reversed.
Last edited by JLGWhiz; 04-26-2018 at 04:43 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thank you for your reply
that's exactly my problem.
When I input the following :
inside a macro it stops working.Please Login or Register to view this content.
Anybody have ideas for solutions?
what am I writing wrong?
Eli
The ? is used in the immediate window to display variable content or return values from a function call.
The help on shell says.
So when I try it I get the value 4752 displayed in the immediate window.Runs an executable program and returns a Variant ( Double ) representing the program's task ID if successful, otherwise it returns zero
In order to run the command in a routine you can either display the value or not. Use MsgBox instead of ?
Please Login or Register to view this content.
Hi Andy
Thank you for your help.
My problem was that I did not use the quote mark before the explorer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks