Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Require update code so that it can save files in VBA7 Excel for both 32 & 64 bit versions
I have seen this but I end up getting an error message that I cannot fix. Can you please tell me where I put the new current directory so that the macro is error free? Sorry I am not familiar with Visual Basic or coding. I am just a data analyst.- VinoVino
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Require update code so that it can save files in VBA7 Excel for both 32 & 64 bit versions
Sure can. So I need the code to be able to handle the changes in VBA7. So needs to be able to work on both 32bit and 64 bit code for the set current directory part. I have looked on other forums and tried to follow their solutions but as of yet there has been no luck. Also I think...- VinoVino
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Require update code so that it can save files in VBA7 Excel for both 32 & 64 bit versions
Hi there. I have the following code that we are using to save a file to a pre-determined network address. However since migrating to the latest version of excel the below code does not work with the new version of VBA7, also 64 bit and 32 bit Excel versions is proving a bit of an issue...- VinoVino
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
