Hi all,
with the following the VBA should open a "save as" window in Folder G:\Shareplan\test_31686\Plan\07\
The user should choose a subfolder for example G:\Shareplan\test_31686\Plan\07\test123\ to save the file.
The filename should be contrib_per_payroll_check_ & Tag --> for example "contrib_per_payroll_check_170405.
Could you please check what is wrong in my code?
Kind regards,
Please Login or Register to view this content.
Thorsten
Last edited by torti111; 04-05-2017 at 05:13 AM.
You need to explain what's happening.
"The code have an error"
So what error message is being displayed (if any)?
Or does it just not seem to do anything?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi,
I get the following error message "Can't assign to read-only property"
Kind regards,
Thorsten
Last edited by torti111; 04-05-2017 at 05:15 AM.
This is connected to Sun Systems Reporting Vision isn't it?
I don't know anything about that.
Maybe someone will reply who knows what this error means.
Try this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you for your help.
But if I use your code, I am not in the correct path: G:\Shareplan\test_31686\Plan\07\ to choose the subfolder G:\Shareplan\test_31686\Plan\07\Q1.....
If I clicked to the correct subfolder and click ok, it should save the file with Name "contrib_per_payroll_check_170405" automatically.
Kind regards,
Thorsten
If the folder exists this line
will ALWAYS BE THE STARTING directory of the dialog box and present you all the subfolders of that directoryPlease Login or Register to view this content.
thanks a lot, again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks