Hello everyone.
as correcting the part of the macro < if-then >:
If Excel 2003 = sPath = "C:\Documents and Settings\" & username & "\Documenti\rapportini_ore_straordinarie" 'excel 2003
Please Login or Register to view this content.
if excel 2007 = sPath = "C:\Users\" & username & "\Documents\rapportini_ore_straordinarie" 'excel 2007
I hope I was clear.
max_max
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thanks daffodil11.
The selection is automatically according to the installed version?
The modification must run on excel 2003 and 2007
A greeting and thanks.
max_max
Last edited by max_max; 07-01-2016 at 02:36 PM.
It works well, I entered the exact change.
Thanks daffodil 11.
max_max
Last edited by max_max; 07-01-2016 at 02:54 PM.
A curiosity.
If the application.version was superior to excel 2007 (I do not have a chance to try) the modification work?
max_max
No, but we can accommodate that as well.
or you could just do a later or earlier than coercionPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you so much daffobil11.
A greeting.
max_max
------------------------------------
Ti ringrazio tantissimo daffobil11.
Un saluto.
max_max
Hello can this change?
max_maxPlease Login or Register to view this content.
Last edited by max_max; 07-02-2016 at 03:17 PM.
Please Login or Register to view this content.
Thanks daffodil 11
I think it's entirely accurate.
I have to try the macro tomorrow morning.
A greeting and thanks.
max_max
It was an interesting challenge! Glad to have helped.
Not work in window xp - excel 2003
Work in Windows 7 - excel 2007
max_max
I will try harder!
Hello daffodil 11
After many tests I changed so:
and it is accurate or just a case of luck?Please Login or Register to view this content.
max_max
A little bit of both!
I'm no VBA expert, I just know enough to be dangerous. Looks like you got it work just fine!
The macros can be dangerous?
I meant I know enough to do effective, yet basic tasks. I'm still terrible at many, many things in VBA.
As a side note, VBA can be dangerous. THIS VBA macro is not dangerous. But even an antiquated programming language such as VBA can still do terrible, terrible things such as wipe computers, self-replicate, ie anything a normal computer virus does.
This is why anytime you open a *.xlsm you do not recognize, you should first open it with macros disabled and examine the code and make sure none of the code is locked or hidden. Only allow macros to run on a unknown workbook when you are sure it poses no threat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks