Hi, I have made a code in VBA and it works :cool::cool::cool:
but now I really do not know what I've done. Is there any one that can help me explain the VBA CODE below :D
Public Sub GenerateDelayedCharts()
'Assignment 6
Dim lrow As Long
Dim i As Long
Dim crt As Shape
Dim ssh As Worksheet...
In the below code, I am trying to append the data in the file destinationpath & CRT_File_Backlog to the bottom of the access database table, strAccPath & tbl_backlog
destinationpath & CRT_File_Backlog(excel 2013 .xlsx) >>>>>>>> strAccPath & tbl_backlog(Access 2003 dbo)
The VBA editor is...
So the code below is supposed to create a folder (Which is does) and then save these 4 files to the folder. The problem is that it won't save them. The code does not error, but it won't save them. What am I missing here?
Thanks guys. I know one of you smarties can help me.
If...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.