Problems again with vb.net code vs vba regarding SaveAs

[Taemex]

This is my modified vba code:

Please Login or Register  to view this content.

I don't see anything wrong with it, however the code in ide is red and says:

Compile Error,

Expected: "="

As far as I can tell, everything looks fine. Here's the full code leading up to that section if that helps:

Please Login or Register  to view this content.

I'm sure it's some small difference between vba and vb.net again, as even the msdn seems to support my code: msdn

[nilem]

it works for me

Please Login or Register  to view this content.

[karedog]

Hi,

To get the "Desktop" path in VBA, use this :

Please Login or Register  to view this content.

Regards

[Kaper]

Try:

Please Login or Register  to view this content.

parentheses would be needed only if you call this method as a function (want some reuslut returned).

[Taemex]

Thank you to everyone who's helped me so far. When I run this section of the code, everything seems to work fine until it saves, at which point it drops me a run-time error 1004:

Microsoft Excel cannot access the file
'C:\Users\MyName\Desktop\Transmittals\Gibberish'.

Note where I put gibberish; every time I tun the code, that section outputs with something different, some random letters and numbers, but always starts with a number, then some letters, then numbers, and ends with an apostrophe (i.e. 9DD52000', or 63B72000'. I added a msgbox before it to be sure strCleanDate was outputting a valid string and it definitely does, as in: 12_13_2014.

Here is the updated code, still giving me trouble, after the edits:

Please Login or Register  to view this content.

[Taemex]

I've narrowed it down by removing all variables I could. In it's simplest form (below), I still get the error:

Please Login or Register  to view this content.

Which says to me something is getting screwed up between "\Transmittals\" and the & sign, but I'm not sure how this is possible.

EDIT: I got it to save by removing the path and only keeping the file name, however instead of saving in the "current folder", it saves in documents... Anyway, this isn't a solution, as I still need it to save on the path. But it tells me the problem is in the path itself, either strPath, or \Transmittals\.




EDIT: wow, I'm an idiot. Wrong folder name on desktop....was supposed to be Transmittals v2...... problem solved!