sourcefile

Hi. I faced strange behaviour of cells' values that are set as links to other workbook in the following manner: ='\\servername\foldername\[ExternalSource.xlsx]Sheet1'!A1 In general, there are 3 workbooks. One of them is external source which I refer to in way I've mentioned above. Other...

Hello, everyone, I was able to figure this macro out almost completly. However, I'm missing a piece which I never dealt with before. Basically, I have one excel file which I update monthly and I need to get the figures from a colleague's workbook. However, the code below doesn't compute lr2...

I'm trying to come up with a routine that allows a user to browse to a file and then copy it to the same path as the active workbook - this is what I have so far; Dim SourceFile, DestinationFile SourceFile = Application.GetOpenFilename(FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Select...

Hi all, I am trying to use ADODB connection stuff to read and copy data from a closed book. The code will look for an excel file, read and copy the data into the sheet "PnL_T-1". Generally the macro will read the file dated as of yesterday (Date1), but sometimes I will need the macro to read...