sfile

Hello All, I need help to figure out what I am doing wrongly here: I wanna load image control on my worksheet with this script but I think i am doing something wrongly since I can't get the result. Sub ShowPic () Dim fPath As String, sFile As String On Error resume next fPath =...

Don't do much macro stuff in Excel. I have this piece of code I found somewhere a while back and have been using for some time. My question is, what code would I add to make it center the image in the cell vertically and horizontally? Sub piccy() Dim sFile As Variant, r As Range, s As Range...

I'm looking at a way to resize an image placed into a cell so that it does not exceed the cell height or width whilst maintaining it's aspect ratio, in other words as soon as the height or width meets the cell width or height then it stops resizing. I've found this in another post which goes...

hello, I am trying to convert lines of data to XML format and save them however I keep getting the error : 'Run-time error '-2147024773 (8007007b)': The filename, directory name, or volume label syntax is incorrect.' The 'doc.Save sFile' gets highlighted when i click debug. I ma very new to...

I am completely new to VBA. I know only enough to copy paste and make simple edits to existing code. I have some code that I have used in the past on less complicated reports. When I try to use it now, I see that it is cycling through/opening the files in the folder, and it creates the new...

Hi All, I found this code online and tried to adapt it to suit my needs but i'm not having much luck. I would like to copy my test file to my weekly backup folder and include today's date in the name of the backup file when it has been copied over. Any help would be appreciated, Thanks in...

I am trying to copy a workbook and save it as a new file. The problem, using the code below, is that it references the macros in the new workbook back to the original. I need the macros copied along with the workbook. Can someone tell me if I am missing something or just going about it...

Hi all new here but I am trying to create a button that will export and invoice to a PDF file that a user can name as they please. Currently the save as box comes up but regardless of what is typed it save it as the workbook name. Any and all help is appreciated. Code is below. Private Sub...