How to remove image with VB?
Solved/Closed
Janit
-
19 Feb 2015 à 18:56
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 20 Feb 2015 à 12:42
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 20 Feb 2015 à 12:42
Related:
- How to remove image with VB?
- How to remove search baron - Guide
- Remove wga - Download - Cleaning and optimization
- Broken image icon - Guide
- Windows 10 iso image free download - Download - Windows
- How to remove firefox as default browser - Guide
4 responses
Soaping_Gal
Posts
3
Registration date
Thursday 19 February 2015
Status
Member
Last seen
20 February 2015
19 Feb 2015 à 21:40
19 Feb 2015 à 21:40
solved!
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Moderator
Last seen
6 September 2024
262
19 Feb 2015 à 23:41
19 Feb 2015 à 23:41
Hello Janit,
This looks familiar!
Solved by Soaping_Gal (same IP)? Could you please post your resolution so that all can see. That's what these type of forums are all about. Help one, help all.
If you are still having issues with the above code, please post back as we will still be able to help.
Kind regards.
vcoolio
(Moderator).
This looks familiar!
Solved by Soaping_Gal (same IP)? Could you please post your resolution so that all can see. That's what these type of forums are all about. Help one, help all.
If you are still having issues with the above code, please post back as we will still be able to help.
Kind regards.
vcoolio
(Moderator).
Soaping_Gal
Posts
3
Registration date
Thursday 19 February 2015
Status
Member
Last seen
20 February 2015
20 Feb 2015 à 11:11
20 Feb 2015 à 11:11
no, same person...ME :D solved! my other topic and started a new one as I was trying to resolve a new issue. So while waiting for a reply i simply researched, researched and researched along with quite a bit of trial and error.
Soaping_Gal
Posts
3
Registration date
Thursday 19 February 2015
Status
Member
Last seen
20 February 2015
20 Feb 2015 à 08:33
20 Feb 2015 à 08:33
This macro works with Excel 2003, will save, remove macro object, close saved project and increment invoice number. Thank you so much for all the help you provided when I was stuck making my first macro :D
Sub NextTicket()
Range("S1").Value = Range("S1").Value + 1
Range("C7:G9").ClearContents
Range("J8:M8").ClearContents
Range("J9:M9").ClearContents
End Sub
Sub SaveTicketWithNewName()
Dim NewFN As Variant
' Copy Ticket to new workbook
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Copy
ActiveSheet.Shapes.Range(Array("savemacro")).Delete
NewFN = "C:\Users\Janit\Desktop\" & Range("S1").Value & ".xls"
ActiveWorkbook.SaveAs NewFN
ActiveWorkbook.Close
NextTicket
End Sub
Sub NextTicket()
Range("S1").Value = Range("S1").Value + 1
Range("C7:G9").ClearContents
Range("J8:M8").ClearContents
Range("J9:M9").ClearContents
End Sub
Sub SaveTicketWithNewName()
Dim NewFN As Variant
' Copy Ticket to new workbook
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Copy
ActiveSheet.Shapes.Range(Array("savemacro")).Delete
NewFN = "C:\Users\Janit\Desktop\" & Range("S1").Value & ".xls"
ActiveWorkbook.SaveAs NewFN
ActiveWorkbook.Close
NextTicket
End Sub
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Moderator
Last seen
6 September 2024
262
20 Feb 2015 à 12:42
20 Feb 2015 à 12:42
Hello Soaping_Gal/Janit,
Well done!
Glad I could help.
Cheerio,
vcoolio.
Well done!
Glad I could help.
Cheerio,
vcoolio.